Reference no: EM131660276

Draw E-R Diagram

Terps Success, Inc., is a consultant firm with approximately 300 employees. A database is required to keep track of all employees, their skills, projects assigned, and departments worked in. Every employee has a unique identifier assigned by the firm and is required to store her or his full name (in two fields - first name and last name) and date of birth. If an employee is currently married to another employee of Terps Success, Inc., 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 also an employee. There are 11 different departments, each with a unique identifier and name. Each department has a phone number. An employee reports to exactly one department. Many employees can work on a project. An employee can work on many projects (e.g., Capital Refinery, Metro Transportation, and so on) but can only be assigned to at most one project in a given city. A city is identified by a unique identifier. For each city, we are interested in its name, the state it locates and its population. Projects are distinguished by unique project identifiers. We must store the estimated cost of each project. An employee can have many skills (preparing project management, auditing, and so on), but she or he may use only a given set of skills on a particular project. Employees use each skill that they possess in at least one project. Each skill is assigned an identifier, and we must store a short description of each skill. (For example, an employee Murphy Diamonds may prepare requisitions for the Capital Refinery project and prepare requisitions as well as auditing for Metro Transportation.)