Tasks
1. You are to write a brief discussion of your solution, i.e. how you approached
the modelling problem and any issues you may have encountered (maximum
of ½ page).
2. You are to write all applicable business rules necessary to establish entities,
relationships, optionalities, connectivities, cardinalities and constraints. If a
many–to-many relationship is involved, state the business rules regarding the
bridging entities after breaking down the many-to-many relationship. An
example business rules format can be found in Appendix A of this document.
Business rules you write are expected to be in the same format as presented
in Appendix A.
3. Based on these business rules,* draw a fully labelled and implementable
Entity-Relationship Diagram (ERD). Include all entities, relationships,
optionalities, connectivities, cardinalities and constraints. You must use
Crow’s foot notation and MS Visio 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).
4. A summary to describe the major justifications, assumptions and limitations
related to your database design. For example:
CP5633 Database modelling Assignment 1 ERD Modelling
Page 2 of 8
a. Assumption/justifications for optionalitiy, connectivities, constraints data
type and data domain; and
b. Special cases or data integrity issues that cannot be handled.