the college database keeps track of students and courses. for each student, there is a unique student id, name, address, gender, date of birth, major department, degree sought, and courses enrolled in. for each course the student has completed, there is a grade earned. for each course, the database should store the course name (not unique), the course code (unique), the department offering the course, instructor, and the date of the final exam. assume that each department offers at least one course, and each course is offered by one department. each instructor is described by name, id number, address, home phone number, office number, office phone, gender, date of birth, salary, and position. each department is described by a unique name, and the number of students majoring in the department. each department is chaired by one instructor, and contains several instructors. each instructor works for just one department.