1. How many records does the file contain? How many fields are there per record?

Question

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?

Project code Project manager Manger phone manager address project bid price Bid code 26-A John Smith 317-965-5126 1000 John Road, Charlotte NC 28266 168253200.00 1111 27-B Karen Norris 312-589-9685 2000 Karen Ave, Raleigh, NC 27601 125000000.00 2222 28-D Russell Abratt 980-556-8477 3000 Davis Road, Davie, FL 33104 356632410.00 3333 29-E Grorge Johnson 773-737-7866 5000ABerdeen, Chicago, IL 60620 215698624.00 4444 30-F Grorge Johnson 773-737-7866 5000ABerdeen, Chicago, IL 60620 109875457.00 5555 31-G John Smith 317-965-5126 1000 John Road, Charlotte NC 28266 265365699.00 6666 32-H Jane Kilibrew 312-987-8654 7000 Millman Ave, Ralegh, NC 27601 623300450.00 7777

Explanation / Answer

By looking at the given table in problem statement..i analysed the data and answered the these below questions,,

1. How many records does the file contain? How many fields are there per record?

Ans:
   As per given in the table total 7 records are present without duplicate and Each record will contains
   sub files like Project Code..

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?

Ans: If I want to produce the city listing I have duplicate of three cities of these are.
     Charlotte NC, Chicago IL and Raleigh, NC
   So I can overcome this problem by taking the other field of 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?

Ans: If I want to produce the file contents by last name, area code , city or zip code..
      I would use the two file fields called Project Manager and manager address because these two fields
      have the actual data asked in question 3
4. What data redundancies do you detect? How could those redundancies lead to anomalies?

Ans: I have detected the three fields are redundancies these are ..
     Project Manager Filed
   Manager Phone
   Manager Address City..
  
   While doing other fields updates these will leads the conflicts..

Related Questions

Navigate

• Browse (All)
• Browse 1
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.