(a) Regional Labs is a company that conducts research and development work on a contract basis for other companies and organizations.

This data is stored in a relation (table) named PROJECT:

PROJECT (ProjectID, EmployeeName, EmployeeSalary)

Here ProjectID and EmployeeName form a composite primary key. Determine the Normal Form of the table PROJECT. Show reasoning as to why a certain normal form is chosen. [2 Marks]

(b) Consider the Purchase Table below:

below:

PurchaseItem and PurchaseDate together form a composite primary key. Also, the phone attribute is Vendors phone numbers and is dependent on the Vendor attribute.

Describe and illustrate the process of normalizing the data shown in this table to third normal form (3NF)? Basically, design the tables with its attributes and keys which will be formed as a result of the table converted to a 3NF. Show the resulting tables below. You can use crows foot notation if needed to display the tables. Displaying data is not mandatory. Proper display of the resulting #NF normalised Table Schema is what is needed. [3 Marks]