#Assignment 2 I have 4 entities: Location, Company, Department, and Employee. Location holds streetAddress, state, city , and the postalcode. Company holds the company name. Department holds the department name such as IT. Employee holds the employee's name, salary, email, and phone number.

I have 3 relationships. Two of them are One to many and one of them is One to One. For the One to One relationship it is between the Location and the Company. Every Location can have only one company.

For one of the One to Many relationship it is between Company and Department. Every Company can have many different Departments such as IT, Sales, etc.

The other One to Many relationship is between Department and Employee. Every Department can have many different employees.