Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.
- Create BookmarkCreate Bookmark
- Create Note or TagCreate Note or Tag
- PrintPrint
4. Modeling and Designing Databases > Entity Relationship Modeling Examples
Earlier in this chapter, we showed you how to design a database
and understand an Entity Relationship (ER) diagram. This section
explains the requirements for our three example databases—music, university, and flight—and shows you their Entity
Relationship diagrams:
-
The
musicdatabase is designed to store details of a music collection, including the albums in the collection, the artists who made them, the tracks on the albums, and when each track was last played. -
The
universitydatabase captures the details of students, courses, and grades for a university. -
The
flightdatabase stores an airline timetable of flight routes, times, and the plane types.
