Date of Award

Spring 1-1-2003

Document Type


Degree Name

Master of Science in Information Systems (MSIS)

First Advisor

Haomin Wang

Second Advisor

Zehai Zhou

Third Advisor

Randy Tupper


Coca-Cola Bottling of Central South Dakota (CCBCSD), which is comprised of four separate sales centers and warehouses, and is owned by Chesterman Company of Sioux City Iowa, has experienced radical (month to month) discrepancies in inventory tracking and charges over the past 12 to 32 months. To gain an understanding of individual sales center inventory trends involving shipments both into and out of sales centers, as well as sales and damaged/destroyed products, CCBCSD has determined the need for an onsite inventory tracking database. Three of the four sales centers maintain Microsoft Windows 98 personal computers with Microsoft Office 2000 Professional Edition business software. It was determined that MS Access 2000 database software should be used as the basis for the inventory tracking database. The project to design the custom database for the CCBCSD sales centers was initiated September 1, 2002, with the expressed goal of full implementation on December 1, 2002. The project was conceived, designed, tested and implemented within the allotted three month period. A business web site for CCBCSD sales centers was created as a demonstration of possible future expansion for the database.