Database Design Principles
Advanced Diploma in Information Technology · Vocational Academy · Database Management Systems
This unit introduces the fundamental principles of database design, including normalization, entity-relationship modeling, and data modeling techniques. Students will gain a comprehensive understanding of the methodologies and best practices involved in designing effective and efficient databases.
What's included
- Normalization: First Normal Form (1NF)
- Second Normal Form (2NF)
- Third Normal Form (3NF)
- Boyce-Codd Normal Form (BCNF)
- Entity-Relationship Modeling: Entities
- Attributes
- Relationships
- Cardinality
- Degree
- Data Modeling: Conceptual Data Model
- Logical Data Model
- Physical Data Model
Keywords
- Normalization
- Entity-Relationship Modeling
- Data Modeling
- Database Design Methodologies
- Functional Dependencies
- Primary Keys
- Foreign Keys
- Database Integrity
- Database Performance