Home / DBMS / Relational database management system

Relational database management system

Relational database management system(RDBMS)

rdbms
http://www.conlinetraining.com

Relational database management system is a collection of related files that allow managing the records into an organized format. A method that represents the records into rows and columns format, known as RDBMS. It provides relations between the entity with the help of common attribute, the database application support. RDBMS to manage the record and control its processing. RDBMS allow accessing the data and support. SQL for managing data record like insert, delete, update etc

RDBMS TERM

  1. Relations-> It is a term of RDBMS that identifies the entity of database. In general term, we use the table for data storage as a relation.
  • Name-> It identifies the name of the related entity for accessing the data.
  • Degree-> This term identifies the attribute of a particular entity.
  • Cordinality-> It is a term of RDBMS that identifies the record of the particular table.

       2. Attributes and tuples-> It is a way to identify the columns of data tables              and records. Here attributes columns and tuple identify the records.

3.Entity, Entity set, and instence->

  • Entity-> It is a term of DBMS that identify a file of the database.
  • Entity set-> It identifies a group of file database.
  • Istances-> Set of information stored in a database at a particular event that is known as instances of the entity.

Relational data entity

RDBMS are allowed to store the data in rows and columns format. It allows sharing the data file between multiple users so we need to protect important data to the unauthorized user. RDBMS provide integrity rule for protecting the data and its processing after sharing the record the integrity method is to perform at the data entry develop and check the value before insert into the data.

Integrity Rules

Entity integrity-> If an attribute of a table is a prime attribute or unique, it cannot accept null value or in other words, no component of the primary field contains blank records. This integrity rule supports primary key to scoring the record and the data. It is basic use to avoid a repeated record.

Referential integrity->To ensure that value appears in one relation for a given set of attribute also appears for a particular attribute in other relation, this condition referential integrity. This integrity rule supports foreign key that generates after relating the file database. The concept the foreign key maintain in the file of the database as a reference key.

Relational model

relational model
https://upload.wikimedia.org

It is a collection of related files that allow managing the records into an organized format. A method that represents the records into rows and columns format, known as RDBMS. It provides relations between the entity with the help of common attribute, the database application support. RDBMS to manage the record and control its processing. RDBMS allow accessing the data and support. SQL for managing data record like insert, delete, update etc

Base Table

A table is a collection cell and tells also the combination of row and columns. The cell is used to store the information in a tabular format and it helps to access the data with its object for processing. A database can contain more than one tables and related together with the help of common field. The table is used also as temporary for data process.

Relational manipulation

RDBMS allow managing the database where the database organized in a particular format. The table is used RDBMS for representing the information and also allow to related with another table for manipulation the data are arranged in row and columns so we can easily execute the operation of data like the update, delete etc.

 

 

About Pulkit Wadhwa

Check Also

SQL Basics

SQL SQL is a structured query language. It is a non-procedure language that allows built-in function …

Leave a Reply

Your email address will not be published. Required fields are marked *