RDBMS
RDBMS(Relational Database Management System)
Relational Database Management System, is a software system or collection of various programs that work together on a relational datamodel database and offer various integrated entities like – Database administration, Data definition, creation, updation etc.
In this article , we will learn about RDBMS.
RDBMS?
RDBMS – Relational Database Management System, is a software system or collection of various programs that work together on a relational datamodel database and offer various integrated entities like – Database administration, Data definition, creation, updation etc. Some examples of RDBMS are –
- SQL
- mySQL
- IBM DB2
- Oracle
- Microsoft Access
RDBMS was introduced by E. F. Codd.
The basic structure of RDBMS revolves around tables like –
Column or Attribute
Column is all the values for a particular attribute for a table. This information is stored vertically.
For example – for students all the names as shown in the image will be the column.
Table
The data in RDBMS systems are stored inside tables.
- In the first row, each column contains the attribute names of an entity
- The next set of rows contain the data for an entity set object
Record or Row
The each row containing the data about a single entity in the entity set is called the record. This is also known as tuple as well.
Example –
For students studying in a university the entity is student and information about roll number 1 is stored in the a row which has values of all information like name, age, gpa year etc.
Field
Fields are nothing but the list of all possible attributes for the table. Roll_No, name, age, GPA, year all are fields.
Prime Course Trailer
Related Banners
Get PrepInsta Prime & get Access to all 200+ courses offered by PrepInsta in One Subscription
Get over 200+ course One Subscription
Courses like AI/ML, Cloud Computing, Ethical Hacking, C, C++, Java, Python, DSA (All Languages), Competitive Coding (All Languages), TCS, Infosys, Wipro, Amazon, DBMS, SQL and others
Login/Signup to comment