"Database in simple terms is the coolest way of organising data. Imagine you have a messed up desk filled with books. You might probably have books of more semesters and right before the exam you need to find your book!! Here are the simple steps take all the books out and waste an hour to find the book or you might just have arranged your books and aligned them in an ordered fashion (any sort of arrangement would work except "random" -_- ! )."
Now coming to the technical defination Database is a collection of inter-related data. The data stored in a Systematic way isn't enough for the fast accessing of the relavent data. We need some tools to manage the data for example delete, add or manipulate the data. So this is how the concept of Database Management System comes into play. Database Management System i.e. DBMS is the collection of relavent data along with all the tools and a complete budle of libraries to manage it.
In this category we will go through the following sections:-
Some basic concepts of Database.
Data Modelling using ER (Entity relationship) Model.
Concept of keys in Database.
Extended ER- Generalisation, Specialisation and reduction of ER diagram to Tables.
2. Relational Data Model concepts
Integrity contraints, Key constraints, Referential and Entity Intergrity, and Domain Contraints.
Relational Calculus- Tuple and Domain calculus.
3. SQL- Structured Query Language
4. Normalisation - upto 5NF (Fifth normal form)
5. Transaction- concepts, serialisation, recovery and Deadlock Handling.