Homework Help is Here – Start Your Trial Now!
Engineering
Computer Science
PROJECT_CODE PROJECT_CODEPROJECT_MANAGER PROJECT_CODEMANAGER_PHONE PROJECT_CODEMANAGER_ADDRESS PROJECT_CODEPROJECT_BID_PRICE 21-5Z Holly B. Parker 904-338-3416 3334 Lee Rd., Gainesville, FL 37123 16833460.00 25-2D Janet D. Grant 615-898-9909 218 Clark Blvd., Nashville, TN 36362 12500000.00 25-5A George F. Dorts 615-227-1245 124 River Dr., Franklin, TN 29185 32512420.00 25-9T Holly B. Parker 904-338-3416 3334 Lee Rd., Gainesville, FL 37123 21563234.00 27-4Q George F. Dorts 615-227-1245 124 River Dr., Franklin, TN 29185 10314545.00 29-2D Holly B. Parker 904-338-3416 3334 Lee Rd., Gainesville, FL 37123 25559999.00 31-7P William K. Moor 904-445-2719 216 Morton Rd., Stetson, FL 30155 56850000.00 Figure P1.1 How many records does the file contain? How many fields are there per record? 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? If you wanted to produce a listing of the file contents by last name, area code, city, state, or zip code, how would you alter the file structure? What data redundancies do you detect? How could those redundancies lead to anomalies?

PROJECT_CODE PROJECT_CODEPROJECT_MANAGER PROJECT_CODEMANAGER_PHONE PROJECT_CODEMANAGER_ADDRESS PROJECT_CODEPROJECT_BID_PRICE 21-5Z Holly B. Parker 904-338-3416 3334 Lee Rd., Gainesville, FL 37123 16833460.00 25-2D Janet D. Grant 615-898-9909 218 Clark Blvd., Nashville, TN 36362 12500000.00 25-5A George F. Dorts 615-227-1245 124 River Dr., Franklin, TN 29185 32512420.00 25-9T Holly B. Parker 904-338-3416 3334 Lee Rd., Gainesville, FL 37123 21563234.00 27-4Q George F. Dorts 615-227-1245 124 River Dr., Franklin, TN 29185 10314545.00 29-2D Holly B. Parker 904-338-3416 3334 Lee Rd., Gainesville, FL 37123 25559999.00 31-7P William K. Moor 904-445-2719 216 Morton Rd., Stetson, FL 30155 56850000.00 Figure P1.1 How many records does the file contain? How many fields are there per record? 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? If you wanted to produce a listing of the file contents by last name, area code, city, state, or zip code, how would you alter the file structure? What data redundancies do you detect? How could those redundancies lead to anomalies?

Np Ms Office 365/Excel 2016 I Ntermed
Np Ms Office 365/Excel 2016 I Ntermed
1st Edition
ISBN:9781337508841
Author:Carey
Publisher:Carey
Chapter7: Developing An Excel Application
Section: Chapter Questions
Problem 3RA
See similar textbooks
icon
Related questions
Question
PROJECT_CODE PROJECT_CODEPROJECT_MANAGER PROJECT_CODEMANAGER_PHONE PROJECT_CODEMANAGER_ADDRESS PROJECT_CODEPROJECT_BID_PRICE
21-5Z Holly B. Parker 904-338-3416 3334 Lee Rd., Gainesville, FL 37123 16833460.00
25-2D Janet D. Grant 615-898-9909 218 Clark Blvd., Nashville, TN 36362 12500000.00
25-5A George F. Dorts 615-227-1245 124 River Dr., Franklin, TN 29185 32512420.00
25-9T Holly B. Parker 904-338-3416 3334 Lee Rd., Gainesville, FL 37123 21563234.00
27-4Q George F. Dorts 615-227-1245 124 River Dr., Franklin, TN 29185 10314545.00
29-2D Holly B. Parker 904-338-3416 3334 Lee Rd., Gainesville, FL 37123 25559999.00
31-7P William K. Moor 904-445-2719 216 Morton Rd., Stetson, FL 30155 56850000.00

Figure P1.1

  1. How many records does the file contain? How many fields are there per record?
  2. 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?
  3. If you wanted to produce a listing of the file contents by last name, area code, city, state, or zip code, how would you alter the file structure?
  4. What data redundancies do you detect? How could those redundancies lead to anomalies?
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Knowledge Booster
Cloud Computing
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Np Ms Office 365/Excel 2016 I Ntermed
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:
9781337508841
Author:
Carey
Publisher:
Cengage
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781285196145
Author:
Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:
Cengage Learning
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781305627482
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
SEE MORE TEXTBOOKS