Explore BrainMass
Share

Problems with making a listing by city

This content was STOLEN from BrainMass.com - View the original, and get the solution, here!

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 September 22, 2018, 3:10 am ad1c9bdddf - https://brainmass.com/computer-science/files/what-problem-would-you-encounter-if-you-wanted-to-produce-a-listing-by-city-193634

Attachments

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:

Manager_Street
Manager_City
Manager_State
...

Solution Summary

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

$2.19