Monday 12 September 2016

DBMS Concepts

DBMS is one of the core subject in the Computer Science and Engineering and most important for those who wants to make carrer in data science like Big data, Database administration.

A database management system is important because it manages data efficiently and allows users to perform multiple tasks with ease. A database management system stores, organizes and manages a large amount of information within a single software application.


Database management systems are important to businesses and organizations because they provide a highly efficient method for handling multiple types of data. Some of the data that are easily managed with this type of system include: employee records, student information, payroll, accounting, project management, inventory and library books. These systems are built to be extremely versatile.

 Query language is of two types - Procedural (Relational Algebra) and Non-procedural (Relational Calculas), where RA is basis of SQL and RC (TRC and DRC) is basis of QBE (Query by Example), Datalog. RA deals with how? and RC deals with what? i.e why these are procedural and non-procedural form of query language.

In following link i tried to summarise concepts and examples to save your time during examination preparation. Frist follow class notes and then go through these link if you have sufficient time. Some authors way of representation of a query may be different in case of TRC and DRC, in that case i suggest you to follow class notes or korth standard.

 Relational Algebra and Relational Calculus - 1
Relational Algebra and Relational Calculus - 2
Relational Algebra and Relational Calculus - 3

Difference between Relational Algebra and Relational Calculus.



DBMS  written by Avi Silberschatz,  Henry F. Korth and S. Sudarshan  is best for beginers. Here are some links where you can find some e-books, slides, examples.


Both edition is almost same and for beginers they can opt any edition. Some other reference books are
“Principles of Database Systems” by J. D. Ullman
“An Introduction to Database Systems” by Bipin Desai

 But I recommend you to follow korth book.


Now a days there are many tutorial available online with free access. If you have sufficient time during exam time then go through these link once otherwise follow concepts from class notes and korth book.


One of the best video i found on you tube is good  for basics of DBMS delivered by Ravindrababu Ravula. you can access some free demo video lectures by clicking the link DBMS Lectures by Ravindrababu Ravula.

Posted by at

1 comment:

Subscribe to: Post Comments (Atom)