You are building a database for your company's Human Resources department.
Each employee is identified by an ID number, and you want to store each
employee's first name, last name, salary, gender, and performance rating.
You also want to keep track of each employee's location and job title.
Each employee is assigned to a single location and has a single job
title. For each location, you want
to store a name, address, state, zip code, and phone number.
For each job title, you want to store a name, description, education
requirement, minimum required salary, and maximum allowable salary.
Assume that you do not want to include a separate zip-code table in the
Every employee except the CEO has one supervisor (the CEO does not have a
supervisor). The database should be
able to answer queries like "Who is the supervisor of employee X?",
"What are the first and last names of employees who directly supervise at
least 4 other employees?", or "Who are all the employees supervised by
somebody whose supervisor is employee Z?"
Write a database design outline and entity-relationship diagram for the database.