Adv. Database programming Midterm project
You are a software consultant. A public relations firm has asked you
to build an application that will help them work with surveys. Here
are their needs
- There must be a way to build new surveys
- Each survey will contain questions that can be answered 1 (strongly
agree) to 5 (strongly disagree)
- The system must also be able to distribute the surveys through a kiosk
or web system. The actual distribution scheme is not important now,
but they want the underlying data structure.
- Each respondent will fill out a form about themselves to be used in
market analysis.
The anticipated users
- survey designer, who will need to be able to build new surveys,
- pollster will set up a survey to be given to a number of respondants
- respondant answers the question
- analyst queries the data
Your mission
Although this is sketchy information, you have been asked to present a
prototype proposal to the company at your first meeting. You will be
meeting with the company president, who is not interested in the
details of data design, and the IT manager, who will be looking for a
well-designed database system.
Present the following information:
- A prototype schema for the database
- A list of tables in 3rd normal form
- A list of views to be provided
- Documentation describing why you designed the data as you did
You need not implement the database in SQL or SQLPlus, but it might
help you find bugs if you do so. We're not interested in the actual
implementation details as much as the soundness of the design. You
may submit your work by email to Andy, or you may put it on a web site,
and email me the address to look at. Please DO NOT send attachments
of access files or other binaries. This is a ten point project, and
the ten points will be added to your exam score.
Have fun!!