Page 2 of 3 Cardinality Quiz Handout 4. EXERCISE DESCRIPTION (PICTURE) EXERCISE DESCRIPTION (NARRATIVE) " Disaster" is an insurance company. Customers buy a contract from Disaster. There is at most one contract for a CASI customer. RECEIPT . When a disaster happens, Disaster has to pay a customer. . Customers make monthly payments. CONTRACT A customer makes her/his first payment one or two weeks after she/he signs the contract. CAST . There is at most one contract for each cash receipt. DISRI RSEVENT In general, Disaster uses 6,12 or 24 payments to pay the customer. There is at most one customer for a cash disbursement. Last week Disaster bought furniture from Pinko. Disaster does not have to pay Pinko until the beginning of next year. A great deal ! What are the cardinalities for the Contract Cash Disbursement relation 4a 4b Cash Disbursem Contract ent 5. EXERCISE DESCRIPTION (PICTURE) EXERCISE DESCRIPTION (NARRATIVE) Xilebo is a company selling kitchenware to restaurants. Xilebo uses the following status values for customers: flea, fly, frog, fox and lion. A new customer gets status fly. When the customer remains creditworthy he can improve his status; that is: become a frog, become a fox, etc. When a customer does not pay on a regular basis he becomes a flea. Xilebo does not keep the history of changes in status and only records the most recent status. Currently, nobody is a lion. More than 500 customers have status fox. Only five customers have status flea. 5a 5b Inator er Customer Status 6. EXERCISE DESCRIPTION (PICTURE) EXERCISE DESCRIPTION (NARRATIVE) When you buy optional equipment for a car you can buy equipment as a single item or as a package. In general, packages are cheaper. An example of an optional equipment package is Volvo's Grand Touring Package. The Grand Touring Package includes an adjustable power front seat, an in-dash single CD player and burled walnut wood trim on instrument panel and center floor console. The Grand Touring Package is available for all V70 models (V70 GT, V70 GLT) except for the V70 T model. The package is standard on the V70 T5 model. No optional equipment packages are available for the V70 T5 model. Other packages are available for the V70 GT. Examples of other optional equipment packages available for the V70 GT Car Package Model are the Sport Package and the TRACS/Cold Weather Package. There is at least one car model for each package. 6a 6b Car Optiona Model Package