I am currently developing an asp.net website for a college HE Open Day, and i'm just trying to finalize the database design including normalisation. The brief is as follows:
**** College is looking to streamline the registration process for the Higher Education (HE) Open Day they hold twice a year. The College advertise ‘taster’ sessions in each vocational area and these are advertised for potential students to register prior to the HE Open Day. There are a number of vocational areas per School.
The taster sessions are in one hour blocks and the student can choose up to four taster sessions:
10:00 – 11:00
11:00 – 12:00
12:00 – 13:00
13:00 – 14:00
There is also an introductory session in each vocational area at 9:30am until 10:00am and potential students are expected to register for the session in the area the courses they are interested in reside in.
The potential student should enter their title, forename, surname, telephone number, mobile number and email address before submitting their taster session and introductory session choices. The potential student should not be required to log in.
So far I have got the following tables:
tbl_session
sessionID (PK)
studentID (FK)
schoolID (FK)
vocationalID (FK)
sessionTitle
sessionTime
tbl_student
studentID (PK)
studentName
studentEmail
studentMobile
tbl_school
schoolID (PK)
schoolName
tbl_vocational_ area
vocationalID (PK)
vocationalName
Have I done this correctly? Any help or feedback would be greatly appreciated.
**** College is looking to streamline the registration process for the Higher Education (HE) Open Day they hold twice a year. The College advertise ‘taster’ sessions in each vocational area and these are advertised for potential students to register prior to the HE Open Day. There are a number of vocational areas per School.
The taster sessions are in one hour blocks and the student can choose up to four taster sessions:
10:00 – 11:00
11:00 – 12:00
12:00 – 13:00
13:00 – 14:00
There is also an introductory session in each vocational area at 9:30am until 10:00am and potential students are expected to register for the session in the area the courses they are interested in reside in.
The potential student should enter their title, forename, surname, telephone number, mobile number and email address before submitting their taster session and introductory session choices. The potential student should not be required to log in.
So far I have got the following tables:
tbl_session
sessionID (PK)
studentID (FK)
schoolID (FK)
vocationalID (FK)
sessionTitle
sessionTime
tbl_student
studentID (PK)
studentName
studentEmail
studentMobile
tbl_school
schoolID (PK)
schoolName
tbl_vocational_ area
vocationalID (PK)
vocationalName
Have I done this correctly? Any help or feedback would be greatly appreciated.