Open Source Projects
This page consists of DBMS interview questions and answers.
DBMS or Database Management System is a collection of programs that allows users to create and manage databases.
Following are some of the popular DBMS softwares used in the industry.
A database is a logical collection of organised data that can be easily accessed, updated and managed.
For example we can have a school database to store school related data.
Collection of databases and DBMS software makes a database system.
RDBMS or Relational Database Management System is a database management system based on the relational model invented by Edgar Frank Codd.
In RDBMS data is represented in terms of tuples or rows.
So, RDBMS consists of databases which contains tables which contains rows.
A table is a collection of related data stored in rows and columns.
For example we can have a students table to store student data like studentid, name etc.
Following is an example of a student table.
A row (also referred as record) is the horizontal entity of a table representing an individual entry.
Following is a row from the student table.
A field is an entity of a table that contains specific data of every records.
Following are the fields of the student table.
A column is a vertical entity of a table representing all the data of a particular field.
Following is the firstname column of the student table.
Following are the advantage of using DBMS over file based system.
Have fun learning :-)
Copyright © 2014 - 2018 DYclassroom. All rights reserved.
rendered in 0.0391 sec