You have been called back to take another look at Merman€™s Costume Rentals. Here is part of the database created for Annie Oaklea of Merman€™s (with whom you last worked in Consulting Opportunities 7.1 and 8.1). The database contains information, such as the cost of the rental, the date checked out, the date due back, and the number of days the costume has been rented since the beginning of the year (YTD DAYS OUT). Analyzing Annie€™s typical day in the costume rental business, you realize there are several requests she must make of the database so that she can make decisions on when to replace frequently used costumes or even when to buy more costumes of a particular type. She also needs to remember to keep in the good graces of customers she has previously turned down for a particular costume rental, to know when to recall an overdue costume, and so on. Formulate several queries that will help her get the information she needs from the database. In a paragraph, describe how Annie€™s queries would be different if she were working with a Web-based or hyperlinkedsystem.

Transcribed Image Text:

COSTUME-RENTAL DATE YTD REQUESTS COSTUME COST | CHECKED DUE | DAYS | TYPE OF | TURNED SUIT NUMBER! DESCRIPTION |NUMBER COLOR |OF | OUT DATE OUT COSTUME DOWN 0003 Lady MacBeth F, SM 01 Blue 1342 Bear F, MED 1344 Bear F, MED 1347 Bear F, LG 1348Bear F, LG 1400 Goldilocks F, MED 1402 Goldilocks F, MED 1852 Hamlet M, MED 1853 Ophelia F, SM 4715 Prince M, LG 4730 Frog M, SM 7822 Jester M, MED 7824 Jester M, MED 7823Executioner M, LG 8645 Mr. Spock N, LG 9000Pantomime F, LG 9001 Pantomime M, MED 01 Blue 9121 Juggler M, MED 9156 Napoleon M, SM 15.00 10/15 11/30 150 Standard 2 0 0 01 Dk. Brown 12.50 10/24 11/09 26 Standard 02 Dk. Brown 12.50 10/241/09 115Standard 01 Black 02 Black 01 Light Blue 7.0010/24 11/09 140 Standard 02 Light Blue 7.00 10/28 11/0910 Standard 01 Dark Green 15.00 11/0211/23 115Standard 01 Light Blue 1 /02 11/23 22 Standard 01 White/purple 10.0011/04 11/21145 Standard 01 Green 01 Multi 02 Multi 01 Black 01 Orange 01 Red 12.5010/24 11/09 22 Standard 12.50 11/01 11/0810 Standard 0 3 0 15.00 11 7.00 11/04 11/21 175 Standard 7.50 11/10 7.50 1/09 11/15 10 Standard 7.00 11/19 12/05 21 Standard 18.00 09/0709/12 150 Trendy 7.00 08/25 09/15 56 Standard 7.00 08/25 09/15 72 Standard 7.00 11/05 11/19 14 Standard 2 12/08 12 Standard 0 0 4 0 0 0 01 Multi 01 Blue/white 15.00 10/2611/23 56Standard