Transcript Blockbuster 1

WHAT D IS RAW, UNPROCESSED
FACTS AND FIGURES COLLECTED,
STORED AND PROCESSED BY
COMPUTERS.
DATA
WHAT I IS PROCESSED DATA
WITH STRUCTURE OR MEANING
AND IS USEFUL TO HUMANS
INFORMATION
WHAT L IS A DATA TYPE THAT
IS A REFERENCE TO A FILE
LOCATED OUTSIDE THE
DATABASE.
LINK
WHAT E REPRESENTS A
PERSON OR OBJECT
ENTITY
WHAT PK IS THE FIELD
THAT UNIQUELY
IDENTIFIES ONE RECORD
FROM ALL OTHER
RECORDS IN A DATABASE
PRIMARY KEY
WHAT FK IS A FIELD WHICH
IS A PRIMARY KEY IN
ANOTHER TABLE
FOREIGN KEY
WHAT B IS A DATA TYPE IN
A FIELD WHICH ONLY HAS
TWO STATES EITHER
YES/NO OR TRUE/FALSE
BOOLEAN
WHAT RC IS A VALIDATION
CHECK THAT CAN BE
PERFORMED ON DATA
WHERE YOU ARE ASKED
TO CHOOSE FROM A LIST
RESTRICTED CHOICE
WHAT I IS A DATA TYPE
WHICH IS A WHOLE
NUMBER
INTEGER
WHAT RC IS A VALIDATION
CHECK THAT CAN BE
PERFORMED ON DATA
USUALLY BETWEEN TWO
LIMITS EG 1-100
RANGE CHECK
WHAT R IS A DATA TYPE
WHICH GIVES YOU A
FLOATING POINT NUMBER
e.g. 13, 3.14.
REAL
WHAT V IS TO MAKE SURE
THE DATE IS CORRECT
VERIFIY
WHAT H IS A TYPE OF
FILING SYSTEM THAT
LOOKS SIMILAR TO THE
DIAGRAM BELOW
HIERARCHICAL
WHAT M IS A TYPE OF
DATABASE THAT CONTAINS
TEXT, SOUND, VIDEO,
ANIMATION AND GRAPHICS
MULTIMEDIA
WHAT H IS AN OFFENCE
UNDER THE COMPUTER
MISUSE ACT
HACKING
WHAT DD IS OFTEN USED TO
RECORD INFORMATION ABOUT
TABLES AND FIELDS. THIS
ALLOWS THE DATABASE TO BE
IMPLEMENTED USING ANY
DATABASE MANAGEMENT
SYSTEM
DATA DICTIONARY
WHAT S ALLOWS YOU TO
PUT DATA INTO A
PARTICULAR ORDER
EITHER ASCENDING OR
DESCENDING
SORT
WHAT S ALLOWS YOU TO
FIND CERTAIN RECORDS IN
A DATABASE BY
SELECTING THE CRITERIA
TO LOOK FOR
SEARCH
WHAT CMA IS A LAW WHICH
ALLOWS COMPUTER
CRIMINALS LIKE THE
CREATORS OF VIRUSES TO
BE PROSECUTED
COMPUTER MISUSE ACT
WHAT C IS A FIELD IN A
DATABASE THAT CAN
PERFORM CALCULATIONS
BASED ON OTHER FIELDS
COMPUTED OR
CALCULATED FIELD