Question 1- A relationship between cash receipt and customer for an enterprise has cardinalities (0,1) cash receipt - (0,N) customer. The enterprise creates a cash receipt table and a customer table to represent the entities. To represent the relationship, the enterprise posts the primary key of the customer entity table into the cash receipt entity table. Why is this considered an implementation compromise, and at what level (conceptual, logical, or physical) is it an implementation compromise?

Question 2- Why are labor operations and labor types often tracked in the conversion process but usually not tracked in the revenue process?

Question 3- Consider the tables given bellow and describe the necessary procedures to construct a query to determine the number of hours for which Freda Matthews is scheduled to work during the first week of April, 2010.

LaborSchedule (Mutual Commitment) Event

Labor                     Date Schedule                                                         Total

SchedulelD              Approved            Begin Date          End Date           Dollar Amt     LaborReqID^FK   SuperlD^FK

LS7                       3/4/2010             4/1/2010            4/7/2010           $2,758.80           LR7                 ES

LaborRequisition (Instigation) Event

                                                      Maximum Budget          Estimated Budget        Labor Request

LaborRealID            Date                  for Request                    for Request                  Period                     SuperlD^FX

LR7                       2/24/2010           $3,000.00                      $2,768.00             4/12010-4/7/2010           E5S

ReservationlaborSchedulelaborType (Reservation') Relationship

LaborSchedulelD            LaborTypelD     HoursScheduled

LS7                                 CT2                       80

LS7                                 US3                       52

LS7                                 API                        60

LS7                                 CT1                       84

ParticipationlaborScheduleEmployee (Participation4) Relationship

DepartmentSupervisor (Internal Agent)

SuperiD                  Authorized Spending Limit

E5                                 $425,000

Question 4- Identify the resources, internal agents, and external agents associated with each of the following events in the finance process:

a. Cash Requisition (Instigation) event

b. Loan (Mutual commitment) event

c. Stock Issuance (Commitment to Increment) event

d. Dividend Declaration (Commitment to Decrement) event

e. Cash Receipt (Economic Increment) event

f. Cash Disbursement (Economic Decrement) event