The following table 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.

	PartNo	Description	VendorName	Address	UnitCost
	1234	Logic Chip	Fast Chips	Cupertino	10.00
		Logic Chip	Smart Chips	Phoenix	8.00
	5678	Memory Chip	Fast Chips	Cupertino	3.00
			Quality Chips	Austin	2.00
			Smart Chips	Phoenix	5.00

3.1 . Convert this table to a relation (named PartSupplier) in first normal form.

3.2 for the relation of 3.1, identify a candidate key.

3.3 . For the relation PartSupplier, identify each of the following: an insert anomaly, a delete anomaly, and a modification anomaly.

3.4 . Draw a relational schema for PartSupplier and show the functional dependencies.

3.5 . In what normal form is this relation?

3.6 . Develop a set of 3NF relations from PART SUPPLIER.

1. 4. The following table shows a relation called GRADE REPORT for a university. Your assignment is as follows:

4.1. Draw a relational schema and diagram the functional dependencies in the relation.

4.2. In what normal form is this relation?

4.3. Decompose GRADE REPORT into a set of 3NF relations, and show the referential integrity constraints among relations.