VINE VALLEY FURNITURE

Draw an ERD based on the following requirements. Include in your ERD all entities, attributes,

PK$,$ FK$,$ relationships and cardinality. State any assumptions that u may have in developing

the ERD.

$$ 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$.$ We identify the following additional attributes for product:

Product$\_$Description, Product$\_$Finish, and Standard$\_$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.

$$ A given customer order must request at least one product and only one product per any order

line. Any product sold by Pine Valley Furniture may not appear on any order line item or may

appear one or more order line items. An attribute associated with each order line item is

Ordered$\_$Quantity.

$$ Pine Valley Furniture has established sales territories for its customers. Each customer may

do business in any territory. A sales territory has one$-$to$-$many customers. The identifier for a

sales territory is Territory$\_$ID and an attribute of a Territory$\_$Name.

$$ Pine Valley Furniture 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 specified quantity of one or more raw materials. The identifier

for the raw material entity is Material$\_$ID$.$ Other attributes include Unit$\_$of$\_$Measure,

Material$\_$Name, and Standard$\_$Cost. Each raw material is assembled into one or more

products, using a specified quantity of the raw material for each product.

$$ 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 Pine Valley Furniture. An attribute of the relationship between vendor and

raw material is Supply$\_$Unit$\_$Price.

$$ Pine Valley Furniture has established a number of work centers. The identifier for a work center

is Work$\_$Center$\_$ID$.$ Another attribute is Work$\_$Center$\_$Location. Each product is produced in

one or more work centers. A work center may be used to produce any number 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 include Employee$\_$Name, Employee$\_$Address, and Sill. An employee may have one

or more skill. Each employee may work 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 except managers, who has no supervisor. An

employee who is a supervisor may supervise any number of employees, but not all employees

are supervisors