Assignment 2 – ERD
Your next assignment is to construct an ERD for the entities that you identified in assignment 1. The ERD
is the implementation plan for the rest of the database. It is important that you identify all of the
entities and attributes that you will need to model your database. Think of this as sketching out the
classes that you will need for a large Java project; you will inevitably forget things, but proper planning
prevents poor performance.
Ensure that you use the format laid out in the slides for your ERD. There are many tools out there that
will generate different styles of ERD. Think of my style as the “corporate standard” for where you are
working and follow it. Variance from the standard will be penalized.
I require that you use a computer based tool instead of pencil and paper. These are documents that are
part of your work; you wouldn’t consider hand-writing a user manual, would you?
Please ensure that your name and date are on the document.
Your ERD must be submitted as an image (jpg, bmp, tiff, gif, png, etc) or as a PDF.
Rubric
Poor
OK
Good
Great
Professional
Appearance
Not professional
(0)
Hand drawn or
poorly formatted
(3)
Reasonable, but
crowded or
excessively spread
out. Untidy. (7)
Neat, clean, nicely
laid out. (10)
(0)
incorrect PKs (7)
correct PKs (14)
good PKs (20)
missing,
relationships
wrong (7)
missing,
relationships
(20)
Attributes
No attributes (0)
Many missing
attributes (7)
Few missing
attributes (14)
No missing
attributes (20)
Entities
No entities (0)
A few entities(3)
Any of:
Missing entities,
poor names,
wrong shapes (7)
All entities, good
names, drawn
correctly (10)
Cardinalities
No cardinalities
(0)
Few/mostly
incorrect
cardonalities (7)
Most cardinalities
and most correct
(14)
All cardinalities in
place and correct
(20)