Your hand drawn $($pencil$/$paper$)$ ORGINAL CHEN METHODOLOGY $($Ovals for attributes,

Diamonds for relationships$).$ Take a picture of your drawing $($ER Data Model$)$ and post it to Canvas in the

Assignment #$1$ section.

Projects, Inc., is an engineering firm with approximately $500$ employees. A database is required to keep

track of all employees, their skills, projects assigned, and departments worked in$.$ Every employee has a

unique number assigned by the firm and is required to store his or her name and date of birth. If an

employee is currently married to another employee of Projects, 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. Each employee is also given a job title $($e$.$g$.,$ engineer, secretary$,$ and so on$).$ An

employee does only one type of job at any given time, and we only need to retain information for an

employee$$s current job.

There are $11$ different departments, each with a unique name. An employee can report to only $1$

department. Each department has a phone number.

To procure various kinds of equipment, each department deals with many vendors. A vendor typically

supplies equipment to many departments. We are required to store the name and address of each

vendor and the date of the last meeting between a department and a vendor.

Many employees can work on a project. An employee can work on many projects $($e$.$g$.$ Southwest

Refinery, California Petrochemicals, and so on$)$ but can only be assigned to at most one project in a given

city. For each city, we are interested in its state and population. An employee can have many skills

$($preparing material requisitions, checking drawings, and so on$),$ but she or he may use only a given set

of skills on a particular project. $($For example, an employee MURPHY may prepare requisitions for the

Southwest Refinery project and prepare requisitions as well as check drawings for California

Petrochemicals.$)$ Employees use each skill that they possess in at least one project. Each skill is assigned

a number, and we must store a short description of each skill. Projects are distinguished by project

numbers, and we must store the estimated cost of each project.