CSc 6710 Homework Assignment 9
Spring 2002; Due: April 12, 2002
-----------------------------------

(1) Convert the ODL design for the gradebook database into an ObjectStore design.
(2) Implement the gradebook application that accesses the ObjectStore database of (1).
    The user interface is shown below (Implement ionly the options shown below - the 
    remaining options will be completed in Assignment 10):
(3) Write a separate Java program that reads a file with the following format (the name
    of the file will be command line input):
      sp02
      5556
      1111 Jones Tony A
      2222 Smith Larry B
      0000
    and enrolls the students in the course mentioned. If the student is already in the
    students extent then only the enrollment should take place otherwise the student
    should be added to the students extent as well as enrolled in the class. We can assume
    that the course object already exists.

[~/jdbc][8:11am] java gradebook
userid  : raj
password: raj
      GRADEBOOK PROGRAM

(1) Add Catalog
(2) Add Course
(3) Add Students
(4) Select Course
(q) Quit

Type in your option:1
Course Number: 6710
Course Title : Database Systems
Added Catalog Entry
      GRADEBOOK PROGRAM

(1) Add Catalog
(2) Add Course
(3) Add Students
(4) Select Course
(q) Quit

Type in your option:2
Term         : sp02
Line Number  : 5556
Course Number: 6710
A Cutoff     : 90
B Cutoff     : 80
C Cutoff     : 70
D Cutoff     : 60
Course was added! Success!
      GRADEBOOK PROGRAM

(1) Add Catalog
(2) Add Course
(3) Add Students
(4) Select Course
(q) Quit

Type in your option:3
ID (0 to stop): 1111
Last  Name    : Jones
First Name    : Tony
Middle Initial: A
ID (0 to stop): 2222
Last  Name    : Smith
First Name    : Larry
Middle Initial: B
ID (0 to stop): 0
      GRADEBOOK PROGRAM

(1) Add Catalog
(2) Add Course
(3) Add Students
(4) Select Course
(q) Quit

Type in your option:4
Term: sp02

5556   6710   Database Systems

Select a course line number: 5556
      SELECT COURSE SUB-MENU

(1) Add Students to Course
(2) Add Course Components
(3) Add Student Scores
(4) Modify Student Score
(5) Drop Student from Course
(6) Print Course Report
(q) Quit

Type in your option:1
Student Id (0 to stop): 1111
Student Id (0 to stop): 2222
Student Id (0 to stop): 0
      SELECT COURSE SUB-MENU

(1) Add Students to Course
(2) Add Course Components
(3) Add Student Scores
(4) Modify Student Score
(5) Drop Student from Course
(6) Print Course Report
(q) Quit

Type in your option:q
      GRADEBOOK PROGRAM

(1) Add Catalog
(2) Add Course
(3) Add Students
(4) Select Course
(q) Quit

Type in your option:q
[~/jdbc][8:13am]