ER diagram (5 points)
• -1 point if not use Crow’s Foot Notation and/or a relationship between entities doesn’t include the cardinality, see: https://bytes.usc.edu/cs585/m22_datadatadata/hw/HW1/pics/ERD_Relationship_ Symbols_Quick_Reference-1.png
• -1 point if PK and/or FK isn’t marked in a given table.
• -1 point if a strong relationship between entities isn’t represented by a solid line, likewise if a weak relationship between entities isn’t represented by a dashed line. Or, if all lines are solid, all lines are dashed – they may be doing something wrong)
• Fully depicted entities, attributes, and relationships mentioned in the homework description. (max deduction is 3 points - use ER diagram in the solution as a reference - Note that there can be multiple ways to accomplish the same requirements)
◦ -1 if missing at least one important entity (grader’s discretion)
◦ -1 if missing at least one important attributes for an entity (grader’s discretion)
◦ -1 if missing at least one important relationship between entities (grader’s discretion)
README.txt (1 point)
• -1 point if no README file is submitted
• -0.5 if at least one of the assumptions goes against the homework description
• -0.5 if at least one of the assumptions doesn’t follow what is shown in the student’s ER diagram.
• -0.5 if the README file is used to state the facts in the homework description rather than stating the student's own assumptions, comments, or design decisions. Overall the README file should give an impression saying “why the
