Hi,
I have my first ever database project and need some advice before I start. Here are some details:
In the past we have used a simple word document to hold some details on incidents with students. For example:
Date name group time details
01/02/07 joe blogs 10G 13:20 joe set off the fire alarm
==============================================
10/02/07 jon doe 11F 08:30 Jon spat at a teacher
==============================================
There are now over 200 pages and this is becoming hard to maintain and find records as names are often spelt incorrectly and in no order, etc
I am trying to work out how best to set out my tables. Do I put it all into one or do i split up the tables. Do I have a user table and a main table?
If I have a user table I want the primary key to be the student's admission number so this will match up with our school management system if I need to put a name to a face. I was thinking of a separate user table because once a student is added I could use a list box to select a student when i need to add another incident rather than type his/her name.
hope this makes sense!
Cheers,
Marix