Use the following Northwind database diagram to complete your SQL queries. We will go

over the structure in class.

For each table, there is a primary key indicated by PK$.$ Foreign keys are indicated by FK

One to many relationships are indicated by: $-|------<$

One to one relationships are indicated by: $-|-----|-$

Recall from lecture that many to many relationships are implemented through an

intermediary table that has a concatenated primary key $($ie$.$ More than one attribute forms

the primary key$).$ An example from the diagram is the following:

Employees has a many to many relationship with Territories, ie$.$ One employee can work

in many Territories and each Territory can have many employees working in it$.$ This is

implemented through the table EmployeeTerritories where:

EmployeeID and TerritoryID together are the primary key for the table

EmployeeID by itself is a foreign key back to Employees

TerritoryID by itself is a foreign key back to Territories