Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2013
    Posts
    1

    Normalisation 1st normal form, help please

    Hi guys, i'm very new here but I was wondering if anyone could help me with 1st normalised form as I have trouble understanding which data I can move to a separate table, any help would be much appreciated
    Attached Thumbnails Attached Thumbnails normalistation.png  

  2. #2
    Join Date
    Dec 2012
    Location
    Logan, Utah
    Posts
    163

    Thumbs up

    First pass I would create a table for each entity that is being described.

    Teachers - Put everything in this table that describes a teacher
    TeacherID - Should be unique
    Name
    Add1
    Add2, City, State, Zip
    DOB
    Tax Code

    Students - Put everything in this table that describes a student
    StudentID - Should be unique
    Name
    Add1, Add2, City, State, Zip
    DOB
    YrInSchool - FR, SO, JR, SR
    AnticipatedGradYear
    Whatever


    Classes - Put everthing in this table that describes a class
    ClassID - Should be unique
    Name
    RoomNbr
    TimeTaught
    MaxStudents


    LinkTable - This is the fun part. This table links students with classes and teachers.
    TeacherID
    StudentID
    ClassID


    The questions you need to ask yourself is what are you expecting the results/reports to look like?
    Given a teacher, give me all their classes they teach.
    Given a student, give me all their classes they are attending
    Given a class, give me a list of students in that class
    Given a Time, what classes are being taught then

    These type of questions will help in the design of the LinksTable and appropriate indexes.

    This is just a first pass. There are other things that need to be added to these tables to make, namely constraints, validation options and limits. I'm sure if I missed something important, someone else will chime in. This will get you started.

    One other thing that has been mentioned by Pat Phelan a number of times that will help you, google 'Marc Rettig poster' and print out the rules for data normalization and read them. Then read them again until they make sense!

    HTH
    Last edited by LinksUp; 03-08-13 at 11:49.

Posting Permissions

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