CSCI 5333 DBMS
Spring 2012
Homework #1

Due: February 8th (Wednesday)

For the homework assignment Web-based Technical Institute DB, use either a CASE tool, such as ArgoUML, or Visio, to construct the followings:

(1) a reasonable top level use case diagram for the project, and
(2) a reasonable top level class diagram for the project. In the minimum, you should include documentation for classes. Attribute and association documentation are optional, but they are encouraged when they are not trivial.

For Visio's users, here is a good and a bit dated tutorial.

Save your files as <<lastname>>_h1_usecase.extension, <<lastname>>_h1_class.extension and <<lastname>>_h1_documentation.docx email them to the TA for grading. The last file contains any additional documentation and description.

Web-based polling system

A drastically simplified Web-based polling system includes a user module and an administrator module.

The voting system displays a sequence of questions for the members of the community to vote on. 

The user module allows the members to:

• vote on a survey question
• write comments on a survey question
• read the voting result of a survey question
• read comments written by the community, and
• rank the quality of a survey question.

For the user to vote, he needs to register to become a member first. Mandatory information includes an unique account name, a password, a nickname and an email address. Optional information includes sex and birth year.

By default, the members can only vote on the active question, which is the only open question. All other questions are closed for voting. It is usually the most recent question set. However, the administrator can set a previous question to be the active question. The members can see the result of any previous questions.  Usually, the most recently set question is the current question.  Voting results are displayed by suitable graphics.  For each question, there should be a sophisticated comment reader which displays the latest comments first. Members can post comment and rank the quality only on the open question. The quality ranking has a value of 1 to 5.

The administrator module is password protected.  There may be more than one administrators.  The database should store the name and email address of every administrator.  An administrator can create the username and account of another new administrator.  An administrator can set survey questions.  There are many utilities that the administrator may use.  For example, an administrator may want to see all questions set by himself in a chronological order.  A voting problem consists of a question and as many choices as the administrator like. The administrator may specify the display order of the choices.  When setting a voting question, the administrator may specify tags associated with the question.  The members and administrator may then search all voting question according to these key words.