Transcript Presentation and Multimedia

General Purpose Packages
DATABASES
Chapter 4
Computing
Standard Grade
General Purpose Packages
Database Structure
Marge Simpson
Field
File
Computing
Record
Foundation
Standard Grade
General Purpose Packages
Features of Databases Packages
Add / Create
/Edit records
Fields can be numeric,
text, graphic, date or time
types. (G)
Search on
one field
A simple search.
Sort on one
field
Computing
A simple sort.
Foundation
Standard Grade
General Purpose Packages
Features of Databases Packages
Alter a record
format (G)
Delete a field, change field to
hold different type of data.
Alter input
format (C)
For example, alter the input
layout from column to card.
Alter output
format (C)
For example, alter the screen
layout from column to card.
Computing
Standard Grade
General Purpose Packages
Features of Databases Packages
Simple search
CDROM /
Internet (F)
The search engine on the
CDROM or the Internet
carries out the search.
Search on
more than one
field (G)
A complex search.
Sort on more
than one field (G)
Computing
A complex sort.
Standard Grade
General Purpose Packages
Features of Databases Packages
A formula is inserted
using the data from
other fields.
Computed field
Keyword
Computing
Keywords are used to identify
records in a file. Each record is
given a unique keyword, stored
in a key field. Therefore word
searching is much simpler.
Credit
Standard Grade
General Purpose Packages
Features of Databases Packages
Complex
search CDROM /
Internet (G)
Computing
Two or more conditions
are in the search.
Standard Grade