Assignment – Database Management System (DBMS)
Q1) Define DBMS. Explain its advantages and disadvantages.
Defini on:
A Database Management System (DBMS) is so ware that is used to store, organize, and manage
data in a structured way. It allows users to create, update, retrieve, and manage data efficiently.
Examples: Oracle, MySQL, SQL Server, PostgreSQL.
Advantages of DBMS:
1. Data Redundancy Control – Avoids duplica on of data.
2. Data Sharing – Mul ple users can access the same database at the same me.
3. Data Security – Provides access control and authen ca on.
4. Backup and Recovery – Automa c backup and recovery in case of failure.
5. Consistency – Ensures that the data is correct and consistent.
Disadvantages of DBMS:
1. Costly – Requires expensive hardware and so ware.
2. Complexity – Needs trained people to manage.
3. More Storage – DBMS so ware takes large space.
4. Performance – Some mes slower than simple file systems for small data.
Q2) Differen ate between File-Based System and DBMS.
File-Based System DBMS
Data is stored in separate files. Data is stored in a single database.
Redundancy (duplica on) is high. Redundancy is controlled.
No proper security. Provides high security and access control.
Difficult to update or retrieve. Easy to update and retrieve using queries.
Backup and recovery are difficult. Automa c backup and recovery available.
Example: Text files, spreadsheets. Example: MySQL, Oracle, SQL Server.
Q3) Explain the 3-level Database Architecture (3-Schema Architecture) with neat diagram.
Defini on:
The 3-level architecture is a framework for DBMS that separates the database into three levels to
provide data abstrac on and independence.
The three levels are:
1. Internal Level (Physical Schema):
o Lowest level, deals with physical storage of data.
o Example: How data is stored in hard disk.
2. Conceptual Level (Logical Schema):
o Middle level, shows structure of the database for the whole organiza on.
o Example: Tables, rela onships, en es.
3. External Level (View Schema):
o Top level, describes how data is viewed by different users.
o Example: Student can only see his marks, teacher can see marks of all students.
Q4) What is Data Abstrac on? Explain types of Data Abstrac on.
Defini on:
Data Abstrac on means hiding the complexity of the database from the user and showing only
necessary details.
Types of Data Abstrac on:
1. Physical Level:
o Lowest level, shows how data is stored physically.
o Example: Data stored in files, blocks, indexes.
2. Logical Level:
o Middle level, shows what data is stored and rela onship between them.
o Example: Student table with a ributes Roll No, Name, Marks.
3. View Level:
o Highest level, shows only part of the database to the user.
o Example: Student can only see his details, not others.
Q5) Define the following terms with example: Data, Database, Informa on
Data: Raw facts and figures without meaning.
Example: 75, 80, 90.
Database: A collec on of logically related data.
Example: Student database with roll no, name, marks.
Informa on: Processed data that has meaning.
Example: "The average marks of class is 82."
Q6) Define Instance and Schema with Example.
Schema:
o The overall design or structure of a database.
o Example: Student(Roll_No, Name, Marks).
Instance:
o The actual content (data) of the database at a par cular me.
o Example:
Student Table →
(1, Ravi, 85), (2, Priya, 92).
Q7) Define Data Independence. Explain Logical and Physical Independence with Example.
Defini on:
Data Independence means the ability to change the schema at one level without affec ng the
schema at the next higher level.
Types:
1. Logical Data Independence:
o Ability to change logical schema without changing external schema.
o Example: Adding a new column "Email" in student table does not affect how
students see their marks.
2. Physical Data Independence:
o Ability to change physical schema without changing logical schema.
o Example: Changing data storage from hard disk to SSD does not affect database
tables or queries.