DBMS Handwritten Notes
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.
Topics in our DBMS Handwritten Lecture Notes PDF
In these “DBMS Handwritten Lecture 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.