Assume the following attributes : A, B, C, D, E, F and G with the candidate key : A and C and the following functional dependencies :

A --> B, F

A, C --> D, E

F --> G

a. 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. 

 

b. Draw the 2NF relational model and indicate the remaining dependencies. 

 

c. Draw the 3NF relational model and represent the referential integrity between the relations.