Preview

04 - Database definitions (keys)

 1. A database is being created on Crime in a local area. Examples of _______ could be 'Crimes', 'Victims', 'Criminals' and 'Police Officers'

  tables

  files

  fields

  relationships

 2. What type of database might store tables like 'People', 'Relationships', 'Messages','Pictures'?

  None of the above

  A football league

  A local library

  Social Networking site

 3. An essential feature of a database is making each record unique. To make them unique we we use ______________

  foreign keys

  attributes

  primary keys

  composite key

 4. Referential integrity is the process of ensuring ____________ as it makes sure that information is not removed if it is required elsewhere in a linked database.

  consistency

  encryption

  speed

  uniqueness

 5. An item of data that can be used to index the whole data set (can't be primary key, eg sort by date)

  secondary key

  foreign key

  composite key

  three database views

 6. Internal, conceptual and end user

  three database views

  secondary key

  foreign key

  composite key

 7. Combines two fields to make a primary key

  three database views

  foreign key

  composite key

  secondary key

 8. The term attribute refers to a ___________ of a table.

  primary key

  column

  data type

  files

 9. Which of the following gives a logical structure of the database graphically?

  End diagram

  Entity relationship diagram

  Database diagram

  Flow chart

 10. If you were collecting and storing information about your music collection, an album would be considered a(n) _____.

  folder

  fields

  files

  entity


Report an error