Table 4-3 contains sample data for parts and for vendors who supply those parts. In discussing these data with users, we find that part numbers (but not descriptions) uniquely identify parts and that vendor names uniquely identify vendors.

a) Convert the table above to a relation in the first normal form. Illustrate the relation with the sample data in the table. (5 Marks)

b) Draw the functional dependencies (show the full, partial, and transitive dependencies if applicable) (5 Marks)

c) Draw a relational schema for your 3NF relations and show the referential integrity constraints. (5 Marks)

a) Decompose Grade Report Relation Data into a set of 3NF relations and Draw the functional dependencies (show the full, partial and transitive dependencies if applicable) (5 Marks)

b) Draw a relational schema for your 3NF relations and show the referential integrity constraints. (5 Marks)

Task 1: Transform Table4-3 to relations: Task 2. Transform the GRADE REPORT to relations