Aus CarCare is a small auto service business with two branches in Sydney and Brisbane. The business is based on providing routine maintenance at fixed cost to car owners. The business owners have decided to computerize their operations to allow them to better track their business. Data to be gathered for each service includes service ID, service item, service cost, date of service, customer ID, customer first name, customer surname, customer telephone number, street number, street name, street suffix, suburb, state, postcode, vehicle ID, vehicle make, vehicle model, vehicle year. Note that each vehicle has no more than one owner, but an owner might have more than one vehicle. Moreover, each service gets done on one and only one vehicle, and Aus CarCare allocates a unique service id to every service.

  • Using MS Word or Excel, create an entity relationship diagram from the case study information provided.
  • On your ERD identify the type of relationships using 1:1, 1:M, and M:N format.
  • Convert the ERD into standard notation format. For each entity, include all the attributes. Underline the primary key. If there is any foreign key make it Italic.
  • Using the entity and attribute information, create appropriate tables in MS Access. Then, create a relational diagram between your tables that reflects the relationships you identified in your ERD. Note that your answer to this question should include a print screen of your relational diagram.
  • Using Forms in MS Access create a data entry form for each of your tables.
  • Using realistic data populate each of the 3 tables with 5 records (using MS Access).
Academic Honesty!
It is not our intention to break the school's academic policy. Projects posted are only used as a reference and should not be submitted as is. We are not held liable for any misuse of the solutions. Please see the frequently asked questions page for further questions and inquiries.
Kindly fill out the form. Please provide a valid email address and we'll get back to you in less than 24 hours. We will be sending an invoice through PayPal upon confirmation. We are a non profit organization however we need an amount to keep this organization running, and to be able to complete our research and development.