HOMEWORK 3

IS 4420

As an DB intern for Furniture Row, (HW3), you are asked to 1) transform the relational model (attached) to metadata, 2) then to SQL DDL, and 3) to be implemented in their new MySQL database. Export the .sql file for the furniture row database and submit to HW 3 on canvas.

Do note down any assumptions that you make if any information is missing in the homework

WORKCENTER WORKCENTER PRODUCT Product ID WorkCenter ID Workcenter ID Location PRODUCT LINE WORKCENTER EMPLOYEE Product line ID Product line name Workcenter ID Employee ID PRODUCT Product D Product desc Product finish Uni Product line ID EMPLOYEE price Employee ID Emp Name Address Supervisor ID PRODUCT-MATERIAL Product ID Material ID SKILL Employee ID Skill MATERIAL Material ID Unit of measure CUSTOMER-TERRITORY ORDERTABLE SUPPLIES Order D Order Date customer Customer D Territory ID Materia ID vendor ID Unit price CUSTOMER TERRITORY VENDOR Customer ID Cust name Address Territory ID Territory desc Vendor ID vendor Name Vendor address SALESPERSON ORDER PRODUCT SALESPERSON ID sName Phone Ierritory ID Product D Order ID Quantity