Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2003
    Location
    Manchester
    Posts
    1

    Smile Unanswered: Normalisation Help

    Not sure if this is the right place to put this message but, I am creating a stock control system for pc componenets, and need some help normalising the data, so that i can then implement the database.
    The attibutes which need normalising are:

    ProductID
    Component
    Price
    Stock_level
    Minimum_level
    Reorder_amount
    SupplierID
    Supplier_name
    Address1
    Address2
    Address3
    Postcode
    County
    Email
    TelNo
    OrderCode
    Quantity
    Date_of_Order
    Price
    Quantity
    Date
    Total

    If anybody could show me how to normalise this to third normal form, and show first and second Normal form, i would be very grateful.

  2. #2
    Join Date
    Jul 2001
    Location
    Germany
    Posts
    189

    Wink ???

    Hello,

    is this a kind of homework ?

    Think about the objects in the table ... there are
    products, suppliers, addresses, orders ... these are the main objects.

    Therefore you need a product, supplierer, address and order table.
    The question is the relations between each object ????

    Are there many prices for one product ??
    Are there many adresses for one supplier and so on and so on

    The other question ist .... what do you want with the second normal form ??? Never heard, that somebody use this to create a physical database model ?!?!?!!?

    Regards
    Manfred Peter
    (Alligator Company GmbH)
    http://www.alligatorsql.com

Posting Permissions

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