database design and development

Question 1

relational database

Answer 1

A database containing several tables, linked using primary and foreign keys

Question 2

primary key?

Answer 2

A field in a table that contains values used to uniquely identify each record in the table

Question 3

foreign key?

Answer 3

A unique primary key in one table that is used as link to a field in another table

Question 4

definition of a ‘flat file database’?

Answer 4

A flat file database holds all data on only one table.

Question 5

problems with flat file databases?

Answer 5

the one table often leads to the presence of insert, update and deletion anomalies.

Question 6

The ‘text’ field type can be used to store what

Answer 6

Any combination of characters including punctuation marks, letters, symbols and numbers

Question 7

The ‘Boolean’ field type can be used to store which of the following?

Answer 7

True/False
yes/no

Question 8

The ‘number’ field type can be used to store which of the following?

Answer 8

Any numeric value

Question 9

Altering the format to display data using the 24-hour clock would apply to which of the following field types?

Answer 9

Time

Question 10

what is an insert anomaly?

Answer 10

When a table only permits new data in all fields

Question 11

delete anomaly?

Answer 11

When a table only permits deleting data across a whole field

Question 12

what are all the possible field types

Answer 12

text, number, date, boolean, time