Design an ER schema for a furniture company, called Pine Valley Furniture. After

Question

Design an ER schema for a furniture company, called Pine Valley Furniture. After the requirements collection and analysis, we come up with the following description of the company. The company sells a number of different furniture products. The products are grouped into several product lines. The identifier for a product is product ID, whereas 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 must have at least one product. Each product must belong to only one product line. Customers submit orders for products. An order is described by the order date, and a unique order ID. A customer may submit any number of orders. Each order is submitted by only one customer. Each customer is described by the name, address, postal code, and a unique customer ID. A given customer order must request at least one product and the quantity of each ordered product is recorded. Pine Valley Furniture has established sales territories for its customers. Each customer may do business in any number of these sales territories. A sales territory has one-to-may customers. A sales territory is described by the territory ID and name. The territory ID is unique for each sales territory. The company has several salespersons. We need to store each salesperson's name, telephone number, fax. and ID. The ID is unique for each salesperson. A salesperson serves only one sales territory. Each sales territory is served by one or more salespersons. Each product is assembled from a specified quantity of one or more raw materials. We need to store each raw material's name, unit-of-measure. standard cost, and ID. The ID is unique for each material. 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. For each vendor, we need to store its name, address and vendor ID. The vendor ID is unique for each vendor. 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. For each material, we need to store the supply unit price of its vendor(s). The company has established a number of work centers, which are described by work center IDs and locations. Each product is produced in one or more work centers. A work center may be used to produce any number of products. The company needs to store each employees name, address, skill and employee ID, which is unique for each employee. An employee may have more than one skill, and may work in one or more work centers. Each employee has one supervisor except managers, who have no supervisor. A supervisor may supervise any number of employees.

Explanation / Answer

1) f(x) = -2csc(3x-5) + 6

a) Amplitude = None

b) Period = 2pi/3

c) Phase Shift = 5/3 to the right

d) Vertical Translation = 6

2) f(x) = (1/3)*cot(x + pi/2)

a) Amplitude = None

b) Period = pi

c) Phase Shift = pi/2 to the left

d) Vertical Translation = 0

Related Questions

Navigate

• Browse (All)
• Browse D
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.