DBMS - Data Schemas




DBMS - Data Schemas

Database Schema

A database schema is the skeleton structure that represents the logical view of the entire database. It defines how the data is organized and how the relations among them are associated. It formulates all the constraints that are to be applied on the data.

A database schema defines its entities and the relationship among them. It contains a descriptive detail of the database, which can be depicted by means of schema diagrams. It’s the database designers who design the schema to help programmers understand the database and make it useful.

DBMS - Data Schemas

A database schema can be divided broadly into two categories −

  • Physical Database Schema − This schema pertains to the actual storage of data and its form of storage like files, indices, etc. It defines how the data will be stored in a secondary storage.

  • Logical Database Schema − This schema defines all the logical constraints that need to be applied on the data stored. It defines tables, views, and integrity constraints.

Database Instance

It is important that we distinguish these two terms individually. Database schema is the skeleton of database. It is designed when the database doesn't exist at all. Once the database is operational, it is very difficult to make any changes to it. A database schema does not contain any data or information.

A database instance is a state of operational database with data at any given time. It contains a snapshot of the database. Database instances tend to change with time. A DBMS ensures that its every instance (state) is in a valid state, by diligently following all the validations, constraints, and conditions that the database designers have imposed.



Frequently Asked Questions

+
Ans: DBMS - Data Models view more..
+
Ans: DBMS - Architecture view more..
+
Ans: DBMS - Overview view more..
+
Ans: DBMS - Data Schemas view more..
+
Ans: DBMS - Data Independence view more..
+
Ans: ER Model - Basic Concepts view more..
+
Ans: ER Diagram Representation view more..
+
Ans: Generalization Aggregation view more..
+
Ans: Codd's 12 Rules view more..
+
Ans: Relation Data Model view more..
+
Ans: Relational Algebra view more..
+
Ans: ER Model to Relational Model view more..
+
Ans: SQL Overview view more..
+
Ans: DBMS - Normalization view more..
+
Ans: DBMS - Joins view more..
+
Ans: DBMS - Storage System view more..
+
Ans: DBMS - File Structure view more..
+
Ans: DBMS - Indexing view more..




Rating - NAN/5
543 views

Advertisements