@courses(num/numeric,faculty/char,title/char,tutor/numeric):num
1,'CS','Database Systems',1
2,'Math','Networking Systems',2
@students(num/numeric,surname/char,firstName/char,faculty/char):num
1,'LastName','Firstname','CS'
2,'Mcchesney','Greg','CS'
3,'Aad','Salim','CS'
4,'Aaron','Duane','CS'
5,'Applegate','Steven','CS'
6,'Bean','Russell','CS'
7,'Blank','Taylor','CS'
8,'Carlson','Tyler','CS'
9,'Cell','Broderick','CS'
10,'Conner','Eric','CS'
11,'Cowan','Jeremy','Math'
12,'Dannelley','Chad','Math'
13,'Dibba','Karim','Math'
14,'Falconer','Warren','Math'
15,'Gilbert','David','Math'

@tutors(num/numeric,surname/char,firstName/char):num
1,'McChesney','Greg'
2,'Redding','Collin'
@exams(student/numeric,course/numeric,grade/char,year/numeric):student,course
1,1,'A',2005
2,1,'B',2005
3,1,'C',2005
4,1,'D',2005
5,1,'A',2006
6,1,'B',2006
7,1,'C',2006
8,2,'D',2006
9,2,'A',2007
10,1,'B',2007
11,2,'C',2007
12,2,'D',2007

@studyPlan(student/numeric,course/numeric,year/numeric):student,course,year
1,1,2005
2,1,2005
3,1,2005
4,1,2005
5,1,2006
6,1,2006
7,1,2006
8,2,2006
9,2,2007
10,1,2007
11,2,2007
12,2,2007
13,2,2007
14,2,2007
15,2,2007