Foreign key attribute
computer science
Description
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]
