11 CSC ATAR - SQL!

One record in a table is associated with one and only one record in another table.

What type of relationship is this?

• One-to-one

• One-to-many

• Many-to-many

In a school database, each student has only one student ID, and each student ID is assigned to only one person.

What type of relationship is this?

• One-to-one

• One-to-many

• Many-to-many

One record in a table can be associated with one or more records in another table.

What type of relationship is this?

• One-to-one

• One-to-many

• Many-to-many

In a business database, each customer can have many sales orders.

What type of relationship is this?

• One-to-one

• One-to-many

• Many-to-many

Multiple records in a table are associated with multiple records in another table.

What type of relationship is this?

• One-to-one

• One-to-many

• Many-to-many

In a business database, customers can purchase various products, and products can be purchased by multiple customers.

What type of relationship is this?

• One-to-one

• One-to-many

• Many-to-many

What type of relationship is this?

• One-to-one

• One-to-many

• Many-to-many

What type of relationship is this?

• One-to-one

• One-to-many

• Many-to-many

What type of relationship is this?

• One-to-one

• One-to-many

• Many-to-many

A single column/field in a table that uniquely identifies each record in a database table.

• Primary key

• Foreign key

• Composite key