Consider a university database that keeps the following information.

$$ There are a number of students. For each student, the university maintains student first name, last name, student number, social security number, current address and phone, permanent address and phone, date$-$of$-$birth, gender. Both social security number and student number have unique values for each student.

$$ There are a number of departments. Each department is described by name, department code, office phone, and college. Both name and code have unique values for each department.

$$ There are a number of degree programs. Each degree has a degree level and a major $($e$.$g$.,$ B$.$S$.$ in Computer Science, M$.$S$.$ in Software Engineering$).$ A degree program must be administered by one and only one department.

$$ A student must enroll in at least one degree program as his$/$her major, but may have one or more other programs as minors.

$$ Each course has a course name, description, course number, credit hours, level. The value of course number is unique for each course. Each course is offered by one and only one department.

$$ A student must register for at least one course. For each registered course, the semester when it is register and the final grade must be recorded. Use numbers to represent grade, i$.$e$.,0,1,2,3,4$ for F$,$ D$,$ C$,$ B$,$ A$,$ respectively.