Results 1 to 7 of 7

Thread: normalization

  1. #1
    Join Date
    Jun 2004
    Posts
    1

    Smile normalization

    Heyz

    i got a normalization question, and was wondering what is the best way to go about this step by step:

    Normalise the following list of attributes to 3rd normal form. give appropriate names for the resulting relations and indicate the primary key of each relation.

    Student_ID, Student_Name, Campus_Address, Major, Course_ID, Course_Title, Instructor_Name, Instructor_Location, Grade

    Note: A student can take more than one course. An instructor can teach many courses and one course may have many instructors.

    Cheers

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    This is just an overview, but:

    1) Read the textbook
    2) Take notes, especially for the points you don't understand very well
    3) Attend class
    4) Ask lots of questions, especially about the points you didn't understand
    5) Take advantage of office hours and or lab time
    6) Start your homework early!

    When you get to the point that you have specific questions that the teacher doesn't/can't cover, post those questions and I'll bet that one of us will answer them!

    -PatP

  3. #3
    Join Date
    Sep 2002
    Location
    UK
    Posts
    5,171
    Quote Originally Posted by Pat Phelan
    This is just an overview, but:

    1) Read the textbook
    2) Take notes, especially for the points you don't understand very well
    3) Attend class
    4) Ask lots of questions, especially about the points you didn't understand
    5) Take advantage of office hours and or lab time
    6) Start your homework early!
    That's an old-fashioned approach! These days the preferred method is:

    1) Attend class if really necessary, or preferably just get a copy of the notes from someone else who did
    2) Post homework questions on internet
    3) Paste answers received on internet into your homework and submit to tutor.

    Of course, this only really works well when coursework forms a major part of the final grading, since even if accessing the internet during exams is permitted (I wouldn't be surprised), the turn-around isn't usually quick enough to prevent dismal failure to answer the questions.

  4. #4
    Join Date
    Jun 2004
    Posts
    2
    Quote Originally Posted by couyang
    Heyz

    i got a normalization question, and was wondering what is the best way to go about this step by step:

    Normalise the following list of attributes to 3rd normal form. give appropriate names for the resulting relations and indicate the primary key of each relation.

    Student_ID, Student_Name, Campus_Address, Major, Course_ID, Course_Title, Instructor_Name, Instructor_Location, Grade

    Note: A student can take more than one course. An instructor can teach many courses and one course may have many instructors.

    Cheers

    What have you gotten so far? I would start to work out the relationship between students and classes, instructors and classes, students and instructor. Let us know how can we help you further.

  5. #5
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    What does third normal form mean?

    I tried to understand, but I codd'nt
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  6. #6
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Quote Originally Posted by Brett Kaiser
    What does third normal form mean?

    I tried to understand, but I codd'nt
    If you were out with a Date, I'll bet you Codd!

    -PatP

  7. #7
    Join Date
    Nov 2003
    Posts
    167
    That's not punny.

Posting Permissions

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