A schema is essentially the top level structure (topology) of a database.
It is what defines what tables will hold what and how they join together from table to table.
It is prevalent in all types of databases and also in data warehouse structures. It is this which is debated at design level in order to get the best out of the database and/or data warehouse.
There are different types of Schema including Start and Snowflake.