Week 6:
Relational Database Theory and Normalization - Download PowerPoint
Topics Include:
Related Readings:
Assignment 3: For this assignment, you are required to work on the following problem:
Page 202 Case: Mountain View community Hospital.
Case Exercise 1 a), b), c) and d).
Provide your solution in word file. Name the file using your last name and assignment information.
Relational Database Theory and Normalization - Download PowerPoint
Topics Include:
- Well Formed Relations
- Data Anomalies
- Functional Dependencies
- First Normal Form
- Second Normal Form
- Third Normal Form
- BCNF
- 4NF
Related Readings:
- Chapter 4 from Modern Database Management
Assignment 3: For this assignment, you are required to work on the following problem:
Page 202 Case: Mountain View community Hospital.
Case Exercise 1 a), b), c) and d).
Provide your solution in word file. Name the file using your last name and assignment information.