Database Concepts – EER Diagramming
For the business rules on the following page, use Gliffy to draw the EERD using the Crows Foot model. Identify
any derived and/or multi-valued attributes. Resolve any M:N relationships. Take a screenshot of the final
EERD and paste in a Word doc (cropping out gridlines and software interfaces). Save this file as IS7.pdf and
submit to Canvas before the end of the day today.
You have been drawing these diagrams for a few weeks now, and with each new diagram you create, you are
getting to know and understand relationships, where to place the foreign keys, the types of constraints, and so
on. The points you earn for this exercise will be based on the correctness of your diagram – same as with
the last few exercises, but now more so based on your current knowledge.