CLASS ASSIGNMENT 1
DATABASE CONCEPTS
TTS2083
SUBMIT DATE: 2/4/2014 (BEFORE 5.30PM) * Hand writing * Individual
Essay Question
Create ERD including relationship cardinality for each of the following descriptions. Primary Key must be shown in each entity and the attribute also. Each answer is related with other answers in this case study. ( Means you have a large of Entity Relationship Diagram)
Case Study (Pine Valley Furniture Company)
1. 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.
2. 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.
3. A given customer order must request at least one product. * Any product sold by Pine Valley Furniture 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.

4. Pine Valley Furniture has established sales territories for its customers. * Each customer does business in one or more of these sales territories. * The identifier for a