Based on these business rules*, draw a fully labeled and implementable EntityRelationship Diagram (ERD). Include all entities, relationships, optionalities,connectivities, cardinalities and constraints. You must use Crow’s foot notation and MS Visio (or other software) to create the ERD. A Hand-drawn ERD will NOT be accepted. A sample ERD can be found in Appendix A of this document. (Note: The ERD created using Visio will need to be saved as an image file and then be included in your document file to be submitted).
A summary to describe the major justifications, assumptions and limitations related to your database design. For example:
Assumption/justifications for optionalities, connectivities, constraints data type and data domain; and special cases or data integrity issues that cannot be handled.