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?
Database System Concepts
7th Edition
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Chapter1: Introduction
Section: Chapter Questions
Problem 1PE
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
- 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?
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 2 steps
Knowledge Booster
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.Recommended textbooks for you
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education