a particular variety of database that works by connecting tables to each other. It is the most popular form of database and the type we will discuss most in this class.

Relational Database

Explanation:

Relational Database is the type of database in which data is stored and presented in the form of tables and it is used to access, manipulate and manage data. Table is also called a relation. It consists of rows and columns where rows represent a record of data and columns represent the attributes of the data. Every table has a primary key which uniquely identifies a row in a table and a foreign key is used to establish relationships among tables. In relational database domain is used to define specify the possible values that an attribute can have. Constraints can also be applied to the values of the attributes in the table. There are many advantages of a relational database. It can organize and manage bulk of information. It is easy to add or delete data in the relational database according to the change in requirements. Relational database ensures the consistency and integrity of data when many users obtain the same database at same time by using concurrency control methods. It ensures security by limiting access rights to the data. It also eliminates data redundancy and dependency using normalization technique which ensures data integrity and accuracy.