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 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 ASEcertified mechanics as fulltime 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 vehicles 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 eg 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 eg 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 percent of the cost at the time of a visit, but they allow customers to pay off the remaining balance within days. Some customers pay the entire balance up front, but others pay percent now and 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.
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
