Lesson+2+-+The+Problem

Once my team began work on the "deep dive" deliverable, we divided the task into three parts. I was assigned with the task of explaining the organization's current networking and security specs. After consulting with the DBA and Network Administrator I learned that Manhattan's security is very good indeed and had already implemented many of the ideas I had come up with before recieving the information. The network layout is a basic LAN/WAN configuration that can be found at almost any company, but utilizing Access Control Lists and VPN concentrator software to control the availability of data. By utilizing Virtual Private Networks, offsite employees also have access to Manhattan servers and databases. After reporting the specifications and diagramming the schematics of thier current network and security configurations, my team turned our report over to Manhattan for review. The team then faced the problem concerning the final deliverable which would be how to consolodate the multiple reporting systems the organization uses. The main problems revolving around this being data overlap, reporting capabilities for all employees, difficulties concerning data retrieval, system time-outs and lock-ups, and data integrity.

Top 10 Mistakes When Building a Database: [] This article is a listing of the top 10 mistakes that are made when building and maintaining a database. This article relates to this lesson because of some of the problems our team found when evaluating the current reporting environment.

Larson, Gregory A. "Top 10 Mistakes When Building and Maintaining a Database — DatabaseJournal.com." Database Journal  Daily Database Management & Administration News and Tutorials. 13 Oct. 2010. Web. 13 Oct. 2010. []. 

