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 object identity? An object retains its identity even if some or all the values of variables or explanations of methods change overtime.

Use the IRIS dataset that comes with Weka to compare the classification performance of the following algorithms. 1. NaiveBayesSimple 2. MultiLayerPerceptron J48 (

List the internal controls that should be in effect solely because a EDP system is employed, classifing them as (1) Those controls pertaining to input of information and (2) All ot

Serialisable Schedules: If the processes of two transactions conflict with each other, how to verify that no concurrency related problems have happened? For this, serialisability t

1. Will you advise that your organization uses open source software and why? 2. Why is it important for business managers to have a basic understanding of the software development

Indexed (Indexed Sequential) File Organisation It organises the file like a big dictionary, i.e., records are kept in order of the key but an index is stored which also allows

What are the comparison operator in SQL?  Comparison operator in SQL are =, LIKE and BETWEEN

Write a short note on QBE? Stands for "Query By Example." QBE is a feature involved along with various database applications which gives user-friendly techniques of running da

Query Processor The query language processor is responsible for taking query language statements or shifting them from the English-like syntax of the query language to a form

Having clause This clause is used for producing conditions on grouped information. Example: Find maximum salary and department number of those departments where maxim