Using Lucid Chart, develop an E-R diagram based on the user requirements bellow, then transform your E-R diagram to a relational data model.

Furniture Row hired you as a database intern for the semester. To assess your database knowledge, the manager asked you to perform conceptual design (E-R diagram) and logical design (relational data model):

1. The company sells a number of different furniture products. a. The identifier for a product is Product ID b. Additional attributes for product: Product Description, Product Finish, and Product Price.

2. Customers submit orders for products. a. The identifier for a customer is Customer ID. Other attributes of a customer include Customer Name and Customer Address. b. The identifier for an order is Order ID, and another attribute for an order is Order Date. c. A customer may submit any number of orders, but must submit at least one order. d. Each order is submitted by exactly one customer.

3. A given order can request different products. a. A given order may request one or many products. b. A product may not be requested on any order, or may be requested on many orders.

4. Furniture Row has established sales territories for its customers. a. The identifier for a sales territory is Territory ID. b. Each customer does business in one and only one sales territory. c. A sales territory may have any number of customers, or may not have any customers doing business.

5. Furniture Row has several salespersons. a. The identifier for a salesperson is Salesperson ID. Other attributes include Salesperson Name, Salesperson Telephone, and Salesperson Fax. b. A salesperson serves one or more sales territories. c. Each sales territory is served by one or more salespersons.

6. Each product is assembled from raw materials. a. The identifier for the raw material entity is Material ID. Other attributes include Material Name and Unit of Measure. b. Each product is assembled from one or more raw materials c. Each raw material may be assembled into one or more products.

7. Raw materials are supplied by vendors. a. The identifier for a vendor is Vendor ID. Other attributes include Vendor Name and Vendor Address. b. Each raw material can be supplied by one or more vendors. c. A vendor may supply any number of raw materials, or may not supply any raw materials. d. When a vendor supplies a raw material, we also record the Unit Price (attribute for supplies relationship type).

8. Furniture Row has established a number of work centers. a. The identifier for a work center is Work Center ID. Another attribute is Location. b. Each product is produced in one or more work centers. c. A work center may be used to produce any number of products, or may not be used to produce any products.

9. The company has employees. a. The identifier for employee is Employee ID. Other attributes are Employee Name, Employee Address, and Skills. An employee may have more than one skill. b. Each employee works in one and only one work center. c. A work center must have at least one employee working in that center, and may have many employees.