BZU PAGES: Find Presentations, Reports, Student's Assignments and Daily Discussion; Bahauddin Zakariya University Multan - 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;

Code:

select *

from student

order by subjects;

It shows that order of tuples does not matter in the data base tables.:book1: