Database Design Principles
Computer Science · University of Applied Sciences · Database Management Systems
This unit introduces the fundamental principles of database design, including normalization, denormalization, and referential integrity. Students will also learn about entity-relationship (ER) modeling and how to convert ER diagrams to relational schemas.
What's included
- Normalization forms (1NF
- 2NF
- 3NF
- BCNF)
- Denormalization techniques
- Referential integrity constraints
- Entity-relationship modeling symbols and notation
- Mapping ER diagrams to relational schemas
- Database design best practices
Keywords
- Normalization
- Denormalization
- Referential Integrity
- Entity-Relationship Modeling
- Database Design
- Relational Schemas