12-03-2009, 03:08 AM
|
 | | | Join Date: Sep 2007 Location: near Govt College of Science Multan Pakistan
Posts: 9,693
Contact Number: Removed Program / Discipline: BSIT Class Roll Number: 07-15 | |
 Table Relations: and 6 properties of Relational Data Base Systems
Table Relations: and 6 properties of Relational Data Base Systems
In data base table is called relation. - Each cell of a table contain only single value.
- Each column has distinct name.
- The values is the column comes from the same domain.
- The order of column is immaterial. Its means we can create columns without having any orders.
- Each tuples or rows are distinct.
- The order of row or tuple is immaterial
Code: select *
from student
order by name; OR Code: select *
from student
order by subjects; It shows that order of tuples does not matter in the data base tables.  |