Question
A database transaction implements the command set STATUS to 'CURRENT' in all records where BALANCE-OWED=0. (A) Describe how that transaction would be performed with the
A database transaction implements the command "set STATUS to 'CURRENT' in all records where BALANCE-OWED=0".
(A) Describe how that transaction would be performed with the two-step commit.
(b) Suppose the relations from which the command was formed are (CUSTOMER-ID,STATUS) and (CUSTOMER-ID, BALANCE-OWED). How would the transaction be performed?
(c) Suppose the relations from which that command was formed are (CUSTOMER-ID, STATUS), (CREDIT-ID,CUSTOMER-ID), (CREDIT-ID, BALANCE-OWED). How would the transaction be performed?
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started
Advances In Database Technology Edbt 88 International Conference On Extending Database Technology Venice Italy March 14 18 1988 Proceedings Lncs 303
Authors: Joachim W. Schmidt ,Stefano Ceri ,Michele Missikoff
1988th Edition
3540190740, 978-3540190745
