COMP2400 - Relational Databases - Theory - Belconnen - Customer Service - Data Analytics Assessment Answer

COMP2400 - Relational Databases - Theory - Belconnen - Customer Service - Data Analytics Assessment Answer

Assessment Task:

Question 1 
ACTRides is a car rental company that has been founded recently in Canberra. It currently has 5 branches opened in Acton, Belconnen, Dickson, Braddon and Woden, respectively. ACTRides is planning to expand to areas such as Tuggeranong and Manuka in the future. A branch has a unique address but may have multiple telephone numbers. Each rental car must be associated with exactly one ACTRides branch. A rental car can be identied by its registration number and has the information about the model and the production year. Each employee working at ACTRides has a tax le number (TFN), a name and an address. ACTRides employees consist of managers, mechanics and customer service representatives. Every employee must work at exactly one branch. A customer of ACTRides should provide their drivers license number, their name and a contact number. A customer can rent a car from an ACTRides branch and details about the rental such as the rental period and price should be recorded. If a customer is not satised with the rental service provided, this customer may submit a complaint to a customer service representative and thus a distinct reference number and detailed description of the complaint should be recorded. The manager of a branch will handle all the complaints with respect to this branch and has an urgent contact number in case of emergency. Mechanics working at a branch inspect the cars associated with the branch and record the condition and inspection date. A car must be inspected at least two times per year. Each mechanic has a skill level and might have another mechanic as the supervisor. The supervisor must have a higher skill level compared to the mechanics supervised by this supervisor. Your task is to design an Enhanced Entity Relationship (EER) diagram for the above database, which should include entities, relationships, attributes and constraints wherever appropriate (you can make more assumptions if necessary). You also need to identify the requirements that cannot be captured in an EER-diagram.

This Data Analytics Assessment has been solved by our  Data Analytics 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.