Topic 1a : Structures and Links (Databases)

Question 1

A database is a

Answer 1

structured collection of information on people or things.

Question 2

Databases are made up of;

Answer 2

fields, records and files

Question 3

A field stores

Answer 3

one piece of data about a person or an object.E.G. telephone number

Question 4

A record stores

Answer 4

The data on one person or object in the file. E.G. Information on one pupil in a school

Question 5

A file is

Answer 5

A collection of Records

Question 6

A flat file database is a

Answer 6

database structure which has only one table containing all the fields and the data they hold

Question 7

A relational database

Answer 7

has more than one table.

Question 8

1 advantage of a relational database is

Answer 8

that is ensures data is only entered and stored once

Question 9

2nd advantage of a relational database is that it

Answer 9

removes the possibility of data duplication and inconsistency

Question 10

3rd advantage of relational database is

Answer 10

All tables containing the data are linked

Question 11

Person’s name or address is an example of what field type ?

Answer 11

Text

Question 12

Someone’s annual salary is an example of what field type?

Answer 12

Number

Question 13

Someone’s D.O.B. is an example of what field type?

Answer 13

Date

Question 14

An appointment time is an example of what field type?

Answer 14

Time

Question 15

An image of the pupil in school records is an example of what field type?

Answer 15

Graphics

Question 16

Monthly salary = annual salary/12 is an example of what field type

Answer 16

Calculated

Question 17

A field containing a link to files on your computer or a network or location on the internet is an example of what field type?

Answer 17

Link

Question 18

A field designed to store a value of 1 or 0, or with a yes/no option is an example of what field type?

Answer 18

Boolean

Question 19

A key field does what?

Answer 19

Uniquely identifies each record in the database e.g. Scottish Candidate Number

Question 20

A foreign key does what?

Answer 20

Sets up links between 2 tables in a database. It is a field that will appear in both table.

Question 21

Validation is when you

Answer 21

check to make sure the correct type of data is being entered into a field

Question 22

Field Length checks that

Answer 22

the correct number of either numbers or characters have been entered into a field.

Question 23

Range checks that the number entered in a field

Answer 23

falls between a minimum and maximum value.