CP5633: Database Modelling - Constructing an Entity-Relationship Diagram - IT Assignment Help

Assignment Task:

Task:

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:
? Develop a database model using the entity-relationship model
? Apply the techniques of normalisation
 

Requirements (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 1⁄2 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 at the end 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 MySQL Workbench to create the ERD. A sample ERD can also be found in this document. (Note: The ERD created using MySQL Workbench 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:
• Assumption/justifications for optionalities, connectivities, constraints data type and data domain; and
• Special cases or data integrity issues that cannot be handled.

Business Description (Scenario)
Asia Conference on Machine Learning and Computing (ACMLC) (http://www.acmlc.org/) will be held each quarter. A new issue of the Conference is published each quarter. It aims to provide a forum for researchers, practitioners, and professionals from the industry, academia and government who are working in the field of machine learning and computing to discourse on research and development, professional practice in related fields. Authors are kindly invited to submit full papers or abstracts(.pdf), which will be tracked and reviewed by the conference committees. The conference committees are professor come from different countries who organize the conference (http://www.acmlc.org/committee.html ).

This CP5633: IT   Assignment has been solved by our IT Experts at My Uni Paper. Our Assignment Writing Experts are efficient to provide a fresh solution to this question. We are serving more than 10000+ Students in Australia, UK & US by helping them to score HD in their academics. Our Experts are well trained to follow all marking rubrics & referencing style.

Be it a used or new solution, the quality of the work submitted by our assignment experts remains unhampered. You may continue to expect the same or even better quality with the used and new assignment solution files respectively. There’s one thing to be noticed that you could choose one between the two and acquire an HD either way. You could choose a new assignment solution file to get yourself an exclusive, plagiarism (with free Turnitin file), expert quality assignment or order an old solution file that was considered worthy of the highest distinction.