Answer Happy

a) You have been asked to design an Employee Tracking Database for CITS UIU. CITS wants to track information about employees, the employees job history, and their certifications. Employee information includes employee id, first name, last name, NID, address, city, state, zip, home phone and email address. An employee will have two addresses, current and permanent. Job history would include job title, job description, pay grade, salary, joining date, and total service year. For certifications, they want certification name, type, complexity level, and date achieved. An employee can have multiple designation at the same time, (i.e., Professor, Director). Now draw an ER diagram for this application. Be sure to mark the multiplicity of each relationship of the diagram. Decide key attributes and identify them on the diagram. Please state clearly if you make any assumption in your answer. b) Compare and contrast different types of attributes used in Entity Relationship Diagram.