Academic Integrity: tutoring, explanations, and feedback — we don’t complete graded work or submit on a student’s behalf.

A department store runs a multiuser DBMS on a local area network file server whi

ID: 3684385 • Letter: A

Question

A department store runs a multiuser DBMS on a local area network file server which does not enforce concurrency control. One customer has a balance due of $250 when the following three transactions related to this customer were processed at the same time:
–Payment of $250
–Purchase on credit of $100
–Merchandise return of $50.
Each transaction reads the customer record when the balance was $250. the updated record was returned to the database in the order shown above.
•What balance will be for the customer after the last transaction was completed?

Explanation / Answer

300$

Hire Me For All Your Tutoring Needs
Integrity-first tutoring: clear explanations, guidance, and feedback.
Drop an Email at
drjack9650@gmail.com
Chat Now And Get Quote