![]() In the next articles, we will go through the database tutorial (Database Management Tutorial) on various topics. This DBMS tutorial is written to help students understand database concepts. ![]() 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. RDBMS is a program that guides us on how to create and maintain a database. Hence they introduce certain rules to manage the database – relational database management system (RDBMS). 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 on a single table. Next comes courses offered in that college, Staff and their details, students and their details. What could a college database contain? First thing is that we need to store college information like its name, address. Say, we need to create the College database. It all depends on what database we are developing, and what is the exact requirement/purpose of it. How do we determine which data is relevant to be put in a particular database? 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. We store only related data – related to one particular requirement/application. For example, Student, Teacher, Class, Subject, Employee, Department, etc form individual tables. It reduces the time to search for particular data in a whole database. This helps in identifying which data is stored where and under what name. In a database, we would be grouping only related data together and storing them under one group name called a table. What type of data is stored in the database? But all the data will be in one place – 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. We would be storing all this information in the database. If some entry is wrong or irrelevant, we correct it or strike it off. At the end of a certain period or year, we would check up if he/she is growing correctly. What we do is note it in a piece of paper every month. Say, we do not have any database and we want to record what is the height and weight of a baby in a year. ![]() We need data so that we can perform various actions on them. In short, all the living and non-living objects in this world are data. For example, the Student is data, the course is data, and Color is data, height, weight, food everything is data. But what is data? In a database, even the smallest piece of information becomes data. A database is a place/container where all the data is stored. Following are the key topics of DBMS which will help us to clear the concepts of the database management systems. In this tutorial, we will cover the concepts of DBMS in detail. This tutorial can be a relational database management systems tutorial as well. DBMS Tutorial or Database tutorial contains various topics that will help you to master the database concepts and you can learn DBMS for your curriculum. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |