Table Relations: and 6 properties of Relational Data Base Systems - BZU PAGES: Find Presentations, Reports, Student's Assignments and Daily Discussion; Bahauddin Zakariya University Multan

BZU PAGES: Find Presentations, Reports, Student's Assignments and Daily Discussion; Bahauddin Zakariya University Multan

HOME

Cricket

		BZU PAGES: Find Presentations, Reports, Student's Assignments and Daily Discussion; Bahauddin Zakariya University Multan > Institute of Computing > Bachelor of Science in Information Technology > BsIT 4th Semester > Introduction to Database
Table Relations: and 6 properties of Relational Data Base Systems

Introduction to Database By Sir Yousaf

12-03-2009, 03:08 AM

.BZU.

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

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.

__________________

(¯`v´¯)
`*.¸.*`
¸.*´¸.*´¨) ¸.*´¨)
(¸.*´ (¸.Bzu Forum

Don't cry because it's over, smile because it happened

Tags

base, data, properties, relational, relations, systems, table

« Previous Thread | Next Thread »

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode	Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Chapter 4 Relational Algebra and Relational Calculus Transparencies Book Database systems by Conolly-Carolyn E. Begg, Thomas	.BZU.	Introduction to Database	0	13-06-2011 12:10 PM
Quiz Oracle Data base queries 25 March 2009	.BZU.	Introduction to Database	0	26-03-2009 11:44 PM
Some Commands while we are retrieving the data from the data base (Condition for WHERE/SELECT/FROM etc) ORACLE Queries	.BZU.	Introduction to Database	0	12-03-2009 03:32 AM
Lecture1: Introduction to Data Base and Relational Data Base Management System	.BZU.	Introduction to Database	0	17-01-2009 12:33 AM
Dynamic Programming with PHP. Cookies and Data Base Lecture9	.BZU.	E Commerce	0	05-12-2008 08:45 PM

Best view in Firefox
Almuslimeen.info | BZU Multan | Dedicated server hosting
Note: All trademarks and copyrights held by respective owners. We will take action against any copyright violation if it is proved to us.

All times are GMT +5. The time now is 07:38 PM.