Assume you are the assistant controller for RBS Car Repairs Inc. The controller (your boss) just announced he is moving to Los Angeles and is away looking for housing. There is a big sales meeting at 4:00 p.m. today. The vice president, Jack Phillips, needs the answers to the following questions BEFORE the meeting. You want to do your best since the vice president will head the selection committee for a new controller (a job you are VERY interested in).

Using the below REA data model, complete the following questions.

What is the name of the relationship between the Service Type and Service Acquisition entities?

Write the name and type of relationship (e.g., ST_SO: Many-to-Many relationship).

What is the name of the relationship between the Cash Disbursement and Supplier entities?

Write the name and type of relationship (e.g., ST_SO: Many-to-Many relationship).

List the minimum and maximum cardinalities for the following relationships.

Example: ST_SO relationship Min, Max Min, Max Service Type (0 , N) Service Order (1 , N)

(Min, Max) (Min, Max)

a. Service Acquisition ( , ) Employee ( , )

b. Cash ( , ) Cash Disbursement ( , )

With which entity (or entities) does the Service Acquisition entity have optional participation (i.e., does not have to have a relationship)?

With which entity (or entities) does the Service Order entity have mandatory participation (i.e., must have a relationship)?

RBS Car Repairs Inc. can acquire more than one type of service in the same service acquisition transaction.

__ Yes ___No

RBS Car Repairs Inc. can enter a service acquisition into its database without first entering an order for the service.

___Yes __ No

RBS Car Repairs Inc. can order only one type of services.

___Yes __ No

RBS Car Repairs Inc. is allowed to make partial payments for its services acquisitions.

__ Yes ___No