Question
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started