Reference no: EM13884867

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

 

LaborSchedulelD	Scheduled EmployeelD	Hours Scheduled	Wage Rate
LS7	E15	40	$10.50
157	E16	40	59.75
L57	E17	40	$6.20
LS7	E18	6	$5.90
LS7	E19	6	$5.90
LS7	E20	28	$8.50
LS7	E21	40	$9.00
LS7	E22	16	$8.25
LS7	E23	60	$15.00

 

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