This paper circulates around the core theme of 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). together with its essential aspects. It has been reviewed and purchased by the majority of students thus, this paper is rated 4.8 out of 5 points by the students. In addition to this, the price of this paper commences from £ 99. To get this paper written from the scratch, order this assignment now. 100% confidential, 100% plagiarism-free.
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.
