Results 1 to 4 of 4

Thread: Normalization

  1. #1
    Join Date
    Feb 2010
    Posts
    2

    Normalization

    Hi was wondering if someone could help me?? I am doing normalization to the 3NF. I am gettin confused at what defines an repeating group!

    for example if u had:

    App ref Student name Address Town P/code Course ref Course title Student no

    Would student No be a repeating group and why pls???

    findin it really hard to understand!

    Thank u in advance for helping!

    Brendan

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692

  3. #3
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Last edited by healdem; 02-28-10 at 14:10.
    I'd rather be riding on the Tiger 800 or the Norton

  4. #4
    Join Date
    Mar 2010
    Posts
    4
    Quote Originally Posted by bree9482 View Post
    for example if u had:

    App ref Student name Address Town P/code Course ref Course title Student no

    Would student No be a repeating group and why pls???

    StudentName Adress Town P/Code (Course ref Course title) StduentNo

    The collumns in brackets would be the repeating group.

    Example-

    StudentNo StudentName ........... Course ref Course title
    1 Jim A1 CompSci
    2 Tony A1 CompSci
    3 Tim D2 ChildCare
    4 Timmy D1 SocialCare

    Notice the cousetitle repeating??

    Normalised solution-

    TableStudents
    StudentNo(PK)
    CourseRef(FK)
    StudentName
    ....


    TableCourses
    CourseRef
    CourseName

    Think of a massive university database with thousands of students...

    Un normailised-
    500 A1's
    that means 500 CompSci's

    Normalised
    500 A1's
    but
    1 CompSci

    becuase A1 is a referance to CompSci in the CourseTable.

    Really hope this helps.

Posting Permissions

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