Question: can please someone help me with this assignment 2. . Suppose a catastrophe destroys the database just after 10:10. Which transactions in the sample log
can please someone help me with this assignment
2. . Suppose a catastrophe destroys the database just after 10:10. Which transactions in the sample log shown in Figure 7-19 would the recovery program use to update the restored database? Which transactions would have to be entered again by users?
3. If two of the four transactions shown in Figure 7-19 started at different times, deadlock could have occurred. Adjust the log to create deadlock between these two transactions.
4. If two of the four transactions shown in Figure 7-19 started at different times, deadlock could have occurred. Adjust the log to create deadlock between these two transactions. Suppose further that the database requirements have changed so that a condo can have multiple people as owners, just as people can own more than one condo. Whats the new database design for the Owner and CondoUnit tables, as well as any other table(s) needed to satisfy the new requirements? Does the new database design affect the OwnerCondo view? If so, write the new defining query for the view.
5. Solmaris Condominium Group currently uses a PC-based DBMS. What factors should they consider in determining how often to back up their database? The factors you include should be specific to Solmaris Condominium Group.
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
