5. The following dependency diagram is given: C1 C2 C3 Describe the following dependencies: a) C1...

 

Transcribed Image Text:

5. The following dependency diagram is given: C1 C2 C3 Describe the following dependencies: a) C1 C2 (2 points) C4 C5 a. b) C4 C5 (2 points) c) C1, C3 C2, C4, C5 (2 points) d) Create a database whose tables are at least in 2NF and show the dependency diagrams for each table (10 points) e) Create a database whose tables are at least in 3NF, showing the dependency diagrams for each table (9 points) Activate Wind Go to Settings to 5. The following dependency diagram is given: C1 C2 C3 Describe the following dependencies: a) C1 C2 (2 points) C4 C5 a. b) C4 C5 (2 points) c) C1, C3 C2, C4, C5 (2 points) d) Create a database whose tables are at least in 2NF and show the dependency diagrams for each table (10 points) e) Create a database whose tables are at least in 3NF, showing the dependency diagrams for each table (9 points) Activate Wind Go to Settings to

Answer rating: 100% (QA)

a C1 C2 2 points The dependency C1 C2 means that the value of C2 is determined by the value of C1 In other words for any given value of C1 there is on... View the full answer