This Question Is Answered:
 Can you describe the properties of relations?
 25 Jun 2007 17:43
 Flag
 A relation has several properties that make a relation different from a table. Some of these properties are discussed below:

1. There is no duplication of tuples in a relation:
A relation is a mathematical set (of tuples), and sets in mathematics by definition do not include duplicate elements. So a relation cannot contain any duplicate tuples. It means that two (or more) identical rows (or records) cannot exist in a relation. Each row in a relation must be unique. For example, in a student relation, there cannot two records (rows) for the same student. Uniqueness in a relation is guaranteed by assigning the primary key for each relation.

2. All attribute values of relation are atomic:
According to this property of relation, each cell of a relation (table) contains only one value (never a collection of several values). You can say that each value in a tuple is an atomic value which cannot be divisible into components. The composite and multi-valued attributes (or repeating groups) are not allowed. Multi-valued attributes must be represented by separate relations. A relation satisfying this condition is said to be normalized (or equivalent to first normal form). For example, in a student relation, you must have to write a single telephone number of a student (More than one telephone numbers separated by commas is not allowed). Similarly, there should be three attributes for student name such as First-Name, Middle-Name, and Last-Name.

3. All attribute values of a relation must come from the same domain:
The values for attributes must be within the acceptable range. For example, in a student relation all entries in "Marks" attribute must be from the domain that defme's student marks (such as between 0 and 200).
Unrated

0 ratings
by   azi
  25 Jun 2007 18:52
 Flag

1000 words left

    


Blurtit Tools:  Email to a Friend    Bookmark this page
How Do I Make My Own
Screen Name On Windows
Internet?
'Irql_not_less_or_equal'!
What Is This?
How Do I Get Free
Software And A Driver For
My Hp Psc 1210v Printer?
Do You Know The Role Of
Information In Crime
Detection?
What are protocols?
Is the Nero DVD-Video
Plug-in a piece of
software?
How much does it cost the
Microsoft POS software?
What Is A Good
Motherboard For A Intel
Core 2 Due Processor That
Will Work With DDR2-667
What do you know about
Prototyping?
What is a divx player?
My Blurtit
My Profile
My Questions
My Answers
Blurtit Features
Ask a Question
Answer a Question
Search an Answer
Categories
Tools
Link to Blurtit
Add Blurtit to Firefox
Search Engine
See Your Site Here
Link to Blurtit
RSS
Blurtit.com
About Us
Terms & Conditions
Privacy Policy
Contact Us
Advertise With Us
Help
International
 Chinese Site
 Japanese Site
To continue you need to be registered with us first.

I am already a Blurter, and need to login
I am not a Blurter yet, but would like to register