Ch.9 Databases

Question 1

database

Answer 1

an example of application software to store and manipulate data

Question 2

table

Answer 2

a set of data about one type of object e.g. students

Question 3

field

Answer 3

an individual piece of data e.g. date of birth

Question 4

record

Answer 4

all of the records in a table about one object
e.g. all the personal details about one student

Question 5

data type

Answer 5

the characteristics of a piece of data
common data types: string, integer, real, boolean

Question 6

boolean

Answer 6

a data type (true or false)

Question 7

integer

Answer 7

a data type (whole numbers)

Question 8

real

Answer 8

a data type (decimal numbers)

Question 9

primary key

Answer 9

a unique identifier for a record

Question 10

structured query language (SQL)

Answer 10

a standard language used to define and manipulate databases

Question 11

script

Answer 11

a set of statements that are executed

Question 12

logical operator

Answer 12

a symbol that performs a comparison resulting in true or false
e.g. =, ≠, <, >,

Question 13

boolean operator

Answer 13

a symbol that joins multiple logical comparisons
e.g. AND, OR, NOT