Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Draw the entity-relationship diagram for a companys divisions, departments, employees, and the dependents of employees where: a) Each division is made up of departments; each

Draw the entity-relationship diagram for a companys divisions, departments, employees, and the dependents of employees where:

a) Each division is made up of departments; each department belongs to one division.

(b) Each department is assigned several employees and each employee works for one department.

(c) Each of the employees may or may not have one or more dependents and each dependent belongs to one employee.

(d) Each employee has a first name, last name, date of hire, and a company assigned ID.

(e) Each dependent has a name and date of birth/

(f) Each Department has a name and company designated number.

(g) Each division has a name and an abbreviation (such as PR for production).

Underline the primary keys in your E/R diagram and indicate any many-one or one-one relationships by using the appropriate arrows. Also note that the dependents entity set is a weak entity set. (Think about this it should make sense!). Write the schemas for the entity-relationship diagram of the Problem .

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_2

Step: 3

blur-text-image_3

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

Principles Of Database Systems With Internet And Java Applications

Authors: Greg Riccardi

1st Edition

020161247X, 978-0201612479

More Books

Students also viewed these Databases questions

Question

5. Identify three characteristics of the dialectical approach.

Answered: 1 week ago

Question

7. Identify six intercultural communication dialectics.

Answered: 1 week ago