Sample Data Dictionary Table: CLASS
Field Name Access Data Type SQL Server Data Type Field Size Sample Data (realistic) Description/ Notes (only if required)
ClassNo Text char 5 C1234 PK. All same length. Start with a C
Day Text char 3 Wed
StartTime Text char 5 13.30
EndTime Text char 5 15.20
Semester Text char 11 Sem 1, 2008
CourseCode Text char 10 COSC 9821C FK to table COURSE
TeacherNo Text char 5 T9532 FK to table TEACHER
Fee Currency money N/A $150.00
MaxSize Number int N/A 25 Maximum no of of students to be enrolled

Table: ENROLMENT
Field Name Access Data Type SQL Server Data Type Field Size Sample Data (realistic) Description/ Notes (only if required)
StudentID Text char 8 S3123456 Part of composite PK. FK to table STUDENT
ClassNo Text char 5 C1234 Part of composite PK. FK to table CLASS
EnrolmentDate Date/Time datetime N/A 12-Feb-08 Medium Date in Access
PaymentMethod Text varchar 11 Credit Card Cash or Credit Card
CardNo Text char 19 1234 1234 1234 1234 FK to table CREDIT_CARD
Result Text char 3 CHD

Table: STUDENT
Field Name Access Data Type SQL Server Data Type Field Size Sample Data (realistic) Description/ Notes (only if required)
StudentID Text char 8 S3123456 PK All same length. Start with an S
Title Text varchar 4 Miss
LastName Text varchar 30 Cunningham-Smith
FirstName Text varchar 30