Competency 7, Stages in Planning, Analysis, and Systems Design Implementation.

The first thing we had to do was alot of research! We interviewed 2 separate information specialists (As stated in Comp. 3), and held a variety of meetings with our instructor, Arlene. All research was very informative and necessary to insure a solid foundation. It is important that all needs of our database were considered before any actual work was done in our Database Software (Microsoft Access 97).

We then diagrammed a story board of each of our tables. We had to define relationships to insure one to many links between tables. This was especially important to insure Referential Integrity. That would in turn allow us to maintain the documents with Cascade Updates & Deletes. Once we were convinced we had a solid foundation. We created minimum portions of our 5 separate tables and created our proposed relationships. We did a test run through a number of queries to see if it would work. Fortunately for our group it worked the way we planned. From here on it was just work work work in Access to start importing an extremely large group consolidation of records.