Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Se pueden has been involved in shad i ng prices over the past few years her the had been fired, ABC Company inspired wo o
Se pueden has been involved in shad i ng prices over the past few years her the had been fired, ABC Company inspired wo o ning he y because they fee Beenmon's could still the file ABC Company. ARC Cenyewe aequired the first and instead of firing all the previous employees. All Ceny would like to restore the current organization to their own cture. ABC Company has many departments Bach department contains information such as department In der name, and manager. For each department there are one or more positions wade Bach position has an ID, description, and salary. It is also important to keep track efte and description). Each position requires one or more skills. Employees have one or more skills, but if their skills do not fit a position then they will be laid of Information kept on employees includes employee ID, name, address, phone, and skills Some of the sample documents are provided below (60 points). Draw the ERD for the scenario described here. State any additional suptions you believe you have to make in order to develop a complete diagram. Phone Skill ID 211,212, 219 221.231 Address 405-355.633 12 main St Norman OK 73072 405-555-7415 123 common St Norman OK 74325 Employee ID Name James Jones Mary Joe artee List Department ID Name Accounting 222 Marketing Legal Manager Knapp Daddy Jennifer Walsh Marsha Clark 2013 Position List Position ID 0123 0235 Description System Analyst Account Executive Department ID 444 111 Salary 56,000 63,000 Skill ID 211, 212, 213 214, 231 Skill List Skill ID 211 212 213 214 Description Web Development Visual Basic C# Auditing
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