Scribd
Upload
3 views6 pages

DBMS Notes

The document provides an overview of Data, Database, and Database Management System (DBMS), explaining their definitions and examples. It outlines the characteristics of DBMS, including data integrity, security, independence, transaction control, concurrency control, and recovery. Additionally, it discusses the advantages of DBMS, the three-level architecture, and the concept of data independence with its types.

Uploaded by

21suhanigupta
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
3 views6 pages

DBMS Notes

The document provides an overview of Data, Database, and Database Management System (DBMS), explaining their definitions and examples. It outlines the characteristics of DBMS, including data integrity, security, independence, transaction control, concurrency control, and recovery. Additionally, it discusses the advantages of DBMS, the three-level architecture, and the concept of data independence with its types.

Uploaded by

21suhanigupta
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

DBMS Notes

Q1 Short note on : Data , Database and DBMS?

Data :-
The facts and figures that can be recorded in a computer system and that have some special meaning assigned to
them.
Example: Data of a customer like name, telephone number, address, product purchased date etc.
As the need for data increased, there was a need to develop a computer-based system for storing and managing data.

Database :-
A database is a collection of related data items stored at one place, organized for easy access, management, and
updates.
Example: College database storing information about students, teachers, classes, and subjects.
It is designed to offer an organized mechanism for storing, managing, and retrieving stored information.

DBMS (Database Management System):-


- A collection of software/programs for creating and maintaining a database.
- Helps define, construct, and manipulate databases.
- Integral part of information systems in organizations.
DBMS Notes

Q2 Explain the characteristics of DBMS?

1. Data Integrity: Ensures accuracy of data entered.


2. Data Security: Only authorized users can access/modify data.
3. Data Independence: Changing data at one place doesn't affect other locations.
4. Transaction Control - Rollback: Changes can be undone (rollback) or saved (commit).
5. Concurrency Control: Multiple users can access the data simultaneously.
6. Data Recovery - Backup and Restore: Restores data after failures using backups.
DBMS Notes

Q3 State advantages of DBMS?

1. Data Independence
2. Efficient Data Access
3. Data Integrity and Security
4. Concurrent Access and Crash Recovery
5. Data Administration
6. Reduced Application Development Time
DBMS Notes

Q4 Explain 3 level architecture of DBMS?

1. Physical Level: How data is stored.


2. Conceptual Level: What data is stored and relationships.
3. View Level: How data is presented to users.
DBMS Notes

Q5 What do you mean by data independence and explain its type in details?

- Data Independence: Modify one level of schema without affecting other levels.
Types:
1. Physical Data Independence - Changes in internal schema do not affect conceptual schema.
2. Logical Data Independence - Changes in conceptual schema do not affect external schema.
DBMS Notes

Q6 Explain detailed architecture of DBMS?

A) Storage Manager:
- Authorization and Integrity Manager
- Transaction Manager
- File Manager
- Buffer Manager

B) Query Processor Components:


- DDL Interpreter
- DML Compiler
- Query Evaluation Engine

C) Application Architectures:
1. Naive Users
2. Application Programmers
3. Sophisticated Users
4. Specialized Users
5. Database Administrator (DBA)

You might also like