Production Database System – A Nature Conservation Firm

Industry: Non-Profits, Associations and Organizations
Solution: Production Database System
Technologies: SQL Server, Microsoft Access
Solution Type: Custom Database Application

Nature Conservation firm logo

Our client, BCM, is one of the green treasures of the Forest Preserve District of Cook County and is accredited by the American Association of Museums. The museum is managed by the Chicago Horticultural Society and is a 385-acre living plant museum featuring 23 distinct display gardens surrounded by lakes as well as a prairie and woodlands. The museum opened to the public in 1972 and offers a broad array of adult classes in plant science, landscape design and gardening arts.

Challenge Challenge - Mountain without Flag

BCM was using dBaseIII to track the progress of their plants from propagation to production. The database was out of date and was lacking in functionality, versatility and ease of use. Only one person could work on a specific record in the database at a time, preventing the staff from using their time efficiently.

In addition, there was a need to expand functionality and reporting capabilities to reduce duplication of effort by staff members and provide the growers with up to date information they needed to perform their jobs. It was important that the application be user-friendly and intuitive while providing users quick and easy access  to the information they needed.

Solution Solution - Mountain with Flag

alligatortek was selected to develop a customized solution that would help the museum replace its outdated system on dBase III. The solution was a relational database application that can now be accessed by multiple users simultaneously in different departments. Initially, SQL Server 2000 was selected as the database platform with Microsoft Access 2003 as the front-end platform. The platforms have since been updated to the latest versions of SQL Server and Microsoft Access.

The museum employees and volunteers now have simultaneous, quick-and-easy access to plant production specifications and are able to perform their jobs more accurately and more efficiently.

latest news


How to Use ADFS to Implement Single Sign-On for an ASP.NET MVC Application

Without using any complex code logic, I leveraged Microsoft’s Single Sign-On (SSO) on my existing ASP.NET MVC web application.


10 Ways to Save Money By Hosting On Microsoft Azure

Many companies move to the Cloud to lower costs and offload the management of their IT infrastructure. Once you create resources in the Cloud, there is still more work to do. By considering the list below, you can ensure you are getting the performance you need while keeping your monthly spend in check.


Is AI Making Me Lazy?

Over the course of the last month, I logged the different ways my family used AI-powered devices in my home. Does artificial intelligence mean I can't think for myself? Read what I think in my latest blog – Nate Pave.

Copyright © 2018 alligatortek. All rights reserved.