Database Design - Normalization
kinajamjs
cgs2541_project_5_answer_form.docxCGS2541 Project 5
Name Click here to enter text. Section # Click here to enter text.
1. What is normalization?
Click here to enter text.
2. When is a table in 1NF?
Click here to enter text.
3. When is a table in 2NF?
Click here to enter text.
4. When is a table in 3NF?
Click here to enter text.
5. When is a table in BCNF?
Click here to enter text.
Questions 6 and 7 are based on the Table shown below:
6. What changes do we have to make to be sure the table(s) is in 3rd normal form?
Click here to enter text.
7. What would the ERD look like for our normalized tables?
Answer Questions 8-10 based on the diagram below
The dependency diagram below indicates that authors are paid royalties for each book that they write for a publisher. The amount of the royalty can vary by author, by book, and by edition of the book.
Book Royalty dependency diagram
8. Based on the dependency diagram above, create a database whose tables are at least in 2NF, showing the dependency diagram for each table.
9. Create a database whose tables are at least in 3NF, showing the dependency diagram for each table.
10. What would the ERD relationship diagram look like based on our 3rd normal form dependency diagram?
