Database Scheme: University Table: Student __________________________________________________________________________ Col/Ent Name |Type |Null | Key/Const __________________________________________________________________________ Stno Integer Not Prim SSN varchar(9) Not Prim LName varchar(20) Not FName varchar(20) Not Major Integer Not Dep:Depcd Minor Integer Yes Dep:Depcd Caddres varchar(20) Yes Pstreet varchar(20) Not Pcity varchar(20) Not Pstate varchar(20) Not Pzip varchar(5) Not Pphone varchar(11) Not Cphone varchar(11) Yes Degree enum(0,1,2,3,4,5) Not Table: Grades: __________________________________________________________________________ Col/Ent Name |Type |Null | Key/Const __________________________________________________________________________ Stdo Integer Not Student:Stno Semester varchar(10) Not Section:Semester Year varchar(4) Not Section:Year Section Number Integer Not Section:Number Course Integer Not Section:C_id ngrade enum(0,1,2,3,4) Yes Table: Grades_lookup: __________________________________________________________________________ Col/Ent Name |Type |Null | Key/Const __________________________________________________________________________ grad_num Int Not Yes grad_let varchar(1) Not Yes Table: Sections: __________________________________________________________________________ Col/Ent Name |Type |Null | Key/Const __________________________________________________________________________ Instructor Varchar(50) Not Semester Varchar(10) Not sec_id Year Varchar(4) Not sec_id C_id Integer Not sec_id=>Course:idno Section Number Integer Not sec_id sec_id multi-index Unique Table: Course: __________________________________________________________________________ Col/Ent Name |Type |Null | Key/Const __________________________________________________________________________ idno Integer Not Yes/Unique Department Integer Not Department:depno Name varchar(20 Not Description varch(1500) Not Hours Integer(6) Not Level enum(0,1,2,3,4) Table: Department: __________________________________________________________________________ Col/Ent Name |Type |Null | Key/Const __________________________________________________________________________ Name Varchar(20) Not Office_number Varchar(5) Not Phone Varchar(11) Not College Varchar(20) Not depno Integer Not Yes