unit 3: simple database tables

Question 1

database

Answer 1

an organised collection of data

Question 2

field

Answer 2

a single item of data

Question 3

record

Answer 3

a collection of related fields

Question 4

database query

Answer 4

a code that is sent to a database to collect certain info

Question 5

text / alphanumeric

Answer 5

a no. of characters (short/long text)

Question 6

boolean

Answer 6

yes/no

Question 7

numeric

Answer 7

integer: a whole number
real: decimal

Question 8

char

Answer 8

a single character

Question 9

date/ time

Answer 9

date/time

Question 10

flat file database

Answer 10

only a single table of data
*not related to any other table

Question 11

flat file database disadvantages

Answer 11

*data duplication
*data redundancy
(same data in multiple locations)
*input errors

Question 12

relational database

Answer 12

two or more tables linked together

Question 13

verification

Answer 13

the process of checking the data in a database matches the data as it was originally captured

Question 14

validation

Answer 14

a set of automatic checks to ensure the data is sensible, reasonable, and complete

Question 15

presence check

Answer 15

makes sure if data is entered in a field

Question 16

length check

Answer 16

checks num. of characters entered

Question 17

range check

Answer 17

check value entered is between a pre-determined range

Question 18

type check

Answer 18

makes sure data is of correct type

Question 19

check digit

Answer 19

computer applies rules to see if no. entered is valid

Question 20

format check

Answer 20

makes sure data is of correct format

Question 21

lookup check

Answer 21

compares entered data w/ pre stored data

Question 22

1st verification check: double entry

Answer 22

data is entered twice by two different people

Question 23

2nd verification check: visual check

Answer 23

person entering data carefully compares

Question 24

foreign key

Answer 24

a field in one table that is linked to primary key in another