Quick Contact

     

    Relational Model in DBMS

    The relational database model derived from the mathematical concept of relation and set theory. It was proposed as a technique to data modeling by Dr Edgar F. Codd of IBM Analysis in 1970 in his document entitled “A Relational Technique of Information for Huge Shared Data Banks.” This document marked the start of the field of a relational database.

    The relational model is based on concept of a relationship that is physically defined as a table. In this model, tables are used to hold data about the object to be set in the database. A relation is defined as a two-dimensional table in which rows of the table correspond to single records, and the columns correspond to attributes. Each row is known as a tuple, and each column is known as an
    attribute.

    Domain

    A domain is a collection of atomic values. Atomic defines that each value in the domain is hidden to the relational model. A domain is generally specified by name, data type, format, and constrained range of values. For example, as shown in figure attribute EMP-NO, it is a domain whose data type is an integer with a value ranging between 1, 00,000 and 2, 00, 00. Attributes are the properties that specify a relationship. For example, EMP-NO, NAME.

    Relational Model in DBMS
    Attributes

    Attributes are the properties that prescribe a relation. For example, EMP-NO, EMP-NAME.

    Relation Schema

    The relation schema refers to the mechanism of a table.

    Example: EMPLOYEE (EMP-NO, EMP-NAME, DATE-OF-BIRTH, SEX, TEL-NO, and SALARY) is a relation schema for EMPLOYEE. If a schema has greater than one relation, it is known as Relational Schema.

    Tuple

    Each sequence in the relation is called a tuple. The relation includes 6 tuples, one of which is shown as:

    106510 Rajesh Sharma 10-Feb-1993 Male 9813245678 50,000
    Relation Instance

    The set of records of a relation at a specific instance of time is known as relation instance. The table shows the relation example of EMPLOYEE at a particular time. It can modify every time there is an insertion, deletion, or updation in the database.

    Degree

    The number of columns in the table is known as the degree of the relation. EMPLOYEE relation has degree 6.

    Cardinality

    The number of rows in a table is called the cardinality of the relation. EMPLOYEE relation has cardinality 6.

    NULL Values

    The value which is anonymous or not available is known as a NULL Value. It is described by blank space.

    Example
    EMP-NO EMP-NAME DATE-OF-BIRTH SEX TEL-NO SALARY
    106510 Rajesh Sharma 10-Feb-1993 Male 9813245678 50,000
    112233 Sonali Gupta 20-June-1994 Female 9824567890
    123243 Avinash Kumar 24-Dec-1989 Male 8186754321 38,000
    109876 Abhishek Singh 12-Oct-1990 Male 9034567890 55,000
    111222 Nisha Sharma 10-Jan-1995 Female 8045896512
    165234 Naitik Arora 12-Feb-1992 Male 9321789047 35,000
    Operations of the Relational Model
    1. Insertion

      Deletion is also secure. For example, delete a tuple from EMPLOYEE relation in a figure whose EMP-NO is 112233.

    2. Deletion

      Deletion is also secure. For example, delete a tuple from EMPLOYEE relation in a figure whose EMP-NO is 112233.

    3. Updation

      Updation is also easy. For example, change the salary of an employee whose EMP-NO is 123243 from 38,000 to 42,000.

      Hence, in the relational model, insertion, deletion, and updation operation are quite comfortable.

    Advantages of the Relational Model

    The advantages of the relational model approach are as follows:

    Relational Model in DBMS
    Ease of Use

    The revision of any record as tables including rows and columns is quite natural and therefore, even first time client as follows finds it attractive.

    Security

    Security control and authorization can also be implemented more by merely changing sensitive attributes in a given table into a separate association with its authorization controls. If the authorization requirement authorizes, a specific attribute could be joined back with others to allow full data retrieval.

    Data Independence

    Data independence is accomplished more simply with organization architecture used in a relational database than in the more complex tree or network structure.

    Flexibility

    Different tables from which data has to be connected and extracted can be simply manipulated by operators such as a project and joint to give data in the structure in which it is desired.

    Precision

    The procedure of relational algebra and relational evaluation in the manipulation of the relations among the tables secure that there is no bug, which may differently arise in establishing the linkage in a complex network type database.

    Data Manipulation Language

    The possibility of responding to Adhoc query using a language based on relational algebra and relational calculus is accessible in the relational database technique. For data organized in other mechanisms, the query language either develops into complicated or extremely limited in its capabilities.

    Disadvantages of the Relational Model

    The disadvantages of relational model approach are as follows:

    Relational Model in DBMS
    Cost

    One disadvantage of relational databases is the cost of setting up and keeping up the database framework. To set up a relational database, we generally want to buy specific software. If we are not a developer, we can use several products to set up relational databases. It does not take time to enter in all the information and set up in the program.

    Abundance of Information

    Advances in the complexity of data cause another limitation to relational databases. Relational databases are made for organizing information by common characteristics. Complex images, numbers, designs, and multimedia items defy simple categorization leading the technique for a new type of database known as object-relational database management frameworks. These frameworks are designed to manage more complex functions and can be versatile.

    Structured Limits

    Some relational databases have restrictions on area lengths. When we design the database, we have to specify the amount of data we can fit into a field. Some names or search queries are shorter than the actual, and this can lead to information loss.

    Properties of Relational Tables

    The properties of relational tables which are as follows:

    Values are Atomic

    This feature includes columns in a relational table that are not copying class and arrays. Hence, composite and multi-valued attributes are not allowed.

    Every row is different

    This feature gives that no two rows in a relational table are interchangeable.

    The series of columns is unimportant

    This features provides that the series of columns in the relational table has no implication. A column can be reconstructed in any order and numerous series.

    The series of a row is unimportant

    This feature ensures that the sequencing of rows in the relational table has no implication.

    Each column has a unique name

    This property states that the name of each column should be unique.

    Enroll Yourself in Live Training: DBMS Training

    Copyright 1999- Ducat Creative, All rights reserved.