DBMS Handwritten Notes
Topics in our DBMS Handwritten Notes PDF
In these “DBMS Handwritten Notes PDF”, you will study the foundations of database management systems focusing on significance of a database, relational data model, schema creation and normalization, transaction processing, indexing, and the relevant data structures (files and B+-trees).
The topics we will cover will be taken from the following list:
Introduction to databases: Characteristics of database approach, data models, database system architecture, data independence and data abstraction.
Data modeling: Entity relationship (ER) modeling: Entity types, relationships, constraints, ER diagrams, EER model
Relation data model: Relational model concepts, relational constraints, relational algebra.
SQL queries: SQL data definition, data types, specifying constraints, Queries for retrieval, insertion, deletion, updation, introduction to views.
Database design: Mapping ER/EER model to relational database, functional dependencies, Lossless decomposition, Normal forms (upto BCNF).
Transaction and data storage: Introduction to transaction processing: ACID properties, concurrency control; Introduction to indexing structures for files.
Download DBMS Handwritten Notes PDF
Database Management System (DBMS) Notes FAQs
What are the basic terms of DBMS ?
Data: It is the representation of facts, concepts or instruction in a formal manner, which is suitable for understanding and processing.
Information: It is the organized and classified data to provide meaningful values.
File: It is a collection of related data stored in secondary memory.
What is File Oriented approach ?
In this approach, the program dependent on the files and files become dependent on the files and files become dependents upon the programs.
What is a DataBase ?
It is organized collection of related data of an organization stored in formatted way which is shared by multiple users.
What are the feature of data in a DataBase ?
The main feature of data in a database are:
1. It must be well organized
2. it is related
3. It is accessible in a logical order without any difficulty
4. It is stored only once
What is a Database Management System (DBMS) ?
A database management system consists of collection of related data and refers to a set of programs for defining, creation, maintenance and manipulation of a database.
What are the Function of Database Management System (DBMS) ?
1. Defining database schema
2. Manipulation of database
3. Sharing of database
4. Protection of database
5. Database recovery
What are the Advantages of Database Management System (DBMS) ?
1. Reduction of redundancies
2. Sharing of data
3. Data Integrity
4. Data Security
5. Conflict resolution
6. Data Independence
What is persistent, integrated and shared data in the database ?
Persistent Data: If data is removed from database due to some explicit request from user to remove.
Integrated Data: A database can be a collection of data from different files and when any redundancy among those files are removed from database is said to be integrated data.
Sharing Data: The data stored in the database can be shared by multiple users simultaneously with out affecting the correctness of data.