Posted in Information Technology & Systems, Total Reads: 297
A database schema is the structure of a database. It defines how data is organized in different tables and what the relationships between these tables are. In other words it represents the logical view of entire database. It can be also explained as metadata of the database consisting of various objects. Some of these objects are tables, views, triggers, sequences, indexes, dimensions, clusters etc.
Broadly database schema can be divided in 2 categories:
Physical database schema: It refers to the actual storage of data files in secondary storage.
Logical database schema: It refers to the logical constraints that is needed to be applied on the data stored in databases. Example of such logical constraints are or example views, tables etc.