Question: 1. The resource units are located in different facilities . These facilities are located in geographically different buildings although they are close to each other.
1. The resource units are located in different facilities. These facilities are located in geographically different buildings although they are close to each other. Each building has a facilitiy id and id for the enterprise managing the facility. One resource unit has exactly one facility. A facilty may be associated with multiple resource units. A resource unit must have at least one facility and a facility must have at least one resource unit.
For this problem:
write a line (one-liner) indicating the nature of relationship,
draw an ER diagram clearly delineating all columns and Primary keys and Foreign keys,
decide on the number of tables needed, and
four accompanying statements of maximum and minimum cardinality.
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
