Explore BrainMass
Share

Problems with making a listing by city

This content was STOLEN from BrainMass.com - View the original, and get the already-completed 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 October 24, 2018, 11:26 pm 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
See Also This Related BrainMass Solution

Problems with your Reference List

See the attachment.
Search the Internet and find a peer-reviewed journal article that uses fully or mostly compliant APA formatting, references, and citations. In a well-written, cohesive paragraph, cite the article in APA form and discuss the following:
How does the use of APA formatting, references, and citations aid or hinder the reader?
How is the formatting of the document different from or similar to papers that you have reviewed and written in the past?
Provide a properly formatted reference for the article.

Dooley, C. M. (2011). The Emergence of Comprehension: A Decade of Research 2000-2010. International Electronic Journal of Elementary Education. (Vol 4. Issue 1. pp. 169 - 184).

View Full Posting Details