Consider the ER diagram in Figure 7.22. Assume that an employee may work in up to two departments or may not be assigned to any department. Assume that each department must have one and may have up to three phone numbers. Supply (min, max) constraints on this diagram. State clearly any additional assumptions you make. Under what conditions would the relationship HAS_PHONE be redundant in this example?

What will be an ideal response?


Assuming the following additional assumptions:

- Each department can have anywhere between 1 and 10 employees.

- Each phone is used by one, and only one, department.

- Each phone is assigned to at least one, and may be assigned to up to 10 employees.

- Each employee is assigned at least one, but no more than 6 phones.



The resulting ER Diagram will have the (min, max) constraints shown in Figure A.



Relationship HAS-PHONE would be redundant under the following conditions:

- Each employee is assigned all of the phones of each department that he/she works in.

- An employee cannot have any other phones outside the departments he/she works is.

EMPLOYEE

PHONE

DEPARTMENT

HAS-PHONE CONTAINS

WORKS-IN

(0, 2)

(1, 3)

(1, 10)

(1, 10) (1, 1)

(1, 6)

Computer Science & Information Technology

You might also like to view...

The word shown in bold is used correctly in the following sentence.Both of them believe in the principle of paying yourself first, so each month, they set aside $200.?

Answer the following statement true (T) or false (F)

Computer Science & Information Technology

Which type of macro executes when an event attached to a control or object occurs?

A. Stand-alone B. Included C. Embedded D. Automatic

Computer Science & Information Technology

What is the main purpose of the Fair Credit Reporting Act ("FCRA")?

A. Enable data reporters to efficiently report valid debts on a consumer's credit report B. Allow employers to quickly access financial data of their employees C. Increase the ability of the government to access consumer reports of suspected criminals D. Increase the accuracy and fairness of credit reporting and limit the use of consumer reports to permissible purposes

Computer Science & Information Technology

Explain briefly how the quality at which a preview file is displayed can affect InDesign's performance.

What will be an ideal response?

Computer Science & Information Technology