Y12 Databases

Which of the following is a category of object, person, event or a thing of interest to an organisation?

• Flat File
• Entity
• Attribute
• Primary key

What is used to present the relationship between entities in a database?

• ER Diagram
• Referential integrity
• Primary Key
• Foreign Key

Which type of key is a unique identifier?

• Primary Key
• Foreign Key
• Secondary Key

Which best describes a characteristic about an entity 

• Primary Key
• Secondary Key
• Attribute
• Record

Which type of relationship best describes the following?

Head teacher who runs a School

• One to one
• Many to many
• One to many

Look at the following, outline which is the primary 
Student (Name, StudentID, Address, Postcode)

• Name
• StudentID
• Address
• Postcode

Which of these is a one to many relationship?

• Customer and order
• Mum and children
• Printer model and cartridge 
• All of the above

Film title is a suitable Primary key, true or false?

• True
• False

Flat file database is a database where tables are linked, true or false?

• True
• False

Film title is a suitable secondary key, True or False?

• True
• False