Question: Whitlock Department Stores runs a multiuser DBMS on a LAN file server. Unfortunately, at the present time, the DBMS does not enforce concurrency control. One

Whitlock Department Stores runs a multiuser DBMS on a LAN file server. Unfortunately, at the present time, the DBMS does not enforce concurrency control. One Whitlock customer had a balance due of $500.00 when the following three transactions related to this customer were processed at about the same time:
• Payment of $500.00
• Purchase on credit of $100.00
• Merchandise return (credit) of $50.00
Each of the three transactions read the customer record when the balance was $500.00 (i.e., before any of the other transactions were completed). The updated customer record was returned to the database in the order shown in the bulleted list above.
a. What balance will be included for the customer after the last transaction was completed?
b. What balance should be included for the customer after the three transactions have been processed?

Step by Step Solution

3.35 Rating (176 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

a Because the merchandise return credit of 50 proc... View full answer

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Document Format (1 attachment)

Word file Icon

613-CS-DB (2047).docx

120 KBs Word File

Students Have Also Explored These Related Databases Questions!