The second stage of the project is the development of an entity-relationship (ER) model for the database. This model will guide the development of your logical database design.

Expected duration
2–4 hours
Deadline
2300 on Lesson 11
Points
50 points
Submission
Canvas

Learning Objectives

  • Create an ER model for the development of a real-world system

Help Policy

Authorized Resources
Any, except classmates working on other teams
Notes
Never copy another person’s work and submit it as your own.

You must document all help received from all sources, including the instructor and instructor-provided course materials (such as the textbook).

Assignment

Develop a complete ER diagram for your project. At a minimum, your diagram should include a half-dozen entities although more may be required depending on the scope of your project outlined in the proposal.

The diagram that you submit must be “professional” – i.e., you cannot scan a hand-drawn diagram or take a picture of a whiteboard. Many tools support the creation of ER diagrams; draw.io is freely available online as one example that you can use.

Submission

Submit your ER diagram using Canvas and include a copy of your proposal as a separate attachment. Include your documentation statement as part of your submission.

If the tool used to create your ER diagram does not support the notation used in class or in the textbook (e.g., draw.io does not provide support for disjoint and overlapping constraints for specializations of entities), you must 1) indicate the deviation in your submission and 2) prove that you have thought about these issues by augmenting your diagram with a written description of what should appear. Including this information will waive grading penalties that might otherwise be imposed for these deviations but does not excuse “gross” violations, such as submitting a UML class diagram in lieu of a ER diagram.

Grading

The following grading rubric will be used for this assignment:

Description Points
Entities 15
Attributes 15
Relationships 10
Cardinalities 5
Modalities 5