SQL RDBMS Concept
Category : TECH Author : Ankur Rastogi Date : Sun Mar 06 2016 Views : 89
RDBMS stands for Relational Database Management System. RDBMS data are stored in database tables, record and fields in structured manner. Each RDBMS table consists of table rows and each row consists of data in the form of fields.
RDBMS is collection of data stored in table consisting of rows and columns. RDBMS also provides several operators to define, manipulate the data stored into the tables and indexes. Most RDBMS use SQL as a database query language.
Edgar Codd is the one who introduced the relational database model. Many modern DBMS do not conform to the Codd's defination of a RDBMS.
The Popular RDBMS are Mysql, Oracle, IBM DB2, MSSQL Server.
What are table, fields and records
RDBMS store data in tables in a structured format using rows and columns. Tables uses several fields to define data stored in table.
| Id | Name | Branch | Year |
|---|
| 1 | Amar Kumar | CSE | Ist Year |
| 2 | Surabhi Goyal | CIVIL | IInd Year |
| 3 | Amit Gupta | CSE | IInd Year |
| 4 | Ramesh Khanna | ECE | IIIrd Year |
In above example this whole table is Students table in which student data is stored in a structured manner in rows and columns. Rows are also referred as records. Each rows consist of a student details with each column depicts different type of data. Id, Name, Branch, Year are the fields that tells us the type of data in that column. So above table contains 4 records.
RDBMS stands for Relational Database Management System. RDBMS data are stored in database tables, record and fields in structured manner. Each RDBMS table consists of table rows and each row consists of data in the form of fields.
RDBMS is collection of data stored in table consisting of rows and columns. RDBMS also provides several operators to define, manipulate the data stored into the tables and indexes. Most RDBMS use SQL as a database query language.
Edgar Codd is the one who introduced the relational database model. Many modern DBMS do not conform to the Codd's defination of a RDBMS.
The Popular RDBMS are Mysql, Oracle, IBM DB2, MSSQL Server.
What are table, fields and records
RDBMS store data in tables in a structured format using rows and columns. Tables uses several fields to define data stored in table.
| Id | Name | Branch | Year |
|---|
| 1 | Amar Kumar | CSE | Ist Year |
| 2 | Surabhi Goyal | CIVIL | IInd Year |
| 3 | Amit Gupta | CSE | IInd Year |
| 4 | Ramesh Khanna | ECE | IIIrd Year |
In above example this whole table is Students table in which student data is stored in a structured manner in rows and columns. Rows are also referred as records. Each rows consist of a student details with each column depicts different type of data. Id, Name, Branch, Year are the fields that tells us the type of data in that column. So above table contains 4 records.
Disclaimer: The above content reflect author’s personal views and do not reflect the views of OYEWIKI. Neither OYEWIKI nor any person/organization acting on its behalf is liable to accept any legal liability/responsibility for any error/mislead in this information or any information available on the website. This website in no way accepts the responsibility for any loss, injury, damage, discomfort or inconvenience caused as a result of reliance on any information provided on this website.
If you want to add more comments to the article or you see any thing incorrect please write a comment below and we will surely get back to you.
