Database Modelling Assignment - ERD Modelling

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

• Perform conceptual modelling using Entity-Relationship Diagrams (ERDs)
• Discuss business assumptions which affect data modelling. Model a database using the entity-relationship (ER) model and understand the database development process
• Use the techniques of normalization

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:

a. Assumption/justifications for optionalitiy, connectivities, constraints data type and data domain; and

b. Special cases or data integrity issues that cannot be handled.

Note: Designing the database is an iterative process; you may find yourself going back and forth between Tasks 1 and 3 to revise the design. Make sure that your final submission shows consistent design in the business rules and ERD.

Attachment:- Assignment File.rar