Purchase Solution

Problems with making a listing by city

Not what you're looking for?

Ask Custom Question

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?

Attachments
Purchase this Solution
Solution Summary

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

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
...

Purchase this Solution
Free BrainMass Quizzes
Word 2010: Tables

Have you never worked with Tables in Word 2010? Maybe it has been a while since you have used a Table in Word and you need to brush up on your skills. Several keywords and popular options are discussed as you go through this quiz.

Basic UNIX commands

Use this quiz to check your knowledge of a few common UNIX commands. The quiz covers some of the most essential UNIX commands and their basic usage. If you can pass this quiz then you are clearly on your way to becoming an effective UNIX command line user.

Excel Introductory Quiz

This quiz tests your knowledge of basics of MS-Excel.

C++ Operators

This quiz tests a student's knowledge about C++ operators.

C# variables and classes

This quiz contains questions about C# classes and variables.

View More Free Quizzes
Related BrainMass Solutions

  • Three Statistics Questions: Radio Station, Mean Annual Temperature, and Seventh Grade Homeroom

    Problem 1 You own a radio station and you have three salespeople. Below is a listing of their sales for the last eight weeks. Please use α .05 to decide if there is a difference in the means.

  • Calculate R-squared in multiple regression

    Let's begin by listing all of the variables. Response: The amount of time spent in the hospital Explanatory: age, cholesterol level, blood pressure, and the hospital you are in.

  • Cash Management Controls

    It's less likely that a third party with a fiduciary duty will misappropriate funds than someone from inside the city. 4. The City will diversify its investments by security type and institution. With the exception of U.S.

  • Economics

    But this has led to developing of a number of problems for the employees of the city that are suffering from the respiratory problems, headache and coughs.

  • City Council Advisement + City of Kelsey Virtual Classroom

    for a Park project, when education is by far more important for the citizens of that city.

  • Selecting Appropriate Software

    As per vkinfotek, "This document has to be prepared by an expert group responsible for listing all the requirements and not missing out on any. " 2) RFQ and details of products are discussed with various vendors. 3) Screening and short listing of

  • Mr. Jones's projects case

    The neighbor, a Swill national is required to file her suit in the District court, whereas the criminal suit will be brought up in the State Trial court (2). The city must file a complaint with the police for initiating criminal procedure. Mr.

  • Organizing Sociological Research of a Metropolitan City

    By 1860, Houston became a major hub for exporting cotton.

  • Public vs. Private Financing

    Since management of private investors can spend time and attention on running a business. The business leadership once freed from the problems of compliance can focus on making the business more competitive.

View More Related Solutions