Question 1: Data Normalization. [10 points] Tables T ABCD below has its primary

Question

Question 1: Data Normalization. [10 points]

Tables TABCD below has its primary key attributes underlined:

TABCD    (A, B, C, D, E, F, G, H, I, J, K, L, M, N, O, P)

Decompose table TABCD into tables in the third normal form using the functional dependencies specified below:

1. B                ®         E, F, G, H, I, J

2. D                ®         K, L

3. E                ®         I, J

4. M               ®         N

5. O               ®         P

Give each table a unique name TNAME where “NAME” is formed by concatenating the attributes in its primary key. Underline the primary key attribute(s) in each table.

For each applicable table specify the foreign key attribute(s) as:

FK [Attribute_Name] references [Table_Name]

Explanation / Answer

Following tables can be constructed:

Related Questions

Navigate

• Browse (All)
• Browse Q
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.