Table of Content

RDBMS relational database

How relational Database System is Organized ?

Database Management System is overall program that manages one or more databases. Relational Database Management system is used to manage -

No Use of RDBMS
1 Real time database system
2 Whether forecasting application
3 Space Research and Electronics Lab
4 Banking
5 College Administration
6 Buy-Sell Application
7 Insurance Application
8 Telephone Management.

Database System is organized in following way -

Different Objects of RDBMS Structure :

  1. Database
  2. Table
  3. Field
  4. Record
Databse Object Explanation
Databse A database is an organized collection of data for one or more purposes, usually in digital form. (e.g College Database)
Table Table is a set of data elements (values) that is organized using a model of vertical columns (which are identified by their name) and horizontal rows.
Field Individual Column of the database table is called as “Field”
Record Individual Row of the database table is called as “Record”

Explanation of the RDBMS :

  1. We have topmost layer i.e Relational Database management system which manages different databases.
  2. RDBMS is an application Software.
  3. Using RDBMS we have created two databases i.e RDBMS can manage at least single database .
  4. In the individual database we can create number of tables. These tables may be interlinked to each other or may be separate tables.
  5. We can fire queries on the database table or on whole database. [ Query Language is used to fire queries on the database called SQL]
  6. Each Table have unique key in order to identify Individual Record called primary key.

As explained earlier RDBMS is an application software , there are number of application software(s) present in the market as of today. Below is the list of some application softwares -

Different Application Softwares :
MS SQL Server Microsoft Access MSDE
Oracle DB2 Sybase
MySQL Postgres Informix