Database Relationships Quiz

What is a one-to-one relationship in a database?

• One record in a table relates to exactly one record in another table

• All records in one table relate to all records in another table

• Many records in a table relate to many records in another table

• One record in a table relates to many records in another table

Which of the following is an example of a one-to-one relationship?

• A library and its books

• A student and their school ID card

• A customer and their orders

• A teacher and their students

In a one-to-many relationship, one record in Table A can:

• Be linked to many records in Table B

• Be linked to only one record in Table B

• Be linked to all records in Table B

• Never link to records in Table B

Which of these is an example of a one-to-many relationship?

• A mother and her children

• A person and their passport

• A country and its capital city

• A marriage between two people

What does a many-to-many relationship require to be implemented in a relational database?

• A primary key in only one table

• A linking (junction) table

• No foreign keys

• A single table with all data

Example of a many-to-many relationship:

• A student and their birthdate

• A company and its CEO

• A library and its opening hours

• Students and the courses they take

In a one-to-one relationship, the foreign key is usually placed in:

• The table where the data is optional

• No foreign keys are needed

• Both tables

• Only in the larger table

In a one-to-many relationship between Teachers and Students, where is the foreign key stored?

• No foreign key is needed

• In the Students table

• In both tables

• In the Teachers table

Which relationship type best describes this situation: “One employee is assigned one company laptop, and one laptop belongs to only one employee”?

• No relationship

• Many-to-many

• One-to-one

• One-to-many

If one book can have many authors and one author can write many books, what type of relationship is this?

• None

• One-to-one

• Many-to-many

• One-to-many