Problem 4. (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. Employee Salary) Here Projectld 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] Write Your answer in the space provided. (b) Consider the Purchase Table below: Purchaseltem Antique Desk Antique Desk Antique Candle Holders Antique Candle Holders Dining Table Linens Candles Desk Lamp Floor Lamp Dining Table Linens Candles Book Shelf Antique Desk Antique Desk Chair Antique Chair Antique Chair Purchase Price PurchaseDate 1,800.00 7-Nov-18 1,750.00 7-Nov-18 210.00 7-Nov-18 200.00 7-Nov-18 600.00 14-Nov-18 30.00 14-Nov-18 150.00 14-Nov-18 300.00 14-Nov-18 450.00 21-Nov-18 27.00 21-Nov-18 150.00 21-Nov-18 1,000.00 28-Nov-18 300.00 28-Nov-18 750.00 28-Nov-18 1,050.00 28-Nov-18 Vendor European Specialties European Specialties European Specialties European Specialties Linens and Things Linens and Things Lamps and Lighting Lamps and Lighting Linens and Things Linens and Things Harrison, Denise Lee, Andrew Lee, Andrew New York Brokerage New York Brokerage Phone 206-325-7866 206-325-7866 206-325-7866 206-325-7866 206-325-6755 206-325-6755 206-325-8977 206-325-8977 206-325-6755 206-325-6755 425-746-4322 425-746-5433 425-746-5433 206-325-9088 206-325-9088 Purchaseltem and Purchase Date together form a composite primary key. Also, the phone attribute is Vendor's 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] Problem 4. (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. Employee Salary) Here Projectld 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] Write Your answer in the space provided. (b) Consider the Purchase Table below: Purchaseltem Antique Desk Antique Desk Antique Candle Holders Antique Candle Holders Dining Table Linens Candles Desk Lamp Floor Lamp Dining Table Linens Candles Book Shelf Antique Desk Antique Desk Chair Antique Chair Antique Chair Purchase Price PurchaseDate 1,800.00 7-Nov-18 1,750.00 7-Nov-18 210.00 7-Nov-18 200.00 7-Nov-18 600.00 14-Nov-18 30.00 14-Nov-18 150.00 14-Nov-18 300.00 14-Nov-18 450.00 21-Nov-18 27.00 21-Nov-18 150.00 21-Nov-18 1,000.00 28-Nov-18 300.00 28-Nov-18 750.00 28-Nov-18 1,050.00 28-Nov-18 Vendor European Specialties European Specialties European Specialties European Specialties Linens and Things Linens and Things Lamps and Lighting Lamps and Lighting Linens and Things Linens and Things Harrison, Denise Lee, Andrew Lee, Andrew New York Brokerage New York Brokerage Phone 206-325-7866 206-325-7866 206-325-7866 206-325-7866 206-325-6755 206-325-6755 206-325-8977 206-325-8977 206-325-6755 206-325-6755 425-746-4322 425-746-5433 425-746-5433 206-325-9088 206-325-9088 Purchaseltem and Purchase Date together form a composite primary key. Also, the phone attribute is Vendor's 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]
