The following constraints are available:
The company has a set of departments
Each department has a set of employees, a set of projects, and a set of offices
Each employee has a job history (set of jobs the employee has held). For each such job, the employee also has a salary history (salary received for each job)
Each office has a set of phones
The database is to contain the following information:
For each department: department number (unique), budget and the dept. manager’s employee number (unique)
For each employee: employee number (unique), current project number, office number, and phone number; title of each job the employee has held, hire date and salary for each job
For each project: project number (unique) and budget
For each office: office number (unique), floor area, and phone numbers (unique) for all phones in that office

Represent your answer in DBDL. (i.e. Give table name and fields. Underline the primary key. Draw an entity-relationship diagram showing all relationships. Tables must be in 3NF).

Identify any assumptions you made that will assist in my understanding of your solution. (Must be included)



edit by admin: no contact information permitted on the forum, thank you.