What is Database Schema?

A Schema is structure for a database. The term is often used to refer either a text oriented description or a graphical depiction of the database structure. The term is being used both in Relational Database Management System (RDBMS) & Object (Oriented) Database Management System (ODBMS). Both in RDBMS & ODBMS the Schema define the tables, the fields in each table, and the relationship between fields & tables. 
ODBMS is being used in real time systems & to power websites.

The Star & Snowflake are the example of two common types of Schema.

No comments:

Post a Comment