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:

PERSON_ID

NAME

AGE

ADDRESS

1

Sanjay Prasad

35

b-4,Modi Nagar

2

Sharad Gupta

30

Pocket 2, Mayur

Vihar.

3

Vibhu Datt

36

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
What is recursive closure? Why is it not possible to describe this operation in relational algebra? Recursive closure is applied to recursive relationship. An instance of rec


What are the reasons of bucket overflow? Explain any two methods for solving this problem. Ans:  It is general for file structures to be divided into equal-length partitions, k

Define rotational latency time. The time spent waiting for the sector to be accessed to appear under the head is known as the rotational latency time.

System error :These contain errors in database system or the OS, example, deadlocks.Such errors are fairly hard to detect and need reprogramming the erroneous components of the sys

Explain the term - Handling Boundary Condition These are some circumstances that to be handled in any system initialization and termination. Describes how system is bro

i need help for assignment ..

Explain Derived and Non-Derived Attribute? In few cases, two or more attribute values are related, for instance, Age and BirthDate attributes of a person. For specific person e

What is vertical fragmentation? Vertical fragmentation divides the relation by decomposing the scheme R of relation r.

FitAll Ltd is a company that manufactures clothes. Its processes are manual and there are stand-alone Information Systems that aid to manage them. The Information Systems were purc