Question: * * please help me fill in the correct cardinality for each highlighted box ( either a N for many or a 1 . ALSO

**please help me fill in the correct cardinality for each highlighted box (either a N for "many" or a 1. ALSO come up with how tables you need based on the REA diagram.
Here is some info about the company:
Mikes Auto Shop is an automotive maintenance and repair shop located in Las Vegas, Nevada. The shop is owned by Mike, and he employs several ASE-certified mechanics as full-time employees. The shops administrative functions are primarily run by Mikes wife, Mary, who is also an employee of the company.
When a new customer calls the shop or walks in to the office, Mary creates a customer file in the database and records pertinent information about the customer and the customers vehicle(s). Each customer and each vehicle receive a unique identifier in the database.
Customers must schedule appointments with Mary to have their cars serviced. Mary schedules the appropriate amount of time needed, based on the customers request for a specific service (e.g., brake repair, oil change, radiator replacement).
When the customer arrives, a mechanic receives the order from Mary and begins work to fill the request. The mechanics record any inventory used during the service (e.g., oil filter, brake pads, radiator) to be added to the customers invoice. Once the work is complete, Mary receives the updated sales order from the mechanic, creates an invoice for the customer, and collects payment.
Mikes Auto Shop requires customers to pay at least 50 percent of the cost at the time of a visit, but they allow customers to pay off the remaining balance within 30 days. Some customers pay the entire balance up front, but others pay 50 percent now and 50 percent at the end of the month. Mikes accepts cash, checks, and Visa or MasterCard.
When a mechanic notices that the shop needs to order new parts or other inventory items, he sends a purchase requisition to Mary. She fills out a purchase order and sends it to one of three approved vendors. The vendors ship items as they are available, so it is possible for a single order to be spread across multiple shipments. The vendor does not, however, combine multiple orders in a single shipment.
Each of the approved vendors has agreed to allow Mikes Auto Shop to carry a monthly balance. Mikes Auto receives a monthly statement each month from the three vendors, and Mary submits payment in full each month to pay off the balances.
 **please help me fill in the correct cardinality for each highlighted

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!