Google Answers Logo
View Question
Q: Database concepts ( Answered 4 out of 5 stars,   0 Comments )
Subject: Database concepts
Category: Computers
Asked by: fahd-ga
List Price: $3.00
Posted: 27 Jul 2002 18:45 PDT
Expires: 26 Aug 2002 18:45 PDT
Question ID: 45973
why is the relational data model is the most used model?
what is the difference between the structure of a database, the
relationships in the database, and the integrity of the database?
Subject: Re: Database concepts
Answered By: j_philipp-ga on 27 Jul 2002 19:19 PDT
Rated:4 out of 5 stars
Hello Fahd,

The relational data model is the most used because it is:
- mature (proven and known)
- simple to understand
- fast
- widely supported

The structure of a database is that its made up of tables consisting
of rows and columns.
For example:

First Name | Last Name | Age | Email
John       | Doe       | 31  |
Mary       | Smith     | 28  |

The relationship can be established by the programmer using a table
join (via SQL).
Take this second table:

Login      | SignedUpDate | Email
johndoe    | 2002-12-12   |

We could now join the two tables by "email", their common column.
The email could serve as a primary key here.
A primary key, which must be unique within individual tables, could
also be the combination of first name and last name. Since names are
not unique, we might want to use a safer, "synthetic" key, that might
be handled by the database using auto-incrementation:

ID | Login      | SignedUpDate | Email
1  | johndoe    | 2002-12-12   |
2  | marysmith  | 2002-11-11   |

On to the integrity: this is the referential integrity of the
database. It means that data is not redundant or error-prone in the
sense that e.g. if you delete customer data, also the previous
customer orders must be deleted. You can ensure this using foreign
keys and have the database server enforce integrity rules.

For a good overview of all this, please see:

Introduction to Relational Database Design

Data Modeling
- Introduction to Data Modeling
- Overview of the Relational Model

Hope that helps!

Search terms:
    "database design" relational
fahd-ga rated this answer:4 out of 5 stars
Thak you for your help.

There are no comments at this time.

Important Disclaimer: Answers and comments provided on Google Answers are general information, and are not intended to substitute for informed professional medical, psychiatric, psychological, tax, legal, investment, accounting, or other professional advice. Google does not endorse, and expressly disclaims liability for any product, manufacturer, distributor, service or service provider mentioned or any opinion expressed in answers or comments. Please read carefully the Google Answers Terms of Service.

If you feel that you have found inappropriate content, please let us know by emailing us at with the question ID listed above. Thank you.
Search Google Answers for
Google Answers  

Google Home - Answers FAQ - Terms of Service - Privacy Policy