Java Program Assignment: Creating Oracle Tables, Inserting Data, and Calculating GPAs, Assignments of Computer Science

A java programming assignment where students are required to create three oracle tables, insert data into them, and perform queries to list student information, instructors, and gpas. The assignment includes instructions for creating a .zip file and submitting the output and source code electronically.

Typology: Assignments

Pre 2010

Uploaded on 10/01/2009

koofers-user-avn
koofers-user-avn 🇺🇸

10 documents

1 / 1

Toggle sidebar

This page cannot be seen from the preview

Don't miss anything!

bg1
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.)

Partial preview of the text

Download Java Program Assignment: Creating Oracle Tables, Inserting Data, and Calculating GPAs and more Assignments Computer Science in PDF only on Docsity!

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:
  5. Output of your program
  6. Java source code (TA will compile and run the code, so include any additional info needed for running it.)