Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Draw an ERD for Wolf INC. Wolf INC is an IT firm with approximately 400 employees. Wolf INC needs a database to keep track of

Draw an ERD for Wolf INC. Wolf INC is an IT firm with approximately 400 employees. Wolf INC needs a database to keep track of employees, projects assigned, departments, and employee skills. Employees have a unique employee number, a name, address, and date of birth. If the employee is married to another employee at the company the date of marriage is collected. Each employee is given a job title (e.g., software engineer, SQL programmer, and so on). An employee does only one type of job at any given time, but the employee can have several previous job titles. We need to retain information for an employees current job but also maintain information about previous titles. Each job title is assigned a number, and a short description.

There are nine departments, each with a unique ID and name. An employee can report to only one department and a department has many employees. A department could possibly not have any employees. Each department has a phone number and location.

To acquire various kinds of supplies, each department deals with many vendors. A vendor supplies equipment to many departments. Wolf INC stores 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 however, an employee does not have to be assigned to a project. A project must have at least one employee to exist. An employee can work on many projects. A project is located in a single city. For each city, Wolf INC is interested in its state and population. Project numbers distinguishes projects, and we must store the estimated cost of each project.

IF SOMEONE CAN PLEASE CREATE AN ERD FOR ME USING DRAW.IO I HAVE 1 HOUR TO TURN THIS IN IT WOULD BE GREATLY APPRECIATED AND I WILL UPVOTE. THANK YOU!!

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Database Technology And Management Computers And Information Processing Systems For Business

Authors: Robert C. Goldstein

1st Edition

0471887374, 978-0471887379

More Books

Students also viewed these Databases questions

Question

8. Set goals that relate to practice as well as competition.

Answered: 1 week ago