MCS-Advisor Project

• TODO

  • Functions to be Created
  • Create Schedule and View
  • Student & Faculty Pages
  • User Lists
  • JSP Flow Chart
  • Code Course SQL
  • Determine Requirements
  • Start Coding
  • Analyze Database structure
  • Update Website
  • Class Diagram

• Design Documents

  • Problem Statement
  • Use Cases
  • Use Case Scenarios
  • Class Diagram (DIA format)
  • Class Diagram (PNG format)
  • Use Case (DIA format)
  • Use Case (PNG format)
  • Database (DIA format)
  • Database (PNG format)
  • JSP Flow Chart (DIA format)
  • JSP Flow Chart (PNG format)

• Mockup

  • Main Mockup Page

  • Administrator Pages

    • Manage Users
    • Manage Administrators
    • Manage Faculty
    • Transfer Advisees
    • Manage Courses
    • Error Screen

  • Faculty Pages

    • Manage Advisees
    • Edit Student
    • Delete Advisee
    • View Schedule
    • Transfer Advisees
    • Error Screen

  • Student Pages

    • View Schedule
    • Edit Schedule
    • Edit User Data
    • Manage Exemptions/Transfers

  • Misc Pages

    • Requirements
    • Edit Schedule (Main Frame)
    • Create Schedule (Main Frame)

• Javadocs

  • Javadocs

Functions to be created

In QueryHandler:
-- Person getAdvisor(String username): Takes students username and returns their advisor
-- Person[] getAdvisees(String username): Takes advisor username and returns array of advisees
-- void updateAdvisee(String new_advisor_uname, String student_uname, String old_advisor_uname):Takes advisor username, student username, and old advisor username, and updates the database
-- void insertAdvisee(String advisor_uname, String student_uname): Takes advisor username and student username and creates advisor/advisee relationship
-- void removeAdvisee(String student_username): Takes a student username and deletes the entry in the database

Create Schedule and View

Take the selections from editschedule.jsp and add them to the database, then have them viewable from viewschedule.jsp

Student and Faculty Pages

Create the Student and Faculty pages, complete with working schedules.
Faculty: Tony and Josh
Students: Benn and Ben

Student, Faculty, Admin, Advisee, Course lists

Create all the lists to which users will be added or removed

JSP Flowchart

Diagram of how users will navigate the site
Dia | Png

Code Course and Advisor SQL

Code the left-hand pane of the createschedule page
Assigned to Ben's
Advisor page assigned to Tony/Josh

Determine how Requirements are handled

Figure out how requirements will be handled in the database, or in the code logic

Start Coding Classes

Start putting in the easy bits, record structures and such.

Analyze Database Structure

Tony got a good start, we have the courses and prereqs table and all the courses in it, we still need others though:
Schedule Table
etc...
Also, we need to actually write this stuff down, maybe use a DIA diagram
*edit* Database specs available here (DIA) (PNG)
Sql for creating tables

Update Website

The website is much cleaner and easier to navigate now, let Benn know if you have suggestions

Class Diagram

We came up with all the classes that we should need, now we need to concentrate on database design and perhaps start coding
The classes can be found here.