Results 1 to 2 of 2

Thread: 1st normal form

  1. #1
    Join Date
    Jun 2004
    Posts
    1

    Unanswered: 1st normal form

    Hi there,
    Pretty new to databasing but ive managed to to produce 13 tables and defined all the relationships in Access,ive even produced all forms , queries etc, im trying to put one of the tables into 1st 2nd and third normal form aand im starting to get a headache! the table as follows:

    product_no
    product_cat
    product_des
    product_size
    product_price
    product_retail
    vat

    if somebody could point me in the right direction i would be eternally grateful!

  2. #2
    Join Date
    Sep 2003
    Location
    The extremely Royal borough of Kensington, London
    Posts
    778
    If prod_desc is related to prod_cat then the table violates 3NF. If however, prod_desc relates to prod_id then the table is correct to 3NF.
    Bessie Braddock: Winston, you are drunk!
    Churchill: And Madam, you are ugly. And tomorrow, I'll be sober, and you will still be ugly.

Posting Permissions

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