Below is a description of the business policies for John’s auto shop revenue cycle. You will use this information to properly identify the cardinality in the REA model:

John’s Auto Shop is an automotive maintenance and repair shop located in Phoenix AZ. The shop is owned by John, and he employees several ASE-certified mechanics as full-time employees. The shop’s administrative functions are primarily run by John’s wife, Amy, who is also an employee of the company.

When a new customer calls the shop or walks in to the office, Amy creates a customer file in the database and records pertinent information about the customer and his or her vehicle(s). Each customer and each vehicle receive a unique identifier in the database.

Customers must schedule appointments with Amy to have their cars serviced. Amy schedules the appropriate amount of time needed based on the customer’s request for a specific service (e.g., brake repair, oil change, radiator replacement). Many times a customer will have more than one service done on their car.

When the customer arrives, a mechanic receives the work order from Amy and begins work to fill the request. The mechanics record any inventory used during the service (e.g., oil filter, brake pads, radiator) onto the work order which will be used for the billing. Once the work is complete, the floor manager checks the mechanics work and then signs off on the work order as complete, and brings it to Amy who creates an invoice for the customer, and collects payment.

1. How many total tables are needed?

2. Complete the cardinalities of the REA model in the blank

 

ZOOM + Auto Shop How many total tables are needed? (3 points) R. E A Instructions Please complete the cardinalities of the REA model in the blanks there are 17 of these worth 1 point each Service Appointment Car N the cardinality will either be a one (1) or many (N) Point allocation : 17 blank cardinalities worth 1 pt each # of tables needed worth 3 points Total assignment is worth 20 points Parts Give Service Customers 1 N Cash 1 Get Cash Employees 1 z