August 2009
Intermediate to advanced
893 pages
26h 48m
English
Content preview from Database Systems: Concepts, Design and Applications
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
Start your free trial
7.5. Example of EER Diagram
Fig. 7.11 illustrates an example of EER diagram using all the concepts discussed in the previous sections of this chapter, for a database schema of technical university.
The technical university database keeps track of the students and their main department, transcripts and registrations as well as the university’s course offerings. The database also keeps track of the sponsored research projects of the faculty and the undergraduate students. The database maintains person-wise information such as person’s name (F-NAME), person identification number ...