Homework_5_Solution

# Homework_5_Solution - Homework 5 Solution ISE 382 Spring...

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

Homework 5 Solution ISE 382 Spring 2006 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. AGENT CAR 1:1 AGENT_VEHICLE 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. AGENT CLIENT 1:N 1

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

View Full Document
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
This is the end of the preview. Sign up to access the rest of the document.

## This note was uploaded on 04/24/2008 for the course ISE 382 taught by Professor Kale during the Spring '08 term at USC.

### Page1 / 6

Homework_5_Solution - Homework 5 Solution ISE 382 Spring...

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

View Full Document
Ask a homework question - tutors are online