DBMS Tutorial

 

DBMS Tutorial

DBMS Tutorial contains various topics that will help you to master the database concepts and you can learn DBMS for your curriculum.

Database

The name itself indicates what it is. A database is a place/container where all the data is stored. But what is data?  In a database, even the smallest piece of information becomes data. For example, the Student is data, the course is data, and Color is data, height, weight, food everything is data. In short, all the living and non-living objects in this world are data.

Why we need data?

We need data so that we can perform various actions on them. Say, we do not have any database and we want to record what is the height and weight of a baby in a year. What we do is note it in a piece of paper every month. At the end of a certain period or year, we would check up if he/she is growing correctly. If some entry is wrong or irrelevant, we correct it or strike it off. The same is done using the database. We would be storing all this information in the database. If we want to check the growth, we would be pulling the information from the database, if we need to change any information, we can update/delete them. But all the data will be in one place – Database.

What type of data is stored in database?

In a database, we would be grouping only related data together and storing them under one group name called a table. This helps in identifying which data is stored where and under what name. It reduces the time to search for particular data in a whole database. For example, Student, Teacher, Class, Subject, Employee, Department, etc form individual tables.

DBMS Tutorial      DBMS Tutorial

And for whom these data are stored?

We store only related data – related to one particular requirement/application. For example, the Student database – it will have all the information of students ranging from his ID, Name, Date of birth, class, to grade, prizes who are studying in a particular College.

How do we determine which data is relevant to be put in a particular database?

It all depends on what database we are developing, and what is the exact requirement/purpose of it. Say, we need to create the College database. What could a college database contain? First thing is that we need to store college information like its name, address. Next comes courses offered in that college, Staff and their details, students and their details.  But do we store all this information under one table – College? Will the database be quick in getting the data or updating it? Certainly Not!  It would become chaos if everything is stored in a single table. Hence they introduce certain rules to manage the database – relational database management system (RDBMS). RDBMS is a program that guides us on how to create and maintain a database. It tells us how to divide related information into different tables and inter-relate them so that we can select/insert/update/delete all the related data easily and efficiently.

This DBMS tutorial is written to help students understand database concepts.

In the next articles, we will go through the database tutorial (Database Management Tutorial) on various topics.

Basic Concepts of ER Data Model

Basic Concepts of ER Data Model

Introduction ER Data Model is based on the real world objects and their relationship. In other words, each and everything, either living or non-living things...
ER Data Model

ER Data Model

Introduction We have seen what ER diagram is and what its basic concepts are. Now let us see how to draw the ER diagram using...
Convert ER Diagram into Tables

Convert ER Diagram into Tables

Introduction As the database grows, the ER diagram representation becomes more complex and crowded. It is creates a difficult situation to understand the requirement and...
Database Abstraction

Database Abstraction

Database is full of datas and records. What we see in rows and columns is quite different when it reaches the memory. What we...
Database Users and Administrators

Database Users and Administrators

Database Users Database users are the one who really use and take the benefits of database. There will be different types of users depending on...
Relational Query Languages - Relational Algebra

Relational Query Languages – Relational Algebra

Introduction So far we have seen what a database is, what is the features of database, how to gather requirements and how to put them...
Relational Calculus - Tuple Relational Calculus - Domain Relational Calculus

Relational Calculus – Tuple Relational Calculus – Domain Relational Calculus

Relational Calculus Relational calculus is a non procedural query language. It uses mathematical predicate calculus instead of algebra. It provides the description about the query...
File Organization in DBMS

File Organization in DBMS

Introduction As we have seen already, database consists of tables, views, index, procedures, functions etc. The tables and views are logical form of viewing the...
Sequential File Organization in DBMS

Sequential File Organization in DBMS

Sequential File Organization It is one of the simple methods of file organization. Here each file/records are stored one after the other in a sequential...
Heap File Organization in DBMS

Heap File Organization in DBMS

Heap File Organization This is the simplest form of file organization. Here records are inserted at the end of the file as and when they...

Stay connected

9,228FansLike

Latest article

Multiplication of two matrices

Multiplication of two matrices

Given two matrices, this function will multiply the two matrices and prints the result. Here, necessary and sufficient condition is the number of columns...
Subtraction of two matrices

Subtraction of two matrices

Given two matrices, we will write a function that subtracts the given matrices. Example INPUT A = { {1, 4, 7, 9}, {1, 6, 7, 6}, {6, 3, 7,...
Check if two given matrices are identical

Check if two given matrices are identical

Given two matrices, we will write a function to check whether the two matrices are identical or not. That is, if all the elements...