Information Systems homework help

Dartmoor Medical Associates maintains two patient files— one for the Lakewood office and one for the Hanover office. Each record contains the name, address, city, state, and zip code of a patient, with the files maintained in zip code order. Design the logic that merges the two files to produce one combined name-and-address file, which the office staff can use for addressing mailings of the practice’s monthly Healthy Lifestyles newsletter.

Must have a

1. Data Dictionary (in excel)

2. Hierarchy Chart (in visio)

3. Flowcharrt (in visio)

4. Pseudocode (in word).

Than put all together in a word document