Please answer questions 1 to 4 if possible. Given the file structure shown in Figure P1.1, answer Problems 1-4.Figure 1: The File Structure for Problems 1-4PROJECT CODE PROJECT MANAGER MANAGER_PHONE21-5Z25-2D25-5A25-9T27-4Q29-2D31-7PMANAGER ADDRESS3334 Lee Rd., Gainesville, FL 37123218 Clark Blvd., Nashville, TN 36362124 River Dr., Franklin, TN 291853334 Lee Rd., Gainesville, FL 37123124 River Dr., Franklin, TN 291853334 Lee Rd., Gainesville, FL 37123PROJECT BID PRICE16833460.0012500000.00Holly B. Parker904-338-3416Jane D. Grant615-898-9909George F. DortsHolly B. ParkerGeorge F. DortsHolly B. ParkerWilliam K. Moor615-227-1245904-338-341632512420.0021563234.0010314545.00615-227-1245904-338-341625559999.00904-445-2719216 Morton Rd., Stetson, FL 3015556850000.001. 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 wouldyou 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, orzip code, how would you alter the file structure?4. What data redundancies do you detect? How could those redundancies lead to anomalies?

Since this question has multiple subparts only the first three will be answered according to the…

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?

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?

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

See similar textbooks

Similar questions

Playback Features allow the user to control the content and flow of information False True
Why is it possible that when you look at a folder's properties, the Security tab is missing from the Properties box?
Why do you need to save a previously saved document after making changes to it?
Why may the Security tab be absent from the Properties box for a folder when you examine its properties?
How-tos for Microsoft Word The paper's name. As a connection, you might provide a hyperlink to an external file.
Mask is a number that is used to influence the form of another number.
Walsh Codes: What are they and how do they work? Kindly indicate the codes that will be used to transfer nine users' data.
Area plots are unstacked by default. Select one: O True O False
In order to freeze the panes for both the row and first column of the worksheet, which cells, rows or columns should you select? 1 2015 - 2018 Enrolment Data Name Gender Department Enrolment date 4/12/15 12/2/15 2/23/16 5/5/18 Mail address 3 AALIYAH Butler AButler@kennesaw.student.edu AHill@kennesaw.student.edu F Psychology Psychology Finance 4 AALIYAH Hill F 5 AARON Murphy AMurphy@kennesaw.student.edu AClark@kennesaw.student.edu ARamirez@kennesaw.student.edu AThomas@kennesaw.student.edu ABailey@kennesaw.student.edu ABaker@kennesaw.student.edu AEdwards@kennesaw.student.edu AGonzales@kennesaw.student.edu AGreen@kennesaw.student.edu AGriffin@kennesaw.student.edu AMoore@kennesaw.student.edu M 6 ABIGAIL Clark Finance 7 ABIGAIL Ramirez 8 ABIGAIL Thomas Economics 7/2/16 2/28/18 10/10/16 8/1/16 8/2/16 5/6/18 7/10/16 9/20/17 10/18/17 Management Management Psychology Finance F 9 ADA Bailey F 10 ADA Baker F 11 ADA Edwards F Psychology Psychology Economics 12 ADA Gonzales 13 ADA Green 14 ADA…
The purpose of a file extension in your document must be distinguished from its appearance.
Microsoft Word guides Title the document. You may link to a file.
Users may input data through the command line instead of the GUI.