Problem Solving with Computers (CS 135)
Dr. William J. Joel, WS 110, 7-9353

Project No. 4 (12 points)

Problem

 You have been asked to gather data from current WestConn students, and create a report, that answers the following questions:
  • Which majors require at least 10 hours of homework per week?
  • Which major courses, on average, have textbooks that cost at least $150 per course?

Task
  • For each question, develop a list of attributes that will answer the question.
  • Convert each attribute into one or more record fields, specifying for each field a name, data type and length.
  • Create a questionaire to gather this data, and have at least 20 WestConn students (other than members of this class) complete the form.
  • Create a MS Access database based on your list of fields, and enter the data you've collected.
  • Create a query for each question, and present the result of each query as a final report.
  • Submit your ...
    • List of attributes
    • List of subsquent fields (name, data type, length)
    • A blank copy of your survey
    • A report that represents a "dump" of all data collected, and
    • A report that answers each question

Notes
  • Your 20 students must represent at least four (4) distinct majors.
  • Feel free to do more than what is asked above. You will neither lose nor gain points for the extra work.
  • You may include an accession number field in order to insure unique records.