Write a C Program which reads the contents of the attached sequential file - customers.txt Print the surname of people who agreed to share their data. This is denoted by the final field in the file (1 for agree, 0 for not agreed). Print the average age of these people (age is the 4th column in the data) Print the average age for people who live in Dublin and have agreed to share their data. This is denoted by the first field in the file.   customers.txt  New York    Dunne        865463389    21    1 New York    Milford    865438990    22    0 New York    Mowlds    876765443    24    1 New York    Wang        873456789    22    1 New York    Smith        875432234    25    1 New York    Henry        876654429    22    0 New York    Gupta        896765443    24    1 Los Angeles    Monahan    865432245    22    1 Los Angeles    Brunsdon    865678894    22    1 Alabama    Tyson        865434566    22    0 Alabama    Browne    865564766    20    1 New York    Dunne        890065443    27    1 New York    Connolly    876733999    20    0 Hawaii     Jennings    987645673    60    1 Texas        Wang        876232123    29    1

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
icon
Related questions
Topic Video
Question

Write a C Program which reads the contents of the attached sequential file - customers.txt

  • Print the surname of people who agreed to share their data. This is denoted by the final field in the file (1 for agree, 0 for not agreed).
  • Print the average age of these people (age is the 4th column in the data)
  • Print the average age for people who live in Dublin and have agreed to share their data. This is denoted by the first field in the file.

 

customers.txt 

New York    Dunne        865463389    21    1
New York    Milford    865438990    22    0
New York    Mowlds    876765443    24    1
New York    Wang        873456789    22    1
New York    Smith        875432234    25    1
New York    Henry        876654429    22    0
New York    Gupta        896765443    24    1
Los Angeles    Monahan    865432245    22    1
Los Angeles    Brunsdon    865678894    22    1
Alabama    Tyson        865434566    22    0
Alabama    Browne    865564766    20    1
New York    Dunne        890065443    27    1
New York    Connolly    876733999    20    0
Hawaii     Jennings    987645673    60    1
Texas        Wang        876232123    29    1

Expert Solution
steps

Step by step

Solved in 2 steps with 2 images

Blurred answer
Knowledge Booster
Instruction Format
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
Database System Concepts
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)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education