What is a database schema? - microsoft solution framework

What is a database schema?

Database schema is a formally described structure in terms of DBMS. In an RDBMS, schema is defined using database tables, fields, and relationships (foreign keys).

A database schema is stored in textual format in the data dictionary but is often represented in a graphical format depicting the structure and arrangement of the tables along with their relationships.

There are 4 levels of database schema:

- Conceptual
- Logical
- Physical
- Schema object
What are the types of physical data models? - microsoft solution framework
Types of physical data models - Flat-file, Hierarchical, Relational and object-oriented.......
Various relationships that can exist between database tables - MSF
One-to-One: Depicts that one instance of entity A is and can be only related to one instance of entity B. e.g.: Student->Class (One-to-One).......
Purpose of partitioning data - microsoft solution framework
Data is often partitioned to achieve better maintainability and accessibility. For example, in case of a data warehouse......
Post your comment