(6 points) What are the advantages and disadvantages of each of the following database applicati algorithms?...

 

Transcribed Image Text:

(6 points) What are the advantages and disadvantages of each of the following database applicati algorithms? Algorithm 1 Start a database transaction Get user choice While (user chooses not to exit) Execute SQL statements affecting 3 tables Get user choice End-while Commit (or rollback if error) Algorithm 2 Get user choice While (user chooses not to exit) Start a database transaction Execute SQL statements affecting 3 table Commit (or rollback if error) Get user choice End - while (6 points) What are the advantages and disadvantages of each of the following database applicati algorithms? Algorithm 1 Start a database transaction Get user choice While (user chooses not to exit) Execute SQL statements affecting 3 tables Get user choice End-while Commit (or rollback if error) Algorithm 2 Get user choice While (user chooses not to exit) Start a database transaction Execute SQL statements affecting 3 table Commit (or rollback if error) Get user choice End - while

Answer rating: 100% (QA)

Advantages and disadvantages of each database application algorithm Algorithm 1 Advantages 1 Consistency The use of transactions ensures atomicity con... View the full answer