Back to Database Management System

Database Architecture & Models

Understand the 3-level architecture, data independence, and the fundamental data models: ER, relational, hierarchical, and network models.

1 week

Topics in this Chapter

1

3-Level Architecture

Learn about the ANSI-SPARC three-level architecture (Internal, Conceptual, External).

2

Data Independence

Understand physical and logical data independence and their importance.

3

ER Model

Learn the basics of the Entity-Relationship model for database design.

4

Relational Model

Understand the most widely used data model: the relational model.

5

Hierarchical & Network Model

Briefly explore the legacy hierarchical and network data models.

GeekDost - Roadmaps & Snippets for Developers