Scribd
Upload
6 views4 pages

Adbms Assignment#02

The document is a submission by Mariha Malik for a course on Advanced Database Management System, detailing the differences between full and incremental backups, and the importance of recovery in database systems. It emphasizes the need for consistency, minimizing data loss, and maintaining integrity, with a real-world example involving a bank server crash. Additionally, it outlines practical tasks related to MySQL backup and recovery, including creating a database, taking a backup, and restoring it.

Uploaded by

23-20911-060
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
6 views4 pages

Adbms Assignment#02

The document is a submission by Mariha Malik for a course on Advanced Database Management System, detailing the differences between full and incremental backups, and the importance of recovery in database systems. It emphasizes the need for consistency, minimizing data loss, and maintaining integrity, with a real-world example involving a bank server crash. Additionally, it outlines practical tasks related to MySQL backup and recovery, including creating a database, taking a backup, and restoring it.

Uploaded by

23-20911-060
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

SUBMITTED BY:

NAME: MARIHA MALIK


ROLL NO: 23-BCS-060
SEMESTER: IV-A
SESSION: 2023-2027

SUBMITTED TO:

INSTRUCTOR: RESPECTED Ms. AIMAN NAEEM


COURSE TILTLE: ADVANCED DATABASE
MANAGEMENT SYSTEM

SUBMISSION DATE:

APRIL 28, 2025


FATIMA JINNAH WOMEN UNIVERSITY
Department of Computer Science

Q1: Conceptual Understanding

a) What is the difference between full backup and incremental backup?

Full BackUP Incremental BackUp


Definition: It provides the complete copy of Definition: It provides only the files that
the existing database. were changed or newly created after the
last backup will be saved.
Pros: Simple recovery and fast restore Pros: Faster and less storage.
Cons: Time-consuming, storage-heavy. Cons: Slower recovery (needs full + all
incrementals).
Weekly backups Daily backups

b) Why is recovery important in database systems? Give a real-world example.

Hardware failures, software crashes, human errors, and malicious attacks can corrupt data.

Importance:

• Consistency: Database remains in a valid state. It restore the existing database to


a consistent state. It ensures that the database remains accurate and consistent
even after unexpected problems.

• Minimize Data Loss: It minimizes data loss. It saves as much recent data as
possible, reducing the amount of information lost during failures.

• Integrity: It ensure transaction integrity. Recovery ensures that all completed


transactions are saved permanently, and incomplete ones are properly rolled
back to maintain database correctness.

Example:

If a bank server crashes during a money transfer, the recovery process ensures that
either the complete transaction happens or none of it happens, preventing any loss or
duplication of money.
FATIMA JINNAH WOMEN UNIVERSITY
Department of Computer Science

Q2: Practical Task – MySQL Backup & Recovery

Perform the following tasks on a MySQL database (you may use XAMPP/WAMP or any live
MySQL server)

1. Create a sample database named student_portal with one table: students having fields
(id, name, department). Insert at least 3 sample records.

2. Take a backup of this database using the mysqldump command. Attach a screenshot.
FATIMA JINNAH WOMEN UNIVERSITY
Department of Computer Science

3. Drop the database and then restore it using the backup file. Attach a screenshot of the
restored data.

You might also like