Case Study: Jack's Steamed Shrimp

Jack's Steamed Shrimp is a small food chain that specializes in steamed seafood and has a number of locations in seaside resort towns. Each location has outside tables for diners to enjoy and a thriving delivery business to the surrounding areas. The company has grown to more than 20 locations and 250 employees.

Jack's has developed two applications internally that are used to run the day-to-day operations of the business. One is designed to handle the point of sale for the food sales, both in-store and telephone orders for delivery. The other maintains the inventory and food orders required to ensure that none of the locations run out of supplies.

Planned Changes

The new applications are being rolled out to replace existing applications that currently run on the same database. Some schema changes will be included to extend functionality, but a number of the old objects in both the Inventory and Sales databases will be maintained.