Triple M Industries, Inc., is a company with a few hundred employees. A database is required to keep track of all the employees, their managers and projects assigned to employees. Each employee has a unique employee number assigned by the company. It is also required to store each employee's name, address, and date of birth. If an employee is currently married to another employee of Triple M Industries, the date of marriage and who is married to whom must be stored. However, no record of marriage is required if an employee's spouse is not an employee of Triple M Industries.

Other information of interest of the employees for our database are, the number of years with the organization, highest degree attained, the type of job/position of the worker e.g. engineer, assistant engineer, secretary etc. Note that each employee can only be assigned one position. However, several employees may share the same position. A manager can be assigned the position of an engineer. Your database should be able to show that an employee can both be a manager and an engineer.

The company has 11 different departments, each with a unique name. The database should keep information about the department affiliation of each employee. Each employee is affiliated to only one department. Each department has a phone and a fax number. Each department is managed by only one employee (manager), and a manager can only manage one department.

Employees are assigned to projects, and the database should keep information about current assignments to projects. Each project is identified by a unique project name, and we must store the estimated cost of each project. A project may have many workers assigned to it and a worker may be assigned to many projects. It is possible, however, that a worker is not assigned to any project at the current time. Also, each project is managed by one manager, although a manager may manage more than one project at a time. The projects described here are cross-functional, there-fore the manager of the project need not be the department manager of the workers.

The following answers can be hand drawn.

1. Draw an E-R diagram for the above situation. Your diagram should identify all the entities, relationships, and attributes described above. Indicate primary keys, and the cardinality of each relationship.
2. Create a relational database model to represent the model derived from Part a. For each relation, identify the primary key, and all of its attributes. Also, identify foreign keys of each relation, if appropriate.

(NEED B but if you can help with A as well it'll be awesome.)