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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!