Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

For the business rules given below, draw an ERD / EERD Business Rules: ABC Corporation has five departments: administration, marketing, sales, shipping, and purchasing. Each

For the business rules given below, draw an ERD/EERD
Business Rules:
ABC Corporation has five departments: administration, marketing, sales, shipping, and purchasing.
Each department employs many employees. Each employee has an ID, a name, a home address, a home phone number, a salary, and a Social Security number.
Some employees are classified as sales representatives, some as technical support, and some as administrators.
Sales representatives receive a commission based on sales.
Technical support employees are required to be certified in their areas of expertise.
All administrators have a title and a bonus.
Given that information, create the ERD/EERD containing all primary keys, foreign keys, and main attributes.

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

Data Mining Concepts And Techniques

Authors: Jiawei Han, Micheline Kamber, Jian Pei

3rd Edition

0123814790, 9780123814791

Students also viewed these Databases questions

Question

What is the relation of physical mathematics with examples?

Answered: 1 week ago

Question

What are oxidation and reduction reactions? Explain with examples

Answered: 1 week ago

Question

4. What will the team agreement contain?

Answered: 1 week ago