Intro to Databases

Which of the following is a field in this database table?

• DistrictName

• 3

• Northend

• +

Which of the following is a record in this database table?

• DistrictName

• 1

• Northend

• 2, Crimbuston, 2

Which of the following indicates a relationship in this database table?

• DistrictID

• 1, Boroughside, 1

• +

Which of the following is the primary key in this database table?

• BeachID

• Beach Type

• Lifeguard

Which of the following is the foreign key in this database table?

• BeachID

• Beach Name

• DistrictID

Which of the following is using the Number data type?

• BeachName

• Beach Type

• Lifeguard

• DistrictID

Which of the following is using the AutoNumber data type?

• BeachID

• Beach Type

• Lifeguard

• DistrictID

Which of the following is using the Short Text data type?

• BeachID

• Beach Type

• Lifeguard

• DistrictID

Choose the most appropriate relationship for these tables:

Student Teacher

• Many-to-Many

• One-to-Many

• One-to-One

Choose the most appropriate relationship for these tables:

Student StudentID

• Many-to-Many

• One-to-Many

• One-to-One