Question: * * * * * p l e a s e help m e fill i n the correct cardinality for each highlighted box and
help fill the correct cardinality for each highlighted box and come with how tables you need based the REA diagram
Information solve:
Customers must schedule appointments with Mary have their cars serviced. Mary schedules the appropriate amount time needed, based the customer request for a specific service repair, oil change, radiator replacement
When the customer arrives, a mechanic receives the order from Mary and begins work fill the request. The mechanics record any inventory used during the service filter, brake pads, radiator added the customer invoice. Once the work complete, Mary receives the updated sales order from the mechanic, creates invoice for the customer, and collects payment.
Mike Auto Shop requires customers pay least the cost the time a visit, but they allow customers pay off the remaining balance within Some customers pay the entire balance front, but others pay now and the end the month. Mike accepts cash, checks, and Visa MasterCard.
When a mechanic notices that the shop needs order new parts other inventory items, sends a purchase requisition Mary. She fills out a purchase order and sends one three approved vendors. The vendors ship items they are available, possible for a single order spread across multiple shipments. The vendor does not, however, combine multiple orders a single shipment.
Each the approved vendors has agreed allow Mike Auto Shop carry a monthly balance. Auto receives a monthly statement each month from the three vendors, and Mary submits payment full each month pay off the balances.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
