Reference no: EM132476971

CP2404 - Database Modelling - James Cook University

Conceptual Database Modelling

This assignment has been designed to assess students' ability to model a database, by constructing an entity-relationship diagram for a particular business scenario. This assignment addresses the following learning objectives for this subject:

• Develop a database model using the entity-relationship model
• Apply the techniques of normalisation

Assignment Task

Question 1) You are to write a brief discussion of your solution, i.e. how you approached the modeling problem and any issues you may have encountered (maximum of ½ page)

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

Question 3) Based on these business rules*, draw a fully labeled 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 (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 the drawing tool (e.g. Visio) will need to be saved as an image file and then be included in your document file to be submitted)

Question 4) A summary to describe the major justifications, assumptions and limitations related to your database design. For example:
• Assumption/justifications for optionalitiy, connectivities, constraints data type and data domain; and
• Special cases or data integrity issues that cannot be handled.

Attachment:- Conceptual Database Modelling.rar