Second Project, CS 643
Due: 6pm Wednesday, May 29, 2002
Total points: 100

You’re allowed to work with another student from CS643 on this project. If two students are working on the project, they’ll share the same grade for the project. It’s their responsibility to ensure a fair share of workload and clear communication between the two partners. An unpleasant surprise from the partner may not be used as an excuse for late submission.

Create an application along with the necessary database that supports the following:

bullet

Only the students, graders, and instructors in CS111 can access the application.

bullet

Allow instructors to submit FAQs, their answers, and practice questions to the database. The types of questions that need to be supported by the project are listed in item 3.

bullet

Allow all eligible users to view FAQs through the application.

bullet

Allow students to work on the practice problems through the application and get instance feedback. The record of practice shall be stored in the database so that instructors can analyze their performance later on.

Deliverables:

Due to the limitation of time, we'll not be able to accomplish the whole application. The following documents need to be submitted on Wednesday, May 29. No handwriting document is acceptable. It is highly recommended that you accumulate the documents throughout the project. 

  1. The Class Diagram for the project. Document the classes (name, attributes, and methods) and the associations (name and multiplicity). I would recommend using Rational Rose to generate the documentation for you.

  2. Use features demanded for this application to explain the advantages of using object-relational database over the traditional relational database.

  3. It is important for students in CS 111 to understand conversions between binary integers and decimal integers. The evaluation of students' response should be handled by the object not by the front-end application. 

    1. Record the SQL statement(s) that are used to create the object type(s) and table(s) for this feature. Remember, the records of all practice should also be saved in the database for possible future statistical analysis.

    2. Record the SQL statement(s) that allow practice problems be inserted into the appropriate table(s).

    3. Record the SQL statement(s) that allow practice problems be retrieved from the appropriate table(s).

    4. Record the SQL statement(s) that allow students' practice be recorded into appropriate table(s). Remember, the correctness of a practice needs to be evaluated by member functions and stored.

  4. Keep in mind that the frequent asked questions in CS111 are often related to how to use computer and how to use certain language structure. Therefore, the answers to the frequent asked questions may include screen shots and programs. Demonstrate that frequent asked questions along with their answers can be stored into and retrieved from the FAQ table. Record necessary steps.

Back to CS643 schedule