Create an entity-relationship diagram for the following situation: i want this diagram in this format, please check it
http://www. fairview-industries. com/standardmodule/cad-e-r. gif
Is it possible for you to draw in this format?
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
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, 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, 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 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.