Process of designing a database’s structure.
Physical design
Section titled “Physical design”Deciding on the physical layout of the database.
Logical design
Section titled “Logical design”Deciding on the database schema. Affected by business decisions and computer science considerations.
This module focuses on the logical design.
Design approaches
Section titled “Design approaches”Entity-Relationship Model is used widely.
Normalization
Section titled “Normalization”A technique used to ensure the quality of a database design. Explained briefly in Normalization.
Architecture
Section titled “Architecture”Architecture of a database system is influenced by the underlying computer system.
Examples:
- Centralized
- Client-server
- Parallel
- Distributed