For each direction, write directions, write directly onto the ERD above. You will draw in relationships and add PKs or FKs as needed.

Each employee in the EMPLOYEE table has a unique email. While most employee are assigned to one and only one office building, some are not and work from home.

Space numbers for parking spaces are unique within the spaces assigned to a building.

Each Building has a unique name

Every employee is assigned single parking space whether they use it or not. Parking spaces are connected to individual office buildings. No parking spaces is associated with more than one building.

Show the relationship, if any, of EMPLOYEES to PARKING SPACE

Show the relationship, if any, of PARKING SPACE to OFFICE BUILDING

Show the relationship, if any, of EMPLOYEES to OFFICE BUILDING

Indicate the PKs of each table

Indicate the FKs of each table

Employee Office Building Email Name First Name Address Last Name City Job Title State Manager ZiP Phone Front Desk parking space Space Number Compact Covered Nume Parking Office Building