Results 1 to 9 of 9
  1. #1
    Join Date
    Sep 2008
    Posts
    29

    Exclamation Unanswered: How to solve this??

    Tiger Furniture Company
    The Tiger Furniture Company sells a number of different furniture products around Kuala
    Lumpur area. 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. Meanwhile, also we should consider following details:
    a. A customer may submit any number of orders at a time, although it is not
    compulsory for a customer to submit any orders.
    b. Each order is submitted by exactly one customer.
    c. The identifier for a customer is Customer_ID. Other attributes include
    Customer_Name and Customer_Address.
    d. A given customer order must request at least one product.
    e. Any product sold by Tiger Furniture may not be requested on any order, or
    may be requested on one or more orders.
    f. An attribute associated with each order and product is Quantity, which is the
    number of units requested.
    The Tiger Furniture has established another facility called 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.
    Moreover, the Tiger Furniture Company has several salespersons. The identifier for a
    salesperson is Salesperson_ID. The 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.
    The 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 Tiger Furniture Company. An attribute of the
    relationship between vendor and raw material is Unit_Price.


    Can someone help me?? I dont get it!! How am I supose to do this?
    anyone?

  2. #2
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,799
    Provided Answers: 11
    What have you got so far, Tiger?

  3. #3
    Join Date
    Sep 2008
    Posts
    29
    How many tables am I suppose to do for this scenario?
    I did three....one for the product
    one for the customer
    one for the territories.........am I on the right track??

  4. #4
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,799
    Provided Answers: 11
    As many as it takes, usually.

    You are stating, anyway. What fields are on these 3 tables?

  5. #5
    Join Date
    Sep 2008
    Posts
    29
    I think 5 tables....


    1. Product
    a.Product_ID
    b.Product_Line_ID
    b.Product_Description
    c.Product_Finish
    d.Unit_Price
    e.Product_Line_Name

    2. Customer
    a.Order_ID
    b.Order_Date
    c.Customer_ID
    d.Customer_Name
    e.Customer_Address

    3 Territories
    a.Territory_ID
    b.Saleperson_ID
    c.Saleperson_Telephone
    d.Saleperson_Fax


    4. Material
    a.Material_ID
    b.Unit_of_Measures
    c.Unit_Price

    5 Vendors
    a.Vendor_Name
    b.Vendor_Address
    c.Unit_Price

  6. #6
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,799
    Provided Answers: 11
    How do you represent an product in an order? Or how do orders link to products?

  7. #7
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    How do you know which materials are in each product?
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  8. #8
    Join Date
    Sep 2008
    Posts
    29
    I dont know......thats why am asking for help...I dont even know if the tables are right or wrong!!

  9. #9
    Join Date
    Feb 2005
    Posts
    57
    Sort out the relationships.
    E.g between Product Line and Product; Product and Material; Customer and Order; Order and Product; etc; etc.....

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •