Models, Languages, Design,
and Application Programming
Department of Computer Science and Engineering
The University of Texas at Arlington
Shamkant B. Navathe
College of Computing
Georgia Institute of Technology
Checkpointing, Redo, Undo/Redo
So far recovery requires that the entire log file be looked at.
Even if a transaction has written a COMMIT to t
Database Recovery Techniques
Purpose of Database Recovery
z To bring the database into the last consistent state,
which existed prior to the failure.
z To preserve transaction properties (Atomicity,
Consistency, Isolation and
CPS480 Database Systems
Exercise 9: Transactions: Concurrency
1. Consider the following two transactions:
T1 : r1 [x]r1 [y]w1 [y]
T2 : r2 [y]r2 [x]w2 [y]w2 [x]r2 [z]
Following are the two possible serial schedules for T1 and T2
DBST 667- Midterm exam
This is individual assignment and you must do your own work and you may not collaborate with
All responses should be of sufficient depth and detail. Answer the questions succinctly and
clearly, and explain your answ
In data warehousing
MIDTERM PART I
1. Midterm exam is due Sunday by 11:59 pm EST.
2. Late submission - 10% penalty per day will be applied up to five days. After these
five days zero credit will be given.
3. This is an online (take-home) exam, please do
MIDTERM PART II
The table shown below lists dentist-patient appointment data. A patient is
given an appointment at a specific time and date with a dentist located at a
particular surgery. On each day of patient appointment
Name: _ Date: _
1.Data administrators may specialize in:
C)data ownership and data sharing
D)all of the above
2.Switching from a badly chosen DBMS to a good DBMS will typically involve the
Pick one of the six general testing principles described in the textbook. In your own
words, briefly summarize it and explain why it is important. (Pick one not already
discussed by another student)
I would like to discuss here about the second general p
Using UMUC Library Resources, locate a good reference about SDLC methodologies and
discuss briefly how it can help database development.
We can use the waterfall process as a means of identifying the tasks that are required, together
with the input a
1. You will create a Statement of Work document this week for your project. Based upon
your understanding of this week's reading what are your thoughts on ERD and how
does this fit into your design process?
ERD shows the graphical representation of a
Think about your lab project to answer the following questions.
1. What is your understanding of Entity Integrity Vs Referential Integrity. Illustrated with
simple examples for ease of understanding of the concepts.
Entity Integrity is the mechanism
You have been hired as a consultant by UMUC to help with their student information
system. I would like you to login to my.umuc.edu and choose one of the functionalities
(enrollment/registration, payment, etc.) of your choice, then write a simp
1. Refer to your project and explain different types of SQL (DDL, DML & DCL) with
suitable examples. Post your ERD for ease of understanding by fellow class-members.
DDL (Data Definition Language)
DDL statements are used to alter/modify a database or
1. Data Anomalies - Explain in your own words using tables from your lab project. Also
describe how such anomalies could be prevented.
Ans: Data anomalies are the problems or issues which can occur in un-normalized databases
which may be poorly organized.
Briefly explain the meaning of the ACID properties and some concurrency issues with
respect to your project.
ACID properties are an important concept for databases. The acronym stands for Atomicity,
Consistency, Isolation, and Durability.
The ACID propert
1. UMUC recruits both full time and part-time staff. How will you illustrate this scenario
using a specialization hierarchy (include some sample attributes).
Common attributes to both full time and part-time staff include: first name, last name,
Final exam question 5
Universities are facing the immense and quick growth of the volume of educational data
Data mining can find relationships and patterns that are hidden among the massive amount of
educational data. Also data mining can help in discove