Lab 1

# The University of Texas

CS 327e

Fall 2001

### Lab 2

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.

Home Page