Securing Higher Grades Costing Your Pocket? Book Your Assignment at The Lowest Price Now!

Phone no. Missing!

Enter phone no. to receive critical updates and urgent messages !

Add File

Error goes here

Files Missing!

Please upload all relevant files for quick & complete assistance.

Guaranteed Higher Grade!

COIT20247 Database Design And Development

tag 1 Download 4 Pages / 840 Words tag 05-07-2021


Australasia Auto Services (AAS) is a prestigious dealer of cars based in Rockhampton, Queensland.Their main business is to provide professional maintenance services for various cars and also sells a wide range of new vehicles. With the boom of its business in recent years, AAS needs a relational database system to store information related to its business. In this assignment, your task is to design an entity relationship (E-R) data model for a database to be used by AAS in order to manage various information related to their business activities efficiently. You should read the case study carefully, making a note of all the entities you think are involved, and of their attributes. Consider the relationships between the entities as you do this.

Although AAS hires many staff, each employee can be categorised one of three types: mechanic,salesperson, and administration staff. The duty of mechanic is to perform car maintenance service, while the salespersons are responsible for sales and the administration staff deal with a wide range of administrative jobs or miscellaneous tasks. Each employee at AAS has a unique employee number, and AAS maintains normal contact information about each employee. In addition, the technical trade level and expertise of mechanics, the number of year in sales experience for a salesperson, and the qualification of admin staff are to be recorded in the system.

After a phone booking, a client will bring a car in for service on a specified date and the admin staff will record the car details that include the registration number, manufacturer, make, model, produced year and colour. The admin staff will also record a description of service requirement. Then the system will assign a unique identifier number for this service job. It is necessary to point out that the client’s car could be a car purchased from AAS, or it may be bought from somewhere else. For the former case, some relevant details such as the salesperson name, price, and warranty due date are required to keep in track.

Usually each service job could be carried out by one or many mechanics. The data on service details such as which mechanics perform the service job, labour cost, part cost, date, start time and finish time must be recorded in the system. When a car is being repaired, it often involves replacing certain parts due to  various damages. For this reason, the mechanic may check its records in the database on a list of part types. Each type has a unique part identifier, a description, manufacturer or brand information, a price per unit and the quantity available in the stock. If parts are required to replace during service, the mechanic records the quantity of each type used into the database.

From time to time, the clients may feel unsatisfactory on a service job done and therefore they may complain about service quality, expensive cost and other possible problems. If so, the lodged complaint should be recorded and processed appropriately by an admin staff, with a response addressed the outcome of investigation. Finally, AAS also wishes to maintain contact details for each client who requests service, including their residential address, contact phone, email and whether they are a senior citizen, who may receive some discount in a service.

You are required to develop an ER model to represent the information requirements for the application scenario (AAS) as described on last page.
Your ER model must:
• show all necessary entities, attributes and relationships
• show unique identifiers
• show multi-valued attributes (also called repeating attributes), if any
• show participation and cardinality
• show associative entities, if appropriate
• use the notation described in the set text
• use consistent and appropriate naming for entities and attributes throughout.
Download Sample Now

Earn back the money you have spent on the downloaded sample by uploading a unique assignment/study material/research material you have. After we assess the authenticity of the uploaded content, you will get 100% money back in your wallet within 7 days.

Unique Document

Under Evaluation

Get Money
into Your Wallet

Total 4 pages

Cite This Work

To export a reference to this article please select a referencing stye below:

My Assignment Help. (2021). COIT20247 Database Design And Development. Retrieved from

"COIT20247 Database Design And Development." My Assignment Help, 2021,

My Assignment Help (2021) COIT20247 Database Design And Development [Online]. Available from:
[Accessed 02 February 2023].

My Assignment Help. 'COIT20247 Database Design And Development' (My Assignment Help, 2021) <> accessed 02 February 2023.

My Assignment Help. COIT20247 Database Design And Development [Internet]. My Assignment Help. 2021 [cited 02 February 2023]. Available from:

Stuck on Any Question

Our best expert will help you with the answer of your question with best explanation.

We will use e-mail only for:

arrow Communication regarding your orders

arrow To send you invoices, and other billing info

arrow To provide you with information of offers and other benefits

Phone no. Missing!

Enter phone no. to receive critical updates and urgent messages !

250 words
Error goes here

Error goes here

Files Missing!

Please upload all relevant files for quick & complete assistance.

We Can Help!

Get top notch assistance from our best tutors !
Excel in your academics & career in one easy click!


Other Samples

Content Removal Request

If you are the original writer of this content and no longer wish to have your work published on then please raise the content removal request.


5% Cashback

On APP - grab it while it lasts!

Download app now (or) Scan the QR code

*Offer eligible for first 3 orders ordered through app!

callback request mobile
Have any Query?
Subtraction Payment required!

Only one step away from your solution of order no.