Info Systems
Organisation
Storage & Retrieval
Displaying/Issues
100
What are the 3 database information systems the syllabus specifically refers to?
SCHOOL RTA VIDEO STORE
100
Name two non-computer methods of organising.
Telephone books Card based applications
100
What does DBMS stand for?
Database Management Systems
100
What is the purpose of a report?
To present information from a database in a user friendly format. Generally a report is based on a particular query.
200
What are the two main characteristics of an Information System?
Organise data into information Analyse the information to give knowledge
200
Name the three computer based methods of organising
Flat-file systems Database management systems (DBMS's) Hypermedia
200
Give an example of a device that uses sequential access
Magnetic Tape
200
When designing a form, what can be added to the form for data validation?
Radio buttons Drop down boxes Repeat things twice Notification
300
What are the 6 main components of an information system?
Purpose Information Processes Information Technology Participants Users Data/Information
300
True or False? An attribute is also known as a record.
FALSE
300
Describe 'Encryption'
The process of making data unreadable by those who do not possess the decryption key.
400
True or False? An information system can be used to help decision-making.
TRUE
400
What are the three types of relationships that a schema can have?
One to One One to Many Many to Many
400
What is missing? - SELECT -FROM -ORDER BY
WHERE
500
Define 'Foreign Key'
Fields that contain data that must match data from the primary key of another table.
500
What is the difference between data mining and data warehousing?
Data mining searches and analyses data that has been stored through data warehousing where raw data is stored in databases.
M
e
n
u