# data[].attributes.body
• Definition of Transaction
• Properties of Transactions
• Database Architecture

# data[].attributes.body
Example:  Banking system

Q n A: Program – data independence refers to (?)

Q n A: Program – data independence is called (?)

# data[].attributes.body
Q n A: Which diagram model used  (?)

# data[].attributes.body
List the process at (?)

# data[].attributes.body
The type of interaction (?)

# data[].attributes.body
• Problems of Concurrency Control
• Serializability
• Recoverability

# data[].attributes.body
Discuss in Groups and Group Leader Update the discussion

# data[].attributes.body
• Timestamping Methods
• Optimistic Techniques
• Granularity of Data Items
• Locking Methods

# data[].attributes.headline
Database Recovery  Requirements Engineering

# data[].attributes.subject
Database Recovery  Requirements Engineering

# data[].attributes.body
• Concepts
• Transactions  and Recovery
• Recovery Facilities
• Backup Mechanism
• Log File
• Checkpointing
• Recovery Techniques
• Shadow Paging
• ARIES Recovery Algorithm

# data[].attributes.body
• Threats
• Authorization
• Discretionary Access
• Mandatory Access Control

# data[].attributes.body
• Multilevel Relations and Polyinstantiation
• Views
• Backup and Recovery

# data[].attributes.body
• Encryption
• RAID (Redundant Array of Independent
Disks)
• DBMSs and Web Security

# data[].attributes.body
Test 1 is on this week.

DATE: 27 NOVEMBER 2023 (MONDAY)

TIME: 4-5 PM

VENUE: DUP C

# data[].attributes.body
ALL THE BEST !

# data[].attributes.body
You can discuss assignmnet 1 here

# data[].attributes.body
QnA: Transaction consists of 2 database operations:?
QnA: A non-database operation:?

# data[].attributes.body
Explain in your own words the state of Transactions.

# data[].attributes.body
Concurrency Control:
• Problems of Concurrency Control

# data[].attributes.body
Concurrency Control :
• Serializability

# data[].attributes.body
Concurrency Control:
• Recoverability

# data[].attributes.body
Concurrency Control:
• Locking Methods

# data[].attributes.body
Answer

1-d 6-c 11-b

2-b 7-b 12-d

3-a 8-d 13-c

4-b 9-b 14-b

5-b 10-b 15-b

# data[].attributes.body
2 Phase Locking Method

# data[].attributes.body
2 PL : write ur answer for the above 2PL

# data[].attributes.body
Deadlock

# data[].attributes.body
Deadlock

Write your answer for the above Deadlock.

# data[].attributes.body
Assignmnet 1 Discussion

# data[].attributes.body
What is your suggestion?

# data[].attributes.body
LIST OF GROUPS AND GROUP MEMBERS.

27 OCTOBER 2025 (82/84) STUDENTS

All the Best !

# data[].attributes.body
Latest by 10.00 am submit your assignment (pdf) uploaded by Group Leaders ONLY.

# data[].attributes.body
Answer

1-d 6-c 11-d

2-b 7-b 12-b

3-a 8-b 13-b

4-b 9-b 14-b

5-b 10-c 15-b

# data[].attributes.body
Answer : Tutorial 3

1-b 6-b

2-d 7-d

3-b 8-b

4-a 9-b

5-c 10-c

Answer : Tutorial 4

1-b 6-b

2-d 7-c

3-a 8-b

4-b 9-a

5-c 10-c

Answer : Tutorial 5

1-c 6-b

2-c 7-b

3-b 8-b

4-d 9-b

5-b 10-c

Answer : Tutorial 6

1-b 6-b

2-d 7-d

3-b 8-a

4-b 9-b

5-b 10-a