Table Normalizing

[PJHAction]

Creating a new DB to track students. I created a Table with like 25 fields for personnal information etc. I also created a Table with 20 fields to track scores for events with a one to one relationship.

Question is should I keep the tables split with a one to one or should I just throw them all into one table?

There will be 7000 students per year.

Peter

 

[Golom]

The fact that "events" is plural implies (at least to me) that the relationship will not be one-to-one

You appear to have an un-normalized "Events" table with multiple events stacked up as repeating fields (i.e. Score[red]s[/red])

You should probably have
[tt]
tblStudents
StudentID PK
FirstName
LastName
DateOfBirth
etc.

StudentEvents
StudentID PK (FK to tblStudents)
EventID PK
EventDate
Score
[/tt]

 

[PHV]

Have a look here:

http://r937.com/relational.html

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886