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
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
Add2, City, State, Zip
Students - Put everything in this table that describes a student
StudentID - Should be unique
Add1, Add2, City, State, Zip
YrInSchool - FR, SO, JR, SR
Classes - Put everthing in this table that describes a class
ClassID - Should be unique
LinkTable - This is the fun part. This table links students with classes and teachers.
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!