university database

Consider a UNIVERSITY database that keeps track of students and their majors,transcripts, and registration as well as of the university's course offerings.The database also keeps track of the sponsored research projects of faculty and graduate students.

For each person,the database maintains information on the person's Name,Social security number,address,sex, and date of birth.Two subclasses of the PERSON entity type were identified: FACULTY and STUDENT.specific attributes of FACULTY are rank,office, office phone,salary and all faculty members are related to the academic departments with which they are affiliated.Each student is also related to his or her major and minor departments,if known,to the course sections he or she is currently attending and to the courses completed.Each transcript instance instance includes the grade the student received in the course section.

An academic department has the attributes name [D Name],telephone[D Phone], and office number[Office] and is related to the faculty member who is its chairperson.