- Display the classes currently taken by student X
- Display the roster of class Y
- Produce the grade report of student X
- Assist an undergraduate student X in figuring out remaining degree requirements for a bachelors in Y
- Assist a student X in producing his class schedule
- Assist a professor X in scheduling a review session for a section Y offered in the current quarter during the time period from B to E
- Grade distribution for past iterations of a course Y offered by professor X
Update student's grade in a class
Add a new section to the course CSE 15L
Get grade report for several students enrolled in the current quarter
- Download (PostgreSQL) DBMS
- Apache Tomcat server (link)
- Java Server Pages 2.1 (link)
- PostgreSQL JDBC Driver (link)
- run
deploy.sh
(a script i wrote to build project and start the tomact server) - open http://localhost:8080/tritonlink/
Course Entry Form: Provide forms that prompt for course data, one at a time, and appropriately insert them into the database. Course data include prerequisite information.
Class Entry Form: Provide forms that prompt for class data (excluding the list of students who are taking the class) and insert them into the database. Classes will have to refer to courses you have already entered.
Student Entry Form: Forms, again. Exclude information about the classes that the student takes or has taken, the probations he may have received, and his committee info. They will be covered by forms described below.
Faculty Entry Form
Course Enrollment: Provide a form that allows us to insert in the database that student X takes the course Y in the current quarter. If the course has multiple sections prompt for section. If the course is flexible on the number of units prompt the student for the number of units he wants to take.
Classes taken in the Past: Provide a form that allows us to insert in the database that student X took the course Y in quarter Z. If the course has multiple sections prompt for section. Also, ask for the grade G of the student.
Thesis Committee Submission: Provide a form that allows graduate students to submit their thesis committee.
Probation Info Submission
Review Session Info Submission
Degree Requirements’ Info Submission