Use Access to Create a Database using the Teton Whitewater Kayak Case study under this link.

1. Create the following tables:

Customer

Equipment \ Inventory

Sales person \ Staff

Sales \ Rentals

**Fill each table with at least 6 records, using the information provided in the rental cost table. You can makeup the rest of the data (eg Salesperson or individuals renting or purchasing equipment) Have 3 sales, 3 rentals.

2. Create the following queries:

What inventory is currently in stock?

Which equipment is rented out and by what customer and who was the sales rep?

What were the total number of late rentals for the quarter?

3. Export those 3 queries to 3 reports, exported to a PDF document

4. Submit your final Access file and your 3 PDF files. (4 files should be attached in total)

Journal of Information Systems Education, Vol. 14(3) A Database Design Case: Teton Whitewater Kayak Kevin R. Parker Department of Computer Information Systems College of Business Administration Idaho State University Pocatello, Idaho 83209 parkerkna isu.edu The Teton Whitewater Kayak case is designed to provide students with a challenging hands-ee exercise in relational database design Itiextimsive mough to provide a timalating cxercis, but not so large as to be overwhelmingThis case can be utilized for a goup project in a datahase menapement or database design course. The case is sufficiently detailed so challenge students as they apply the design concepts esplained in class to a problem that closcly simulales a real-weeld problems An assolated prewet can be broken into deliverables, or mdividual componenb th.a! cover a sngle ta?to make project more manageable Same of the suggested deliverables associated with this prom! n!?the design of e tity. lationship diagrams, normalization of the diatabase schema, table ceation SQL query desig form and repoet design and tored procedure and trigger desin. The problem was designed to be estensiblk. For esample, while it does into include crodit card peocessing oe selling equipment on consignment, those fcatures can be easily added to make the case moee complex. The case can even be estemded for use in an analysis and design class, as the services peovided by the compamy are presented as a set of processes that can be easily represensed in a data flow diagram. Keywords Database design, database management, normaliation cntity -relationship diagrams cae 1. CASE SUMMARY 2 CASETENT Tee Whitiewatcr Kayak in Jackse Hok, Wyoming rts a Teon Whitewater Kayak (TwK) provides standard varicty of eqeipment to enable oundoor enthusiasts to enjoy the equipment rental services for customers diverse waters of Grand Teton National Park, Yelowstone National Park, and Jackson Hole. Based in Jackson Hole, in theCustomer submits oqumensation shadow of the Teton Mountains, they are specialists in the field. of outdooe recreation They have the laest model canoes whitewater kayaks, touring kayaks, and inflatables as well as Customer retums ronted oqipment to pet their clientele on the waker.Customer Their top of the ine boats and aqepment are available to rent by the day or by the week TWK needs addzional Thack office services to support busness Because they set high goals and standards for their compamyPrint rental agreement pt they are concemed in improving their customer service and. oquipment rental system. They have requested a rental daiabase that supports the core business requirements of the enterprise Print unncturnod oquipment lid (report) Reclasify excoss equipment as uk item Print equipment rental repont Basod on your knowlodge of datsbase design, you know thai Print equipment sakes report you will first need to develop an entiny-relationship dagram thatOder now oqipment models the system. Using the entitics, relationshps, andProcess new inventory aibutes that make up the ER diagram you will next. determine and specity the relational schema for each elation. You will then sormaline cach elation Once normakzation is complete, otherfeatures can be developed based on the resalting The TWK mplementation cursent inventory ist computcr sym makes use of barcodes to Since various types of watercrat are available, the tcrm eqaipmem" may be used to represent all types record information. Each piece of equigment is assigned a unique ID Soe vey connol 271 Journal of Information Systems Education, Vol. 14(3) A Database Design Case: Teton Whitewater Kayak Kevin R. Parker Department of Computer Information Systems College of Business Administration Idaho State University Pocatello, Idaho 83209 parkerkna isu.edu The Teton Whitewater Kayak case is designed to provide students with a challenging hands-ee exercise in relational database design Itiextimsive mough to provide a timalating cxercis, but not so large as to be overwhelmingThis case can be utilized for a goup project in a datahase menapement or database design course. The case is sufficiently detailed so challenge students as they apply the design concepts esplained in class to a problem that closcly simulales a real-weeld problems An assolated prewet can be broken into deliverables, or mdividual componenb th.a! cover a sngle ta?to make project more manageable Same of the suggested deliverables associated with this prom! n!?the design of e tity. lationship diagrams, normalization of the diatabase schema, table ceation SQL query desig form and repoet design and tored procedure and trigger desin. The problem was designed to be estensiblk. For esample, while it does into include crodit card peocessing oe selling equipment on consignment, those fcatures can be easily added to make the case moee complex. The case can even be estemded for use in an analysis and design class, as the services peovided by the compamy are presented as a set of processes that can be easily represensed in a data flow diagram. Keywords Database design, database management, normaliation cntity -relationship diagrams cae 1. CASE SUMMARY 2 CASETENT Tee Whitiewatcr Kayak in Jackse Hok, Wyoming rts a Teon Whitewater Kayak (TwK) provides standard varicty of eqeipment to enable oundoor enthusiasts to enjoy the equipment rental services for customers diverse waters of Grand Teton National Park, Yelowstone National Park, and Jackson Hole. Based in Jackson Hole, in theCustomer submits oqumensation shadow of the Teton Mountains, they are specialists in the field. of outdooe recreation They have the laest model canoes whitewater kayaks, touring kayaks, and inflatables as well as Customer retums ronted oqipment to pet their clientele on the waker.Customer Their top of the ine boats and aqepment are available to rent by the day or by the week TWK needs addzional Thack office services to support busness Because they set high goals and standards for their compamyPrint rental agreement pt they are concemed in improving their customer service and. oquipment rental system. They have requested a rental daiabase that supports the core business requirements of the enterprise Print unncturnod oquipment lid (report) Reclasify excoss equipment as uk item Print equipment rental repont Basod on your knowlodge of datsbase design, you know thai Print equipment sakes report you will first need to develop an entiny-relationship dagram thatOder now oqipment models the system. Using the entitics, relationshps, andProcess new inventory aibutes that make up the ER diagram you will next. determine and specity the relational schema for each elation. You will then sormaline cach elation Once normakzation is complete, otherfeatures can be developed based on the resalting The TWK mplementation cursent inventory ist computcr sym makes use of barcodes to Since various types of watercrat are available, the tcrm eqaipmem" may be used to represent all types record information. Each piece of equigment is assigned a unique ID Soe vey connol 271