Question: Assume the following attributes : A, B, C, D, E, F and G with the candidate key : A and D and the following functional
Assume the following attributes : A, B, C, D, E, F and G with the candidate key : A and D and the following functional dependencies : A - B, F A, D - C, E F - G 1) Draw the 1NF relational model and indicate the different type of dependencies using arrows. Do not forget to write the type of the dependency in your 1NF. (2 pts) 2) Draw the 2NF relational model and indicate remaining dependencies. (2 pts) 3) Draw the 3NF relational model and represent the referential integrity between the relations. (1 pts) You can use tools such as Diagrams.net to draw your relational models.
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
