Scribd
Upload
48 views1 page

ADBMS Assignment Unit 1

The document provides assignment details for an Advance Database Management Systems course. It includes 6 questions focusing on transaction properties, serializability, and recoverable schedules. Students must submit handwritten answers on A4 paper by October 5th, 2022 to avoid penalty. The assignment aims to test understanding of fundamental database concepts like ACID properties, conflict serializability, types of serializability, and how to determine if a schedule is recoverable.

Uploaded by

Tathagat rubal
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
48 views1 page

ADBMS Assignment Unit 1

The document provides assignment details for an Advance Database Management Systems course. It includes 6 questions focusing on transaction properties, serializability, and recoverable schedules. Students must submit handwritten answers on A4 paper by October 5th, 2022 to avoid penalty. The assignment aims to test understanding of fundamental database concepts like ACID properties, conflict serializability, types of serializability, and how to determine if a schedule is recoverable.

Uploaded by

Tathagat rubal
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

Department of Computer Science and Engineering,

Faculty of Engineering and Technology, University of Lucknow, Lucknow

Assignment 1
Subject: Advance Database Management System Subject Code: CS 701
Last Date of Submission: October 5, 2022
Note:
1. Write answers to the questions on A4 Papers only.
2. Strictly submit on due date to avoid punishment in terms of marks assigned for
assignment submission.

1. Light on requirement of transaction? Explain ACID properties of transaction with


suitable examples for Atomicity, Consistency, Isolation and Durability.
2. Define Conflict Serializability? Consider the following two transactions and schedule
(time goes from top to bottom). Is this schedule conflict-serializable? Explain why or
why not.

3. Define Serializability? And its types with examples.


4. Explain the concept of testing for Serializability with example.
5. Differentiate Conflict and View Serializability with examples.
6. What do you mean by recoverable schedule? How you will decide that a particular
schedule is recoverable or not, justify your answer with suitable example.

Faculty: Dr. Jasvant Kumar

You might also like