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'

  files

  tables

  fields

  relationships

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

  A local library

  None of the above

  A football league

  Social Networking site

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

  composite key

  attributes

  foreign keys

  primary keys

 4. Ensures tables are linked with foreign key where one attribute is a primary key and they are of the same data type

  referential integrity

  cons of many to many

  foreign key

  attribute (field)

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

  three database views

  composite key

  secondary key

  foreign key

 6. Internal, conceptual and end user

  foreign key

  three database views

  secondary key

  composite key

 7. Combines two fields to make a primary key

  composite key

  foreign key

  secondary key

  three database views

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

  data type

  files

  attribute (field)

  primary key

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

  Database diagram

  Flow chart

  Entity relationship diagram

  End diagram

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

  folder

  fields

  files

  entity