Subject Code : CP2404
Assignment Task:

Rationale 

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 

Requirements (Tasks) 

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

4) A summary to describe the major justifications, assumptions and limitations related to your database design. For example: 

• Assumption/justifications for optionality, connectivities, constraints data type, and data domain; and 

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

Business Description (Scenario) 

ABC Education (ABCE) is a private company which owns a number of language/vocational branch colleges in Sydney, Newcastle, Brisbane, Gold Coast, Townsville and Cairns. Each college offers a wide range of English language courses as well as vocational courses from Certificate level up to Advanced Diplomas in a variety of disciplines. In order to meet different local specific conditions or demands each branch college may offer different range of courses. 

Each college is managed by a college manager who was hired and allocated by ABCE Head Office. As college managers they have authority to manage all college-related business matters including student enrolment management, human-resource management, financial/accounting matters, maintenance of college buildings, etc.. 

Each college manager is expected to send a report to the ABCE Head office in Brisbane periodically or whenever requested. This report summarizes the total revenues in fees collected, student enrolment summary, total expenses in maintenance and staff salary, staff details, courses offered etc.. Currently managers fill out a document form and mail it back to head office because the computer system is established for each college but is not integrated for the whole ABCE Company. Many college managers have complained that preparing this report is a very difficult and time consuming process. Also, the managers at the head-office also have expressed concerns about the accuracy and verifiability of the reports. 

 

This CP2404: IT Assignment has been solved by our IT Experts at UniLearnO. 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.

Eureka! You've stumped our genius minds (for now)! This exciting new question has our experts buzzing with curiosity. We can't wait to craft a fresh solution just for you!

  • Uploaded By : Mia
  • Posted on : September 02nd, 2018

Whatsapp Tap to ChatGet instant assistance