Making choices and exercising judgment. Coral’s See-the-Reef, located on the Gulf of Mexic...

Making choices and exercising judgment. Coral’s See-the-Reef, located on the Gulf of Mexico, is famous for its fast service. Coral’s business is renting scuba and snorkeling gear. Coral needs someone to analyze her business and help her use that analysis to plan and design a new information system. Coral employs four fitting clerks, three rental clerks, and four cashiers. The fitting clerks enter equipment items, sizes, and experience codes into the computer. The computer searches the rental inventory, by experience code, for the requested equipment. For example, a beginner is code one, which tells the computer to locate the oldest equipment available in the requested size. Once the requested equipment is located, a duplicate rental invoice is printed. The

rental clerk uses the second copy to retrieve the equipment. While this clerk gets the equipment, the customer pays the rental fee to a cashier. A deposit is added to the rental fee, and a code indicating the condition of the equipment is noted.

Source: A. S. Hollander, E. L. Denna, and J. O. Cherrington, Accounting, Information Technology, and Business Solutions, 2nd ed. (New York: Irwin/McGraw-Hill, 2000).

a. Create a REA model for Coral’s See-the-Reef. Create database tables for one resource, one event, and one agent.

---

b. Suggest two queries Coral should incorporate in her database; justify your suggestions. Which tables and fields would she need to create the queries you suggest?

---

c. Design a form a fitting clerk could use for entering equipment items, sizes, and experience codes.