7.What is normalization?
8.When is a table in 1NF?
9.When is a table in 2NF?
10.When is a table in 3NF?
11.When is a table in BCNF?
12.Given the dependency diagram shown in Figure Q12.6, answer items 12a-12c:
FIGURE Q12.6 Dependency Diagram for Question 12C1C2C3C4C5a.Identify and discuss each of the indicated dependencies.
b.Create a database whose tables are at least in 2NF, showing the dependency diagrams for eachtable.
2NF (C1,
C2)
(C3
, C4, C5)
C1
C2
Transitive Dependencies
C4
C5
Create a database whose tables are at least in 3NF, showing the dependency diagrams for each
table.
Submit the questions and answers in a Word Document by clicking on the Assignment Link located in
the Assignment Submission Folder.
C5
C4
C3
C3
C4
C5
C1
C2
C4
You've reached the end of your free preview.
Want to read all 3 pages?
- Fall '17
- Steven King
