RDBMS

January 27, 2023

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 –

Functional Dependencies

Joins in DBMS

Relational Algebra

Deadlock in DBMS

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