Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed
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

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

Understanding Oracle APEX 5 Application Development

Authors: Edward Sciore

2nd Edition

1484209893, 9781484209899

Students also viewed these Databases questions