Transform or map ERD into tables. Use the Azure Data Studio to access SQL Server software and use SQL to create the tables. Provide the metadata or schema to the instructor. Although the ERD Model is provided, you will not draw the ERD. You will just map the ERD into tables and use the Azure Data studio to access SQL Server and use SQL to create the tables on the database already created by the instructor for each student on the SQL Server. You will use the SQL Server and SQL to write metadata $($schema$)$ and build your tables on the SQL Server using your metadata $($schema$).$

The company sells a number of different furniture products. These products are grouped into several product lines. The identifier for a product is Product$\_$id while the identifier for a product line is Product$\_$line$\_$id$.$ Referring to the customer invoice, we identify the following additional attributes for

product Product$\_$Description$\_$Product$\_$Finish, and Unit$\_$Price. Another attribute for product line is Product$\_$Line$\_$Name. A product line may group any number of products, but must group at least one product. Each product must belong to exactly one product line.

Customers submit orders for products. The identifier for an order is Order$\_$ID$,$ and another attribute is Order$\_$Date. A customer may submit any number of orders, but need not submit any orders. Each order is submitted by exactly one customer. The identifier for a customer is Customer$\_$ID$.$ Other attributes include Customer$\_$Name and Customer$\_$Address $($Composite Attribute$).$

A given customer orders must request at least one product. Any product sold may not be requested on any order, or may be requested on one or more orders. An attribute associated with each order and product is Quantity, which is the number of units requested.

The company has established sales territories for its customers. Each customer does business in one or more of these sales territories. The identifier for a sales territory is Territory$\_$ID$.$ A sales territory may have any number of customers, or may not have any customers doing business.

The company has several salespersons. The identifier for a salesperson is Salesperson$\_$ID$.$ Other attributes include Salesperson$\_$Name, Salesperson$\_$Telephone, and Salesperson$\_$Fax. A salesperson serves exactly one sales territory. Each sales territory is served by one or more salespersons.

Each product is assembled from one or more raw materials. The identifier for the raw material entity is Material$\_$ID$.$ Other attributes include Unit$\_$of$\_$Measure and Unit$\_$Price. Each raw material may be assembled into one or more products.

Raw materials are supplied by vendors. The identifier for a vendor is Vendor$\_$ID$.$ Other attributes include Vendor$\_$Name and Vendor$\_$Address. Each raw material can be supplied by one or more vendors. A vendor may supply any number of raw materials, or may not supply any raw materials to the company. An attribute of the relationship between vendor and raw material is Unit$\_$Price.

The company has established a number of work centers. The identifier for a work center is Work$\_$Center$\_$ID$.$ Another attribute is Location. Each product is produced in one or more work centers. A work center may be used to produce any numbers of products, or may not be used to produce any products.

The company has over $100$ employees. The identifier for employee is Employee$\_$ID$.$ Other attributes are Employer$\_$Name, Employer$\_$Address, and Skill. An employee may have more than one skill. Each employee works in one or more work centers. A work center must have at least one employee working in that center, but may have any number of employees.

Each employee has exactly one supervisor. An employee who is a supervisor may supervise any number of employees, but not all employees are supervisors.