Explore BrainMass

Problems with making a listing by city

Please see the attached file for data.

Question 1:
What problem would you encounter if you wanted to produce a listing by city? How would you solve this problem by altering the file structure?

Question 2:
What data redundancies do you detect, and how could these redundancies lead to anomalies?

© BrainMass Inc. brainmass.com July 22, 2018, 12:12 pm ad1c9bdddf


Solution Preview

1) Since "City" is not a Column by itself, we cannot produce a listing by "City."

The solution is to split the column "Manager_Address" into 4 columns:


Solution Summary

100+ words analyses file structure and data redundancies to outline issues one could encounter.