Information systems like databases are used to store and present information, making it easier to visually interpret and understand, faster to search, update and check for errors.
What is the definiton of a record in a database?
A record stores all the information on one object or person
A record stores all the information for a particular subject
A record stores one individual piece of information for a particular subject
What is a calculated field?
A special field in a database which uses a formula to automatically input data
A field in a database which can either be letters, numbers or a combination of these
A field in a database which is capable of storing an image of a person
Identify the field types used in this example:
Item name: number, Quantity remaining: text, Ordered on: date
Item name: text, Quantity remaining: number, Ordered on: date
Item name: text, Quantity remaining: number, Ordered on: time
What is a website?
A collection of instructions that you would download from an App Market place on a mobile phone or tablet
A collection of web pages which are used to present information, eg Facebook, YouTube etc
A piece of software which can be used to create software and animations
What are the advantages of an electronic database over a paper based option?
It is not possible to create copies of a database
It is very difficult to update information on a database
It is much faster and easier to find information
A database can be sorted using which two orders?
Ascending, which puts data from smallest to largest and searching, which puts data from largest to smallest
Descending, which puts data from smallest to largest and ascending, which puts data from largest to smallest
Ascending, which puts data from smallest to largest and descending, which puts data from largest to smallest
This data is sorted on which field and in which order?
It has been sorted on the ID Number field in ascending order
It has been sorted on the ID Number field in descending order
It has been sorted on the Forename field in descending order
What does a search in a database do?
Order all of the records into a specific order which you choose
Allows you to look for data in a field matching your criteria
Create a new record and insert new information
A new pupil joins a school. In order to store information on this person, what must the school do?
Create a new data file
Add a new field to their data file
Add a new record to the school’s data file
What is a hyperlink?
A hyperlink is a type of field in a database that automatically carries out a calculation on other fields in the database
A hyperlink is the correct name for the address of a website
A hyperlink is an active part of a webpage that, when clicked, will take you to another webpage or website