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
Problem 1 What is a Data Warehouse? Mention its advantages 2 Explain the Top-Down and Bottom-up Data Warehouse development Methodologies 3 What is Data Transformation? Ex

What are the Objectives of Advance object design After this unit, you shall be able to: combine three OOAD models to obtain operations on the classes; develop algo

For each m:n relationship type R, we make a new table (say S) to represent R. We also contain the primary key attributes of both the participating entity types as a foreign key att

What is the difference between internal tables and extract datasets? The lines of an internal table always have the similar structure. By using extract datasets, you can ha

Illustrate the statement 'Projection operation distributes over the union operation'. Give an example.    Ans: Π L (E 1 ∪ E 2 ) = (Π L (E 1 )) ∪ (Π L (E 2 ))   This says th

Let us now talk about the relational operations: SELECT The select operation is used to select few specific record from the database based on different criteria, This is a un

Explain group By clause in SQL? Group By clause in SQL: The GROUP BY clause can be used in a SELECT statement to collect data across multiple records and group the results thro

Data Scrubbing 70,000 records Project Description: We need services of a developer competent in data cleansing/Data scrubbing. Scope: - 70,000 records in CSV format.

Which database object does not physically exist? A view database object does not physically exist.

i am required to come up with entities relationships, optionality and cardinality from a scenario. there is a night club and bookings for a musician band