×

Relational DBMS Concepts

What is RDBMS?

RDBMS stands for Relational Database Management System.
The relational database management system is a type of DBMS that stores information in the form of related tables and uses a relational model defined by the EF Codd.
Relational DBMS is a system that manages the relational databases. The database is called ‘relational’ because the values in each table are related to each other. A Relational database is a collection of an organized set of tables (rows and columns) from which data can be accessed easily.
Popular examples of RDBMS include Microsoft Access, SQL Server, Oracle database, MySQL and IBM DB2.

Features of RDBMS

  • It provides data to be stored in the tables in the form of rows and columns.
  • It provides the facility of primary key to uniquely identify each row in a relation.
  • It creates indexes for fast data access.
  • It provides the primary and foreign key to share a common column in more than one table.

Table

In RDBMS, a table is a collection of data elements represented in a structured format in terms of rows and columns. In a database, each table has a specific name. It is the simplest form for storing the data in the relational database management system.
Databases contain multiple tables, where each table is designed for a specific purpose.
For example, a college database may contain separate tables for students, course, and Teachers. Each table in a database may include its own set of attributes or fields, based on what type of data, the table needs to store. In tables, each field or attribute is considered as a column, while each record is considered as a row. Specific value can be retrieved from the database table by requesting data from an individual column and row.

Database: College

Table: Student

Roll no. Name City Age
101 Akhil Meerut 20
102 Chetan Delhi 22
103 Anubhav Ghaziabad 21
104 Rishabh Shivam 20

Table: Course

Course_id Course_name
C1 MCA
C2 M. tech
C3 MBA

Table: Teacher

Teacher_id Name City
201 Ankit Delhi
202 Manoj Delhi
203 Tarun Ghaziabad
204 Yash Delhi

Record

Each row in the database table is known as a record. It is also known as a tuple. A record or tuple is composed of attributes and contains the data about one particular person or an item in a database. Highlighted row for the roll no 102 in the below table Student is an example of a record.

Table: Student

Rollno Name City Age
101 Akhil Meerut 20
102 Chetan Delhi 22
103 Anubhav Ghaziabad 21
104 Rishabh Shivam 20

Field

A database table consists of several rows. Each row can be broken down into several smaller entities known as fields. It is also known as an attribute.
A field or an attribute is a column in the database table which is designed to maintain particular information about each row in the table. The above student table consists of four attributes Rollno, Name, City and Age.

Table: Student

Rollno Name City Age

Degree

The number of fields or attributes in a relation or table is known as a Degree. The above table Student has degree 4.

Cardinality

The number of tuples or records in a relation is known as its Cardinality. The above table Student has cardinality= 4.

Domain

A domain is a collection of possible values for an attribute in the database table. For example, a domain of month in a year can accept January, February, March…December as values, a domain of dates can accept all possible valid dates etc. We specify the domain of attribute while creating a table.
A field or an attribute cannot accept those values that are outside of its domains.

In the below table Student, the rollno attribute has an integer domain. Therefore, attribute, or column name or a field can accept only integer values, i.e., roll no cannot has values like10.11, ‘first’, etc.

Table: Student

Rollno Name City Age
101 Akhil Meerut 20
10.11 Chetan Delhi 22
first Anubhav Ghaziabad 21
104 Rishabh Shivam 20

What is a NULL value?

The value is unknown, or the value is not applicable for an attribute. It is represented by a blank space. It is different from the value filled with zero or a field that contains space.

Roll no. Name City Age
101 Akhil   20
102 Chetan Delhi 22
103 Anubhav   21
104 Rishabh Shivam 20

Related Topics

Foreign key in DBMS

Foreign key in DBMS: The Foreign key is a field or the set of fields in the relational database table, which points to the existing field in another table. It...

2 minutes read.

Redundancy in DBMS

Data redundancy is a situation that is created in the database in which the same amount of data is stored in two different places. The different places are found in a...

3 minutes read.

Components of an ER Diagram

An ER Diagram consists of the following components: Entity AttributesRelationships 1. Entity An entity may be an object, place, person, or an event which stores data in the database. In an entity-relationship diagram, an entity...

4 minutes read.

3- Tier Architecture in DBMS

Three-tier architecture is an application software architecture that arranges the output into three parts or tiers that are:  the presentation tier, where the user interacts with the application; the application...

4 minutes read.

Difference between File System and DBMS

What is File Management System? A file management system is a collection of programs that manage and store data in files and folders in a computer hard disk. A file management...

9 minutes read.

Concurrency Control Protocols

Concurrency Control Protocols Concurrency control protocols ensure the atomicity, serializability and isolation of the concurrent transactions. The Concurrency control protocols can be broadly classified into the following categories: Lock Based ProtocolTimestamp protocol Lock Based Protocol In this protocol,...

5 minutes read.

Disadvantages of DBMS

Disadvantages of DBMS With the vast list of advantages, there are some following disadvantages or limitations of the database management system. 1. High Cost The high cost of software and hardware is the...

2 minutes read.

ACID Properties in DBMS

A transaction in a database has the following four properties, known as ACID properties. These properties are used to maintain the consistency of the database in the case of system failure and concurrent...

4 minutes read.

DBMS Data Independence: Logical and Physical

Data Independence in DBMS: Data independence is a concept of DBMS which alters the schema of the database at one level of the database system without altering the schema definition...

2 minutes read.

ER Diagram of Company Database in DBMS

Entity Relationship Diagram Entity Relationship Diagrams, or ER Diagrams for short, are diagrams that show the relationships among entity sets that are stored in databases. Alternatively said, ER diagrams assist in...

3 minutes read.

Structure of DBMS

DBMS means Database Management System, which is a tool or software used to create the database or delete, or manipulate the database. Query Processor, Storage Manager, and Disk Storage are the...

3 minutes read.

DBMS Tutorial | Database Management System

Database Management System (DBMS) tutorial is all about managing and maintaining the data effectively. Our DBMS tutorial is designed for beginners as well as professionals. What is Data? Data is a real-world...

5 minutes read.

ER Diagram for School Management System in DBMS

What is ER Diagram? An ERD, or entity relationship diagram, is a diagram that depicts the connections between a group of entities contained in a database. In other words, ER diagrams...

6 minutes read.

Data Models in DBMS

Data Models in DBMS Data models are the models explaining the logical structure of the database systems. They describe the entities, attributes, and the relationship among the data elements of the...

8 minutes read.

DBMS Generalization, Specialization, and Aggregation

DBMS Generalization Generalization is a bottom-up approach in which the common attributes of two or more lower-level entities combines to form a new higher-level entity. In generalization, the generalized entity of higher level can also...

3 minutes read.

Atomicity in Database Management System

In Database Management Systems, the term "atomicity" refers to the idea that database transactions are atomic units of work. This means that either all of the operations within a transaction...

10 minutes read.

Applications of DBMS

There are various fields where a database management system is used. Following are some applications which make use of the database management system: 1. Railway Reservation System: In the railway reservation...

7 minutes read.

File Organization in DBMS

File Organization in DBMS: A database contains a huge amount of data, which is stored is in the physical memory in the form of files. A file is a set...

9 minutes read.

Domain in DBMS

Constraints: Constraints in DBMS are a set of guidelines that guarantee that authorized users who modify the database do not alter the consistency of the data. Constraints are expressed in DDL...

3 minutes read.

Advantages and Disadvantages of DBMS

We need to understand what is Database Management System before discussing the advantages and disadvantages of the database management system, and also, need to understand what were the technologies and...

5 minutes read.