CS 327e
Fall 2001
Due: 2001-10-12 Friday 8.30 a.m. in class.
Purpose:
a)
Get
familiar with writing a Java application accessing a database.
b)
Get
familiar with Oracle and SQLPlus.
For this lab, there are 2 parts:
a)
Create
the aviation database in Oracle. Choose appropriate data types for the columns
for each table. Populate the database with appropriate data. You can import
data from MS-access files, if you like. Also, along with the tables, create the
physical PK-FK relationships.
b)
Write
a Java application to
a.
Connect
to the aviation database in Oracle
b.
Retrieve
all rows back from any 1 table into a file, or onto the screen
c.
Disconnect
from the database
d.
You
can use Java along with JDBC driver that comes with the Oracle installation.
Submit:
On a zip disk (or any other electronic medium, as long as it
fits),
a)
All
the SQL text (using SQLPlus) used to create your aviation schema in oracle in
electronic format (say in an ASCII file)
b)
The
SQL data file that contains your physical schema
c)
Java
code for the application
d)
Readme.txt
file explaining any assumptions/constraints/thoughts for the TA
e)
No
paper documents need to be submitted for this lab. Appropriately label your zip
disk.
NOTE:
a)
You
can collaborate with anyone in your class, or outside sources (people, source
code, tutorials etc.) to do this lab.
b)
If I
don’t get the labs setup in time for this Friday’s (2001-10-05) class with
Oracle, I will extend the deadline appropriately. If you have any Qs, email to
the instructor with cc: to TA.