could you please help me figure the question out and give explaniation for each
ID: 3906083 • Letter: C
Question
could you please help me figure the question out and give explaniation for each answer? Thanks!
5. ACID properties. Pat's accounting system performs only one kind of transaction: trans- fers between two accounts, (withdraw x from account a and add x to account b) starting with all accounts being zero. Hence Pat expects the sum of all accounts to stay zero. Pat uses the experimental transactional database BrandNu that is supposed to offer the ACID properties for its transactions. After some time, Pat finds a serious system fault: the sum of all accounts is different from zero. For each of the 4 ACID properties: Say whether the fault can be explained because BrandNu violated this ACID property and give an explanation of your answer in about 3 sentences plus possibly a schedule or scheduling diagram. 10 marksExplanation / Answer
Atomicity:
This property makes us treat the transaction as a single unit and imposes that either the entire transaction takes place or it doesnt start at all. There is no in between. Talking about our situation , maybe a transaction might have started but failed to complete leaving the database in an inconsistent state.
Consistency:
If the data was in a consistent state before a transaction took place, it should be in a consistent state after the transaction completes as well. This cannot be a reason for our problem because here inconsistency persists even after transaction has finished. Our transaction wouldve left our database in a consistent state if it were allowed to finish.
Isolation:
Parallel transactions should be carried out as though there was only one transaction operating at a single time.
Durability:
If a transaction commits then the updates made to the data must be preserved by the database , even if it fails the very next moment.
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.