Employee (EmployeeID*, SalesPerson, SalesOffice@(SalesOffice.SalesOfficeID))

SalesOffice (SalesOfficeID*, SalesOfficeLocation)

Customer (CustomerID*, CustomerName)

Employee_Customer (EmployeeID*@,CustomerID*@)

Get SalesOffice for Ford

SELECT SalesOfficeLocation
FROM SalesOffice
JOIN Employee ON Employee.SalesOffice = SalesOffice.SalesOfficeID
JOIN Employee_Customer ON Employee_Customer.EmployeeID = Employee.EmployeeID
JOIN Customer ON Customer.CustomerID = Employee_Customer.CustomerID
WHERE CustomerName = 'Ford'

SELECT SalesOfficeLocation
FROM Customer
JOIN Employee_Customer ON Employee_Customer.CustomerID = Customer.CustomerID
JOIN Employee ON Employee.EmployeeID = Employee_Customer.EmployeeID
JOIN SalesOffice ON SalesOffice.SalesOfficeID = Employee.SalesOffice
WHERE CustomerName = 'Ford'