Relational model, Database Management System

A model in database system mostly defines the organisation of data or structure and a set of operations on that data. Relational model is a easy model in which database is represented as a collection of "Relations", where every relation is represented by a two dimensional table.  Therefore, because of its simplicity it is most commonly used. The following table shows a simple relation:






Sanjay Prasad


b-4,Modi Nagar


Sharad Gupta


Pocket 2, Mayur



Vibhu Datt


c-2, New Delhi

Figure: A Sample Person Relation

Following are some of the benefits of relational model:

  • Ease of use

The easy tabular representation of database helps the user define and question the database conveniently. For example, you can simply find out the age of the person whose first name is "Vibhu".

  • Flexibility

As the database is a collection of tables, new data can be added and removed easily. Also, manipulation of data from several tables can be done simply using several basic operations. For instance, we can add a telephone number field in the table at Figure.

  • Accuracy

In relational databases the relational algebraic operations are used to influence database. These are mathematical operations and make sure accuracy (and less of ambiguity) as compared to other models.

Posted Date: 3/6/2013 5:14:08 AM | Location : United States

Related Discussions:- Relational model, Assignment Help, Ask Question on Relational model, Get Answer, Expert's Help, Relational model Discussions

Write discussion on Relational model
Your posts are moderated
Related Questions
Give short note on the following terms:Dirty pages and ETL a.) Dirty pages. These are buffer pages which comprise modifications which haven't been written to disk. b.

Selective replication: This is a combination of generating small fragments of relation and replicating them rather than a entire relation. The data should be fragmented on require

The advantages of a database management system (DBMS) include :- Data integrity and elimination of duplication.

List the steps for converting state diagram to the code. a) Finding major control path b) Finding the conditional statements  c) Finding the loops  d) Finding error ro

Benefits of using heuristics

which component of DBMS can be embedded in a program? The data manipulation language (DML) is a component which is embedded in a program.

In this assignment, you will create a program that works with multiple tables. In this assignment, you will work with the factory and sales tables. 1. Create a new project nam

Explain hash file organization? Hash functions a) The distribution is uniform Hash functions assign each bucket the similar number of search -key values from the set of a

#question. Draw a picture of a moving source and the waves surrounding it according to what you observed in this experiment. How does the spacing of the wave-fronts in front of the