Using the chart provided below please answer the business applications of project management below. The topic is data properties and intro to the relational model.

SHIPMENTS ShipmentNumber Shipper ShipperPhone ShipperContact From Departure Arrival Items 49100300 Worldwide 800-555-1245 Jose Mumbai 15-May-21 30-Jun-21 dining set, large desk, porcelain lamps 488955 International 800-555-6758 Marilyn Singapore 15-Jun-21 25-Jul-21 bamboo chairs, custom paintings 84899440 Worldwide 800-555-1245 Jose Lima 16-Jul-21 woven baskets, leather chairs 399400 International 800-555-6758 Marilyn Mumbai 2-Aug-21 28-Sep-21 large desk, brass lamps, 25-pc dish set PURCHASES Item Store City SalesPerson Price dining set India Treasures Mumbai J. Shah $14,000 bamboo chairs Jade Antinques Singapore A. Lee $4,200 large desk India Treasures Mumbai C. Ranga $55,000 brass lamp Eastern Exports Mumbai S. Patel $5507 OF 7 QUESTIONS REMAINING Assignment Content A small antiques reseller tracks what it buys around the globe in a basic spreadsheet and wants to modernize. The attached, sample data below shows some of its purchases and subsequent shipment details. As you'll see, these two tables of information are not fit to maintain in a database as-is. SampleData-NormalizeExercise.pdf A ... Based on what you have learned in this module, answer the following questions to redesign the data sets for a relational database. Question 1 Point The SHIPMENTS table would be defined as a relation (1NF) A True B False Question 2 1 Point The PURCHASES table would be defined as a relation (1NF) A True B False Question 3 1 Point Based on the provided PURCHASES data, the following functional dependency could be stated: Item -> Price A True B False7 OF7 QUESTIONS REMAINING Question 4 Based on the provided PURCHASES data, the following functional dependency could be stated: (City, Store) > SalesPerson ([9 True False Question 5 What is a potential com posite, candidate key from the current attributes in the PURCHASES table? (Item, Store) (Itemr Store. City) (9 (Item, Store. City, SalesFerson) @ None applicable Normalize the SHIPMENTS set of data to 3N F. List the new table definitions showing all attributes (columns) and the primary and foreign Keys using this format: TABLE NAME Attribute i (PK) Attribute 2 Attribute 3 (PK) (PK) = Primary Key (FK) : Foreign Key For referehce, here is an example for a student table: STUDENT ZID (PK) First Name Last Name run...\" [run Question 6 5 Points Normalize the SHIPMENTS set of data to 3NF. List the new table definitions showing all attributes (columns) and the primary and foreign keys using this format: TABLE_NAME Attribute 1 (PK) Attribute 2 Attribute 3 (FK) (PK) = Primary Key (FK) = Foreign Key For reference, here is an example for a student table: STUDENT ZID (PK) First Name Last Name College (FK) Use the editor to format your answer Question 7 0 Points Document any assumptions you made to normalize SHIPMENTS here. Use the editor to format your answer Additional content You can add text, images, and files here