3.24 Consider the ER diagram in figure below. Assume that an departments may have up to three phone numbers. Supply (min, max

3.24 Consider the ER diagram in figure below. Assume that an departments 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? employee may work in up to two may not be assigned to any department. Assume that each department must have one and or Figure A (0,2) (1, 10) ΕMPLOYΕ WORKS-IN DEPARTMENT ,6 (,3) HAS-PHONE CONTAINS (1, 1D (, 0 PHONE



Source link

Leave a Reply

Your email address will not be published. Required fields are marked *