Activity:
Draw soft boxes for each of
the following. Draw relationship lines and correctly label each relationship in
both directions.
1. Each town is the birthplace
of many people. Each person is born in one and only one town.
2. Each room may house one or
more guests. Each guest may stay in one and only one room.
3. Each employee works for
one and only one department. Each department may have one or more employees.
4. Each hotel may be the host
of one or more guests. Each person may be hosted in one or more hotels.
5. Each message must be
addressed to one or more persons. Each person may be the addressee of one or
more messages.
6. Each garment must have one
and only one price. Each price may be for one or more garments.
7. Each airline coupon must
be used for one and only one destination. Each destination may be visited with
one or more coupons.
8. Each automobile uses one
and only one tire size. Each tire size may be used by one or more automobiles.
9. Each child has one and
only one mother. Each mother may be the parent of one or more children.
10. Each person must be of
one and only one blood type. Each blood type may classify one or more persons.
11. A person may be on one or
more junk-mail lists. Each junk list may contain one or more persons.
12. Each student has one or
more teachers. Each teacher has one or more students.
13. Each school may be attended
by one or more honor students. Each honor student must attend one and only one
school.
14. Each fingerprint must
belong to one and only one person. Each person must have one and only one
fingerprint.