Consider the EER diagram for the UNIVERSITY database shown in Figure 4.9. Enter this design using a data modeling tool such as ERwin or Rational Rose. Make a list of the differences in notation between the diagram in the text and the corresponding equivalent diagrammatic notation you end up using with the tool.

Figure 4.9

Transcribed Image Text:

Fname Minit Lname San Bdate Sex No Street Apt_noCity State Zip Name PERSON Address Fphone Salary Class Foffice Rank College Degree Year FACULTY ADVISOR STUDENT Degrees M. Class-5, COMMITTEE GRAD_STUDENT PI N Title No GRANT Agency N St date MINOR N (N Start MAJOR SUPPORT Time M End M Grade) BELONGS INSTRUCTOR RESEARCHER REGISTERED M N. CHAIRS TRANSCRIPT TEACH NY CURRENT_SECTION Qtr=Current_qtr and Year = Current year SECTION DEPARTMENT Qtr N Sec# (Year Dname Office Dphone CS 1 CD COLLEGE DC COURSE Figure 4.9 An EER conceptual schema for a different UNIVERSITY database. Cname Coffice Cdesc Dean Спате