Homework 4 Solution

Homework 4 Solution - Homework 4 Solution ISE 382 5.16...

Info iconThis preview shows pages 1–3. Sign up to view the full content.

View Full Document Right Arrow Icon
Homework 4 Solution ISE 382 5.16 Define the terms maximum cardinality and minimum cardinality. Maximum cardinality is the maximum or largest number of entity instances that can occur on one side of the relationship. Minimum cardinality is the minimum or smallest number of entity instances must participate in the relationship. 5.19 Give examples of M-M, M-O, O-M, and O-O relationships (other than those presented in this chapter). Use the circle and hash mark notation on the diamond portrayal of relationships. In the Real Estate Agency example in question 5.5. each AGENT must use an agency car when on agency business. Further, to keep costs down the agency keeps exactly enough cars for the agents. Therefore, each AGENT must have a CAR, and each CAR must be assigned to an AGENT. This is an M-M relationship. In the Real Estate Agency example in question 5.5. each CLIENT must be assigned to an AGENT, but there may be AGENTs who currently have no CLIENTs. This is an M-O (same as O-M, but seen reversed) relationship. 1
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
In the Real Estate Agency example in question 5.5. CLIENTs may be seeing AGENTs without currently being interested in specific PROPERTY, and a PROPERTY may be listed without any CLIENT currently being interested in it. This is an O-O relationship.
Background image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 5

Homework 4 Solution - Homework 4 Solution ISE 382 5.16...

This preview shows document pages 1 - 3. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online