Results 1 to 4 of 4
  1. #1
    Join Date
    Nov 2005
    Posts
    4

    Normalization Help!!

    need to normalize the table upto 3NF n BCNF
    The foll. is table with values

    regno owner model manf cylinder
    1 a l f 4
    2 b fl f 6
    3 a co t 4
    4 b l f 4
    5 c co t 4


    Detail explanation with table

    plz!! help me!!

  2. #2
    Join Date
    Mar 2003
    Location
    The Bottom of The Barrel
    Posts
    6,102
    What class is this for?
    oh yeah... documentation... I have heard of that.

    *** What Do You Want In The MS Access Forum? ***

  3. #3
    Join Date
    Dec 2003
    Location
    Canada
    Posts
    710
    Answer the following questions one after another and normalize for each:

    Eliminate repeating columns.
    Eliminate redundant rows.
    Eliminate independent columns.
    Last edited by certus; 12-01-05 at 01:11.

  4. #4
    Join Date
    Nov 2005
    Posts
    4
    hey guys,
    this table is in 2NF already!! I think
    1nf: regno is pk
    2nf: as there is only 1 pk so all the nonkey attrib. r dependent on it.

    plz!! convert it to 3NF n BCNF

Posting Permissions

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