Using the sample log shown figure

e 83591206413771259650190155&el58N-
97813376200628snapshotid 1319064&id-560821729&
MINDTAP Q Search this cou S Corporation Exercises BITS Corporation Exercises Open a new Microsoft@ Word
document and answer each of the following questions. For the following exercises, you will address problems and answer questions from management at BITS. You do not use the BITS database for any of these exercises. Save the file on your computer with your last name in the file name.

(Example: case1-1 Jones.doc) Click the Choose File button to find and select your saved document 1. While users were updating the BITS database, one of the transactions was interrupted. You need to explain to management what steps the DBMS will take to correct the database. Using the sample log shown in Figure 7-11, list and describe the updates that the DBMS will roll back if transaction 2 is interrupted at 8:10. Transaction ID Time Action Record Updated Before Image After Image 1 8:00 Start 2 8:01 Start 8:02 Insert Client (521) (new valacs) 1 8:03 Update Tasks (WC19, 5125.00) (old values) (new values) 8:04 Insert WorkOrders (69163) (new values) 1 8:05 Commit 8:06 Start 2 8:07 Insert Orderl ine (69163, VR39) (new valaes) 21 8:08 Insert Orderl ine (69163, UP38) (new values) 4 8:09 Start 8:10 Update Client (521, $275.00) (old valaes) (new values) 2 8:11 Update
Consultant (19, $25.00) (old values) (new values) 8:12
Commit 8:13 Update Consultant (51, 40) (old values) (new values) 8:14 Commit 8:15 Delete Tasks (AC65) (old values) 8:16 Commit FIGURE 7-11 Sample log in which all four

these databases to them. (A statistical database is a database that is intended to supply only statistical information to users; a census database is an example of a statistical
database.) Using a statistical database, users should not be able to infer information about any individual record in the database. Use books, articles, and/or the Web to research statistical databases then write a report that explains them, discusses the problem with using them, and gives the solution to the problem 5 The DBA at BITS wants you to investigate biometric identification techniques for potential use at the company for computer authentication purposes. Use books, articles, and/or the Web to research these techniques, then write a report that describes the advantages and
disadvantages of each of these techniques. In addition,
recommend one technique and provide a justification for your recommendation 6. Because most consultants access the BITS database from their mobile devices, such as smart phones and tablets, the DBA is considering the potential use of cloud computing, Use books, articles, and/or the Web to research