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).

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.

 


Price: £ 60

100% Plagiarism Free & Custom Written, Tailored to your instructions

Leave your Comments


Can't read the image? click here to refresh