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

Project No. 5 (7 points)

Problem

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

Task
  • For each question, develop a list of data descriptions (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 questionnaire to gather this data, and have at least 20 WestConn students (other than members of this class) complete the questionnaire.
  • 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 subsequent fields (name, data type, length)
    • A blank copy of your survey
    • A report that represents a "dump" of all data collected, and
    • Reports that answers each question

Notes
  • 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.