Results 1 to 4 of 4

Thread: Normalization

  1. #1
    Join Date
    Sep 2012
    Posts
    2

    Normalization

    Hello Everyone,

    I have a question regarding Normalization. I want to Normalize this table

    ROOM TIME COURSENO COURSENAME TUTOR

    40 9:00 101 English Tim
    - 8:00 106 Spanish -
    41 9:00 102 Maths Jhon
    42 7:00 103 Biology Tom
    42 8:00 104 Chemistry Tom
    43 7:00 105 Physics Ann
    41 8:00 101 English Jhon
    40 7:00 101 English Tim

    I think there should be three table
    Table 1 - Course no , Course name
    Course no is primary key
    Table 2 - Course no, tutor
    Course no foreign key
    Table 3 - Room, time, course no
    Course no. foreign key
    I am not sure. Kindly suggest
    Thanks
    Last edited by star987; 09-28-12 at 20:08.

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    please show the primary keys for your proposed tables
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  3. #3
    Join Date
    Sep 2012
    Posts
    2
    Table 1 will have following attributes --> Course no., Course name
    Course no. will be the primary key

    Table 2 will have following attributes -- > Course no., Tutor
    Course no. will be the foreign key

    Table 3 will have following attributes --> Course no. , room, time
    Course no. will be the foreign key

  4. #4
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    you forgot the primary keys for tables 2 and 3

    every table must have a primary key, or else it fails first normal form
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

Posting Permissions

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