Assignment 3_Case Study Page 1 of 1

MIS602 Data Modelling and Database Design
Assessment 3 Database Case Study Report
Fast&Fix Car Service is a car dealer established in South Australia in 2012. The two main business wings
are car servicing facility and used car sales. The car servicing provides different types of car services
including general services, Fleet Servicing, Mobile Tyre fixing and Log Book service. The car sales
service also sells used passenger vehicles such as cars, SUVs, Utes and mini vans.
After COVID-19 hit the country in early 2019, the company experienced a higher growth of the used
car sales operation. The reason could be that more people had chosen to drive for work and had
avoided public transportation as a preventive measure. The company is quite optimistic that this trend
will continue in the future, and there is potential for growth in car sales operation consequently
improving the demand for car servicing facility operation too.
To accommodate the future growth, the company considered increasing their staff portfolio by hiring
a dedicated salesperson who works with the customer to give a better customer experience. The main
role of the salesperson is to help with customer selecting, buying and test drives. The customer can
book a test drive in advance with an available salesperson. The salesperson deals with all aspects of
the sales including the selling transaction such as recording the transaction in the database and the
test drive log.
Together with the new portfolio they also decided to computerize their existing manual car servicing
operation. The car servicing operation of the business offers many services to the customer. For
example, a customer may come in just to have his or her car serviced; that is, a customer need not
buy a car to be classified as a customer. When a customer takes one or more cars in for repair or
service, one service ticket is written for each car. The system maintains a service history for each of
the cars serviced. The service records are referenced by the car’s serial number. A car brought in for
service can be worked on by many mechanics which may be for cleaning a fuel injector nozzle, wheel
alignment etc. In some cases the car servicing may also require replacement of one or more parts of
the car such as the tyres or car brake pads.