Homework 3
Due: November 8, 2005
Write a Java program that
1. Creates 3 Oracle Tables:
Student(ID, LastName, FirstName, Address, Phone)
Course(ID, Title, Semester, Year, Instructor)
Enrollment(Student.ID, Course.ID, Semester, Year, Grade)
2. Insert 3-3 tuples into Student and Course relations, and 7 tuples into Enrollment.
3. List the content of each relation (results of Select * from Student; Select * from
Course; Select * from Enrollment;)
4. Perform the following actions:
a. Prompt the user for a student name and list the Instructors of that student.
b. Prompt the user for a student name and course ID, Semester and Year and
list the student’s name, course title, and grade.
c. Calculate and list the GPA for every student.
Submit: Create a .zip file and send electronically to the TA and [email protected] the
followings:
1. Output of your program
2. Java source code (TA will compile and run the code, so include any additional
info needed for running it.)
