Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Since going public Beenron has been involved in shady accounting practices over the past few years. After the executives had been fired, ABC Company inquired

Since going public Beenron has been involved in shady accounting practices over the past few years. After the executives had been fired, ABC Company inquired about acquisitioning the company because they felt Beenrons assets could still be useful to ABC Company. ABC Company eventually acquired the firm and instead of firing all the previous employees, ABC Company would like to restructure the current organization to fit their own structure. ABC Company has many departments. Each department contains information such as department ID, department name, and manager. For each department there are one or more positions available. Each position has an ID, description, and salary. It is also important to keep track of skills (SkillID 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 off. Information kept on employees includes employee ID, name, address, phone, and skills. Some of the sample documents are provided below . Draw the ERD for the scenario described here. State any additional assumptions you believe you have to make in order to develop a complete diagram. Employees List Employee ID Name Phone Address Skill ID 1223 James Jones 405-555-9633 12 main St Norman OK 73072 211, 212, 219 1522 Mary Joe 405-555-7415 123 common St Norman OK 74325 221, 231 Department List Department ID Name Manager 111 Accounting Knapp Daddy 222 Marketing Jennifer Walsh 333 Legal Marsha Clark Position List Position ID Description Department ID Salary Skill ID 0123 System Analyst 444 56,000 211, 212, 213 0235 Account Executive 111 63,000 214, 231 Skill List Skill ID Description 211 Web Development 212 Visual Basic 213 C # 214 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

Database Principles Programming And Performance

Authors: Patrick O'Neil

1st Edition

1558603921, 978-1558603929

More Books

Students also viewed these Databases questions