COIT20247 : Australasia Auto Services :Scenario - IT Assignment

Internal Code - MAS4200

Database Design and Development Assignment

Scenario : Australasia Auto Services 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. Questions : 1. 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 2.write brief definitions for the entities and attributes in your model. For each entity and attribute in your model, write a sentence to describe the meaning of that entity or attribute. You should refer to the sections Naming and Defining Entity Types and Naming and Defining Attributes in the textbook.