database design and development

Question 1

database

Answer 1

organised collection of records holding data so it can be stored and accessed

Question 2

record

Answer 2

data held on one person or thing

Question 3

feild

Answer 3

one item of data on record

Question 4

general data protection regulations

Answer 4

give people more control of how organisations use their data
introduce penalties for organisations who fail to comply with rules

Question 5

primary key

Answer 5

used to uniquely identify each record in table

Question 6

foreign key

Answer 6

contains values that correspond to values in primary key of another table

Question 7

referential integrity

Answer 7

relationship between tables must be consistent

Question 8

4 types of data validation

Answer 8

restricted choice
presence check
field length
range check

Question 9

restricted choice

Answer 9

limits what user can enter by restricting their choice to a list of acceptable values

Question 10

presence check

Answer 10

used to stop important data being missed out and won’t allow blank fields

Question 11

field length

Answer 11

forces entered data to be a specific no of characters

Question 12

range check

Answer 12

forces entered data to lie in a certain range of values

Question 13

data dictionary

Answer 13

used to illustrate the design of the tables in the database
- identifies primary and foreign key
- specifies names, data types of fields and validation