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

Register FAQ Community Calendar New Posts Navbar Right Corner
HOME BZU Mail Box Online Games Radio and TV Cricket All Albums
Go Back   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

Introduction to Database By Sir Yousaf


Reply
 
Thread Tools Search this Thread Rate Thread Display Modes
  #1  
Old 12-03-2009, 03:08 AM
.BZU.'s Avatar


 
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
.BZU. has a reputation beyond repute.BZU. has a reputation beyond repute.BZU. has a reputation beyond repute.BZU. has a reputation beyond repute.BZU. has a reputation beyond repute.BZU. has a reputation beyond repute.BZU. has a reputation beyond repute.BZU. has a reputation beyond repute.BZU. has a reputation beyond repute.BZU. has a reputation beyond repute.BZU. has a reputation beyond repute
Read 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.

__________________
(¯`v´¯)
`*.¸.*`

¸.*´¸.*´¨) ¸.*´¨)
(¸.*´ (¸.
Bzu Forum

Don't cry because it's over, smile because it happened
Reply With Quote
Reply

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


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

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


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 04:01 PM.
Powered by vBulletin® Version 3.8.2
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.