PRAYER
ATTENDANCE
New Class Schedule
Friday
1:00 – 7:00 PM
Database Groupings
LEVELS OF
DATA ORGANIZATION
DATA vs INFORMATION
What is Data?
◼ These are raw facts that are used as
basis for manipulation and computation
which are considered to be the input.
◼ Unorganized facts that need to be
processed.
◼ Raw data is basically has no meaning.
DATA vs INFORMATION
What is Information?
◼ These are processed data that are
considered to be the results or the output.
◼ When data is processed, organized,
structured or presented in a given context
so as to make it useful, it is called
Information.
Levels of
Data Organization
◼ Bit
◼ Byte
◼ Field
◼ Record
◼ File
◼ Database
Levels of Data
Organization
◼ Bit
➢ It is the smallest form of data.
➢ It consists of binary digits (0 and 1)
Levels of Data
Organization
◼ Byte (8 bits)
➢ It is the smallest unit of data.
➢ It is equal to one character (Ex. A-Z 0-9 and
any symbol).
➢ A character is the most basic element of data
that can be observed and manipulated.
Field - it is a group of characters taken
as one. It is a logical unit of data.
➢ Ex. Name, Address, Phone
Record - it is a group of related
fields pertaining to one entity.
Susan’s Record
Name Bday SS Street City St Zip Phone
Almond, 10/22/1 245-88- 31 Greensboro NC 25233 336-585-
Susan 985 9845 Bessemer 5646
St
◼ One record is displayed from the
Employee Table above. The table
contains 8 fields.
File - it is a group of related records
pertaining to subject. A file is sometimes
called a table.
➢ Ex. Student, Professor, Course, Schedule
Database
➢ It is a collection of related files
pertaining to one subject.
Examples of Business
Databases
◼Telephone book ◼ Customer data
◼Student data ◼ Real estate listings
◼Music ◼ Hospital/patient data
◼Fingerprint ◼ Inventory
database
◼Dictionaries
Levels of Data
Organization
Presidents File
Lastname Firstname Address Phone
Arroyo Gloria Malacañang 735-00-00
Estrada Joseph San Juan 721-01-01
RECORD Ramos Fidel Pangasinan 03-522-
4567
Aquino Corazon West 922-02-02
Triangle
Marcos Ferdinand Ilocos Norte 04-789-
(up to) (up to) (up to) 2356
Aquinaldo Emilio Kawit, Cavite 01-654-
3698
Levels of Data
Organization
DATA BASE
(Gov’t officials of the Philippines)
Vice-Presidents’ Mayors’ File Barangay
File Officials’ File
Senators’ File Vice Mayors’ File
Congressmens’ Etc. . . . . File
File
Levels of Data Organization
Byte
Field
Record
File
Database
Seatwork: Identify the level of
data (Open Notes).
1. LastName
2. 01111
3. Lady Gaga Nevada June 25, 1990
4. !
5. Inventory Database
6. Customer SalesRep Orders
Seatwork
6. 1010 0110
7. Migs Natividad Pasig City Oct. 11,
2014
8. Student Professor Course Schedule
9. Lady Gaga Nevada June 25, 1990
10. Telephone Book
Seatwork
11. Customer Data
12. Inventory
13. ?
14. Customer Representative Orders
15. *
