Foreign key attribute

Tables Tabc and Tjk below have their primary key attributes underlined: TAB (A, B, D, E, F, G, H, J) TKL (K, L, M, N, O, P, Q, R) Decompose these tables into tables in the third normal form using the functional dependencies specified below: 1. A  G, H 2. B  D, E, F 3. E  F 4. H  G 5. L  N, O, P, Q 6. N  Q Give each table a unique name. Underline the primary key attribute(s) in each table. Specify the foreign key attribute(s) as: FK [Attribute_Name] references [Table_Name]

 

Looking for a Similar Assignment? Let us take care of your classwork while you enjoy your free time! All papers are written from scratch and are 100% Original. Try us today!