Triple M Industries, Inc., is a company with a few hundred employees. A database is required tokeep 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 tostore each employee's name, address, and date of birth. If an employee is currently married toanother employee of Triple M Industries, the date of marriage and who is married to whom mustbe stored. However, no record of marriage is required if an employee's spouse is not an employeeof Triple M Industries. Other information of interest of the employees for our database are, the number of years with theorganization, highest degree attained, the type of job/position of the worker e. g. engineer, assistantengineer, 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 anengineer. Your database should be able to show that an employee can both be a manager and anengineer. The company has 11 different departments, each with a unique name. The database should keepinformation about the department affiliation of each employee. Each employee is affiliated to onlyone department. Each department has a phone and a fax number. Each department is managedby 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 assignmentsto projects. Each project is identified by a unique project name, and we must store theestimated cost of each project. A project may have many workers assigned to it and a worker maybe assigned to many projects. It is possible, however, that a worker is not assigned to any projectat the current time. Also, each project is managed by one manager, although a manager maymanage more than one project at a time. The projects described here are cross-functional, thereforethe 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 allthe 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, identifyforeign keys of each relation, if appropriate.