Wednesday, October 01, 2008

SQL Material

DATA ARE RAW FACTS
EX : CUSTOMER NAME IN BANK
TOTAL MARKS OBTAINED BY STUDENT

INFORMATION: AN ORGANIZED DATA IS CALLED INFORMATION
EX : CUSTOMER NAME WITH BALANCES.
STUDENT REG NO WITH TOTAL MARKS.

DATA HIERARCHY:
BIT IT MAY BE EITHER 0 OR 1
IT REPRESENTS THE SMALLEST PART OF INFORMATION THAT COMPUTER CAN PROCESS.

BYTE : IT IS GROUP OF 8 BITS IT REPRESENTS A DIGIT, LETTERS OR SPECIAL SYMBOL.
FILED: IT IS A GROUP OF CHARACTERS.

EMPNO ENAME SAL JOB
100 SMITH 800 CLERK

RECORD: IT IS

No comments: