Kudler Fine Foods
Database Management Solution - SQL Server 2000
Description of E2LA Consulting, Inc.
E2LA Consulting, Inc. (E2LA) began their consulting firm with over 15 years of information technology experience ranging from installation of hardware systems and software applications to enterprise system deployments. E2LA has extensive programming knowledge for various industry specific applications. The consulting company has over five years of successful development in enterprise-level database management systems. With an extensive customer service base, E2LA manages to successfully implement database systems for various industries, to include fine food markets.
E2LA afforded the opportunity to propose an enterprise investigation and feasibility study on the development of a database management system for Kudler Fine Foods based upon their business service requirements. The consulting team are the following:
- Project Manager: Laine Garrido
- Executive Assistant: Shirley Ann Garrido
- Database Administrator: Eric Roker
- Software Engineer: Everett Sappenfield
- IT Manager/Security Engineer: Alvin Timbol
- Kudler's IT staff
Figure 1 - E2LA Organization Chart
Kathy Kudler, Owner of Kudler Fine Foods, opened her first local upscale specialty food store in San Diego on June 18, 1998, and the opening of two additional stores followed in La Jolla (2000) and Del Mar (2003). Kudler's mission is to provide customers with the finest selection of "foodstuffs" and wines utilizing their knowledgebase and expertise for importing products from around the world.
Statement of Need
Kudler Fine Foods' existing database application limits their capability of tracking customers, orders and transactions. Their current database system limits their ability to generate dynamic and ad hoc reports. Their database also does not provide modules to allow other locations access to the database. Therefore, there is no shared data communication between locations.
The inability to provide real time information to customers has become a constraint to their operations...