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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!