Question
Draw an E.R.D with connectivity for the following narrative: You want to track information about 10 departments in your company. Each department has a unique
Draw an E.R.D with connectivity for the following narrative:
You want to track information about 10 departments in your company. Each department has a unique name, is located on a specific floor and has a phone number. Within each department there is a department head and a range of additional employees. For all employees we want to track their name, who their boss is, their salary as well as the unique employee number each had assigned to them when they started the company. Each employee also has a set of skills. You need to track this set of skills so you can locate employees with the right skill set to be part of various cross department project teams. You need to also track information about all of the projects that are under taken by these various departments. Each project has a unique id, a name, a start date, and at least 3 employees on it. All projects have a project leader and a project coordinator. Any employee can be a project leader but they can only lead one project. Furthermore any employee can be a project coordinator and they can coordinate any number of projects.
The attributes given are meant to help you understand the scenario. Dont include them on your ERD.
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