Database Design Project:
Wet Paint Design School

:: Entity-Relationship Diagram

The E-R diagram shows the entities, attributes and relationships of the database project as part of a conceptual model. The diagramming conventions that I used are described in Greg Riccardi's Database Management with Web Site Development Applications (Boston: Addison, 2003).

It should be noted that at the time this diagram was created, "Class section" had not yet been identified as an entity separate from "Course" (as described in the data dictionary). Class section was not separated until after the normalization process. Therefore, it is not displayed in this diagram. However, a true conceptual model of the final database would include "Class Section" as a separate entity.

You will need the Adobe Acrobat Reader to view this document. Please click on this icon or here to download it.

::: Relational Model