A Database is basically a structured collection of data or records which are stored in a computer system. This structure is gained by proper organization of data through the database model.
On the other hand, the word Schema itself stands for shape or plan. Thus this word is mostly used for models or diagrams or formal logic. As far as databases are concerned, Database Schema is the structure that is described in the programming language and is supported by database management systems.
Thus Schema is the graphical depiction of the structure of the database system. And database itself is the structured collection of data.
In any data model, it is important to distinguish between the description of the database and the database itself. The description of a database is called the database schema. WHERE A database is an integrated collection of logically-related records or files consolidated into a common pool that provides data for one or more multiple uses. One way of classifying databases involves the type of content, for example: Bibliographic, full-text, numeric, image. Other classification methods start from examining database models or database architectures:
A relation schema is the logical definition of a table - it defines what the name of the table is, and what the name and type of each column is. It's like a plan or a blueprint. A database schema is the collection of relation schemas for a whole database.
A table is a structure with a bunch of rows (aka "tuples"), each of which has the attributes defined by the schema. Tables might also have indexes on them to aid in looking up values on certain columns.
A database is, formally, any collection of data. In this context, the database would be a collection of tables. A DBMS (Database Management System) is the software (like MySQL, SQL Server, Oracle, etc) that manages and runs a database.
