Results 1 to 3 of 3

Thread: Normalization Need help to "understand"

  1. 03-29-2003, 02:03 PM #1
    RichardK
    RichardK is offline Registered User
    Join Date
    Nov 2002
    Posts
    19

    Normalization Need help to "understand"

    Hey guys i really need help to understand how to normalise my data.
    Here are the List the attributes from my data. I need to normalise these entites but i dont know how. PLEASE!! CAN SOMEONE TELL ME HOW!



    CUSTOMER
    ID PK
    CUSTOMER_ID
    FIRST_NAME
    LAST_NAME
    ADDRESS
    POSTOCDE
    PHONE


    CREDIT CARD
    ID PK
    CREDIT_CARD_ID
    CUSTOMER_ID
    CREDIT_CARD _NO
    CREDIT_CARD_TYPE



    PURCHASE
    ORDER_ID PK
    CUSTOMER_ID FK
    DATE

    ORDER LINE
    LINE_CODE PK
    ORDER_ID
    STOCK_CODE


    PRODUCT
    ID PK
    NAME
    PRICE
    STOCK_CODE
    SUPPLIER_ID FK
    SUPPLIER_NO
    Last edited by RichardK; 03-29-2003 at 02:06 PM.
    Reply With Quote Reply With Quote
  2. 03-29-2003, 02:19 PM #2
    Clapital
    Clapital is offline Registered User
    Join Date
    Mar 2003
    Posts
    2
    Havent you asked this question elsewhere on this board?
    Reply With Quote Reply With Quote
  3. 03-29-2003, 02:20 PM #3
    RichardK
    RichardK is offline Registered User
    Join Date
    Nov 2002
    Posts
    19
    yes but that was wrong it wasnt what i needed
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules