Databases

What is a record?

• A row in a database
• A column in a database
• A raw figure
• A unique field

What is a field?

• A row in a database
• A column in a database
• A raw figure
• A unique field

What is a primary key?

• A row in a database
• A column in a database
• A raw figure
• A unique field

Which of these could be a primary key?

• Centre number
• Surname
• Teacher name
• Students addresses

What is a relationship?

• Two relational databases share a field
• When a database has two matching primary keys
• When two people have the same surname
• When two or more people have the same surname

Which of these is an advantage of the flat-field database?

• It is cheap
• It is flexible
• It only shows relevant information
• It is easier to find the information you want

What do relational databases tend to have in common?

• Primary keys
• Records
• Fields
• Indexes

Which of these is an advantage of relational databases?

• Only relevant data is displayed
• It is cheaper
• It is faster
• Data may be displayed multiple times so it is harder to miss

How many records are in this database?

• 8
• 5
• 10
• 12

What is the primary key in this database?

• Emp_Id
• Last Name
• Gender
• Title