Project Information

  • NEW INFORMATION: The due date is now Friday 3rd May at 2pm. The 14 commands have been broken down into two parts. 10 of them are required and 4 will be worth extra credit. Each command is worth 10 points for a total of 100 points and 40 extra points. There required commands are:
    1) authenticate
    2) register
    3) deregister
    4) getgrades
    5) getregistered
    6) getenrolled
    7) setgrade
    10) endsemester
    12) classinfo
    14) endsession

    The following will be extra credit:
    8) userinfo
    9) courseinfo
    11) classroster
    13) olap

  • Groups: Group.TXT.

  • Detailed project requirements: PROJECT.TXT .

  • The input format for the project: INPUT.TXT .

  • Sample input file and database for the project: ProjectDB.TXT .

  • A FAQ is available (MUST READ): Project FAQ.

  • If you need to see what functionality is supported by ProC/C++ check out the ProC/C++ programmer's guide at http://desktop.msfc.nasa.gov/oracle815doc/server.815/index.htm

  • I have removed the section information from the input database. All classes will be only one section, so no section field is required.

  • For AUTHENTICATE the format has been changed to take id and password.

  • In the sample DB I have changed Instructor Name to Instuctor ID in TEACHING.
  • The PROFESSOR and COURSEINFO have been added

  • The format of the sample input file has been updated. All comments begin with #, they can be ignored when you process the file. The database will be given first and then the input commands, exactly in the format shown.

  • Your program must take as input a file name and do all processing using that file (which will have the db and commands). I'll run your code using the following format: ProgramName InputFileName

  • Once you have reached the end of the the input commands, you should drop all tables, so that I can rerun your code with a different inputfile if need be.

  • A C++ makefile for unix is now available. See the directory makedir and copy all files in the dir. Replace your target in place of cppdemo1 and then type "make cppsamples".

  • Check out Jeff Ullman's page on oracle for some reference/features.