Database Modelling - ERD Modelling Assignment
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.
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).
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.
Attachment:- Assignment.rar