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 -
- Real time database system
- Whether forecasting application
- Space Research and Electronics Lab
In the day to day life we can use database system inside -
- Banking
- College Administration
- Buy-Sell Application
- Insurance Application
- Telephone Management.
Database System is organized in following way -
RDBMS Structure contain Different Objects such as -
- Database
- Table
- Field
- 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 :
- We have topmost layer i.e Relational Database management system which manages different databases.
- RDBMS is an application Software.
- Using RDBMS we have created two databases i.e RDBMS can manage at least single database .
- In the individual database we can create number of tables. These tables may be interlinked to each other or may be separate tables.
- We can fire queries on the database table or on whole database. [ Query Language is used to fire queries on the database called SQL]
- Each Table have unique key in order to identify Individual Record called primary key.
As explained earlier RDBMS is and application software , there are number of application softwares present in the market as of today -
List of some application software are -
- MS SQL Server
- Microsoft Access
- MSDE
- Oracle
- DB2
- Sybase
- MySQL
- Postgres
- Informix
What we have learned through this article ?
- What is Relational Database Management System
- Where database system is used in real life ?
- How relational Database System is Organized ?
- Different Database Objects
- List if Application Softwares
