Unit 2 - Relationships

You would use a ? to link multiple tables in a database together

(a)  

Select all examples of relationship types within a database

• One-to-One

• One-to-Many

• Many-to-Many

• One-to-All

Select the appropriate relationship type

Form Tutor and Students

• One-to-Many

• One-to-One

• Many-to-Many

Select the appropriate relationship type

College ID and College Student

• One-to-Many

• One-to-One

• Many-to-Many

Select the appropriate relationship type

Gym Member and Gym Class

• One-to-Many

• One-to-One

• Many-to-Many

Select all examples of keys within a database

• Primary

• Foreign

• Secondary

• Related

A ? key is used to uniquely identify each record within a database table

(a)  

A ? key is used to uniquely identify each record that originated from another table

(a)  

Uniquely identifies each record within a database table

• Primary Key

• Foreign Key

Uniquely identifies each record that originated from another table

• Primary Key

• Foreign Key