1nf table format no repeating groups pk identified 2nf 1nf and no partial dependenci 5148901
|
1NF |
Table format, no repeating groups, PK identified |
|
2NF |
1NF and no partial dependencies |
|
3NF |
2NF and no transitive dependencies |
|
Transitive Dependencies |
A non-key attribute determines the value of another non-key attribute |
-
Given the dependency diagram shown in Figure 1 below.
-
Identify and discuss each of the indicated dependencies.
-
Create a database whose tables are at least in 2NF, showing the dependency diagrams for each table.
c. Create a database whose tables are at least in 3NF, showing the dependency diagrams for each table.
C1 C2 C3 C4 C5