Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Question 5). Why can I detect an inconsistency in a table of friends but not in one of bank accounts? community eketa ee (2) New

image text in transcribed

Question 5). Why can I detect an inconsistency in a table of friends but not in one of bank accounts?

community eketa ee (2) New messages from M (no subject) du/ascholer/cs160/Assigns/160-Assignment09.pdf A3) Tell database to set Joe's money to x B3) Tell database to set Joe's m Part 3: Databases and SQL Q5: Why can I detect an inconsistency in a table of friends but not in one of bank accounts? Q6: Here is a table with information about some students: Name Joe Smith 123456 20 3.2 Abby Jones 234567 24 3.6 StudentID Credits GPA And a ToDo list transaction based on Joe earning an A in a 4 credit class. Start transaction Add 4 credits to Joe Change Joe's GPA to 3.66 End transaction A) Why are the actions not idempotent? What could go wrong if we crash midway through the list B) Rewrite the todo list so that the actions are idempotent. Q7: Why might a database need to undo part of a transaction

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Graph Databases In Action

Authors: Dave Bechberger, Josh Perryman

1st Edition

1617296376, 978-1617296376

More Books

Students also viewed these Databases questions