P2- Design a relational database for a specified user need Data Dictionary

Table Name: tblStudent

Table Description: This table will contain all of the student details.

Field Name Length/Size Description Sample Data Validation Validation Example

Student ID Text / 6 Primary Key- Unique number that 150001 Must not be (________)
identifies each student empty (Null
individually. Must start with the Check)
year the student enrolled e.g. 15 Must be 6
and then have a sequential 4 digit digits
number e.g. 150001
Student Surname Text / 30 Surname of the student Guela Must not stay
empty
Student forename Text / 30 Forename of the student Pratik Must not stay
empty
Student Gender Combo Box Select whether the student is male Male Combo Box Only select male or
/6 or female from the drop down female
combo box

Student D.O.B Date/ Time Students Date of birth in this 19/01/1998 Must be older 19/01/2001
format DD/MM/YYYY than 16 years
Student Year Combo Box Select whether its 2, 3.1 or 3.2 3.2 Combo Box
/3
Progress Coach ID Combo Box/ Foreign key- From the table AHE Combo Box Can only select
3 (tblProgressCoach) linked with a from combo box.
combo box.