CS 178: Final Project Demo and Evaluation

Please follow the instructions below. Failure to follow these instructions may result in your project not being graded completely.

You are required to submit your source code and report using blackboard – create one zip file containing the (1) code, (2)report and (3) login information, and submit this zip file. Each team must submit one zip file – i.e., individual members do not need to submit separately. The deadline for submission is May 5^th 2pm – no extensions.
Note that, in addition to the report, you must submit a one page login information document in your submission that provides the following information (which we will need to conduct our testing):

Set up your fully functional project and provide us with the URL.
Provide us with the usernames and passwords for the different users in the system (i.e., the Grad Sec –GS role, faculty reviewer, faculty advisor, instructor, chair, sys admin, applicants, students, alumni.)

You must bring a copy of this login information document with you to the final demo.

If you fail to provide us with this information, we cannot test your project user interface and will be forced to give a zero grade on Phase 3.

The reset will bring your database to a starting state (i.e., erase all the data and populate it with the data specified below in this document). The reset is nothing but a bunch of delete statements followed by insert statements.

Make sure the following IDs and names are not in your database since we will be using these in our testing:

As part of the project requirement you MUST have the courses and timeslots specified in the course schedule provided to you. This is specified in the project details.

Make sure you use the same course numbers, course IDs, and course schedule times (day and time).
There is no gap required between classes; i.e., you MUST allow students to register into a 3-6pm timeslot and a 6-9pm timeslot on the same day.

Database Starting state – this is the state that you must get to after a Reset operation.

Course schedule: your course registration schedule must be exactly as we specified in the project.
Applicants: There must be two applicants entered into the system with the student numbers and other data as specified below:

Students: There must be two students entered into the system with the student numbers and other data as specified below:

Paul McCartney, 333-11-1111. Has registered and completed the 10 courses (CS210, CS211, CS212, CS241, CS242, CS232, CS233, CS283, CS286, CS220) and received 5 A’s and 5 B’s on these courses. They have NOT applied for graduation.
George Harrison, 444-11-1111. Has registered and completed the 9 courses and received the grades in the list below:

CS210: B, CS211: B, CS212:B, CS 232:B, CS233:B, CS 241: B, CS242: B, EE244: C, CS283:B (i.e., all B’s except for a C in EE244).

Alumni: There must be one alumni entered into the system with the student numbers and other data as specified below

Eric Clapton, 555-11-1111. Has completed 10 courses and received grades in the list below, and graduated 2006 with a Masters degree

CS210: B, CS211: B, CS212:B, CS 232:B, CS233:B, CS 241: B, CS242: B, CS 283: A, CS 286:A, CS254: A.

Others: Create Grad Secretary (GS), Faculty reviewer named Narahari, Faculty advisor named Price Jones, Instructor (whatever names you have, but give us their info), Chair Admissions Committee (CAC), and the database admin. You must have at least two faculty reviewers, at least two advisors, and at least two instructors -- and at least one of them must have all three roles (for example, Narahari can be faculty reviewer, advisor and instructor).