|
The application currently utilizes 11 databases and a variety of database packages including
ODBC, Microsoft SQL Server, and Microsoft Access.
There are approximately 250 to 500 database tables. The largest is the “Inventory-on-Hand” table
with over 800,000 records. This table contains the gross inventory for all 44 retail locations,
with inventory valued at between $1 and $5 million dollars.
With anywhere between 30 to 60 corporate employees and 100 retail employees using this application
each day, there are countless transactions running through the application each day. Company employees
can access the application through one of 56 web pages (eight primary, 16 secondary, and 32 tertiary).
We would not be able to conduct business today without the functionality this application provides; it
has become an invaluable tool to the success of our business.
|