Database Management Tutorial

Database Management Tutorial

Before understanding the Database Management System, it is important to understand what is a database. So the database is a collection of data that is interrelated with each other. Basically database organizes the data in the form of schemas, tables, and views. In order to retrieve the data efficiently and effectively, a database is created and maintained. Database Management is a software which is used to manage all the databases. This software system acts as an interface and provides the security and consistency to the user while using the databases. A good commercial Database Management system has inbuilt support for data backup and recovery. Some of the most common database Management systems are Oracle, SQL, MySQL, etc.

Why do we need to learn Database Management?

Traditionally people used to store the data in the files but it was difficult to store, retrieve and maintain that data after some point of time. Now the Database and Database Management System came into the picture with the advanced and easy to use features in order to overcome the problems of the traditional system. Some special characteristics of modern Database Management System which make it more attractive and useful comparison to tradition system are given below:

• Consistency
• Relation tables
• Less redundancy
• Data isolation

Applications of Database Management

Talking about the applications of Database Management System, it is used everywhere and in every software be it in school record maintenance system, office portal maintenance, any e-commerce application for keeping track of each and every user using the application, storing and retrieving the data. Any software application having the features of accessing and storing the data and requires features like consistency, relation-based tables, less redundancy, security, ACID properties and isolation of data for different users requires the use of a database.

Example

Consider a scenario of a college record maintenance system that keeps a record of every student, faculty, subjects, and courses provided. We need a separate table/ record for each entity and maintaining the relationship between these entities. For example, one student can have single or multiple subjects and one course can have different subjects. Likewise, there should be one record keeping track of personal details of students like name, address, father’s phone number, etc. Moreover, records of each semester of a student are stored in a separate table. In order to maintain, store and retrieve these complex interrelated relations, a strong Database Management system is needed.

Pre-requisites

Before proceeding with the Database Management tutorial, one should have the knowledge of advanced concepts computer like memory management, security, primary and secondary memory. Apart from this, it is important to have an understanding of real data and its related concepts like why it is important to maintain it and store it efficiently.

Target Audience

Any person in the computer science field should at least have the basic knowledge of Database Management System of how it works. In the software industry, there is a separate designation of Database Manager dealing with the creation and maintenance of databases. Database Management post is high in demand these days. For those interested in this field should learn and understand each advanced concept by heart.