Data Base Management System Made easy class room note Lecture -1

Data Base Management System Made easy class room note  Lecture -1

DBMS syllabus and reference for GATE 

Databases:   

              Relational model (ER-model, relational algebra, tuple calculus), Database design (integrity constraints, normal forms), Query languages (SQL), File structures (sequential files, indexing, B+ trees), Transactions and concurrency control;

Reference Book:-

   Database Management systems  –>   Raghu RamaKrishnan
   Database system concepts  – > Silberschatz , Korth , Sudarshan
   Database systems   – >    C.J.Date (Normalisation is very lucidly written )
   Principles of Database Systems – > J.D.Ullman  (This is a very good book )

------------------------------------------------------------------------------------------------------

 Note:-

As per analysis of GATE previous years papers  found that all the topics of the above syllabus are important so i suggest you go through all the topic but as per previous GATE paper experience probability of occurring question are more from -Normalization,normal form relation algebra, SQL query and transactions and concurrency .

Once you will go through old paper you will find that maximum time 2 question (link question) asked from SQL query only or normalization (normal form) and one marks question from rest of the syllabus so focus on these two topics  so in our lecture we will cover these topic first .

--------------------------------------------------------------------------

What is DBMS?

                           Before understand DBMS we understand some basic terminology

Database:-  Database is a collection of related data

Management System:-  A software used to manage the database in efficient way

                DataBase+Management Syatem  =DBMS

DBMS Definition:-  Database is a computer base record keeping system and the way through which we manage the system known as management system

DBMS Definition by Korth:-

                                       A Database management system is a collection of interrelated data and set of programs to access these data.

DBMS Defination by Ullman:-

                                      DBMS is powerful tool for creating and managing large amount of data efficiently and allowing it to persist over long period of time.