COSC 3480 DESIGN OF FILE AND DATABASE SYSTEMS
Prof : Dr. Christoph F. Eick
Lab Hrs : Tu,Th 5:30pm - 7:00pm @ 200PGH
E-mail: taditya@cs.uh.edu
You can download Oracle Personal Edition from here.
Installation Instructions for Oracle Personal Edition.
You can have access to Oracle in PGH 3rd floor and 5th floor labs.
Note:
Lab sessions will be awarded 7-12% of the points assigned for the homeworks and lab assignments.
Everyone should have atleast 80% lab attendance.
Checkout the Lab Schedule.(updated 11/03)
LAB#1 (09/09)
LAB#2 (09/11)
LAB#3 (09/16)
Here is Oracle-Task1 which is due on Sept. 23, 2003.
Some Tips for Project1.
Due date for Oracle-Task1 has been pushed back to Thu, Sept 25 due to the problem with accessing SQL Plus Client. Submit the hardcopy of all the commands and corresponding results to me on Thursday's class by 7:00 pm.
Lab#4 (09/23)
Lab#5 (09/30)
bestRental_Lab2.sql file can be found here.
Turn in your softcopy(only SQL code) of Oracle-Task2 by Thu., 7:00pm thru e-mail (To: taditya@cs.uh.edu) and hardcopy(SQL code and corresponding results) by Thu., 5:30 pm in 200PGH.
Some Clarifications on Task2.
Lab#6 (10/14)
Turn in your softcopy(only SQL code) of Oracle-Task3 by Tue., 5:30pm thru e-mail(To: taditya@cs.uh.edu) and hardcopy(SQL code and corresponding results) in the lab.
I will be available in 527 PGH on Monday(10/20) between 3-4pm.
PL/SQL
Lab#7 (10/21)
Lab#8 (10/23)
Solutions to Lab#8 exercise.
Lab#9 (10/27)
Solution to Lab#9 exercise.
Solutions to Oracle Task#2
Solutions to Exam1--A and Exam1--B.
Turn in your softcopy(only PL/SQL code and the prgm to test them) of Oracle-Task4 by Thu.(11/06), 11:00pm thru e-mail(To: taditya@cs.uh.edu) and hardcopy(PL/SQL code and corresponding results) in the lab on Tue.(11/11).
PRO*C
Lab#10 (11/13)
Download oracle Pro*C/C++ from here.
Before downloading be sure to check the installation instructions.
Instructions on how to link the Microsoft Visual C++ with Pro*C libraries after successfully pre-compiling the Pro*C code.
Oracle Lab#6 Report is due on Thu. Dec 4th in the class.
Lab#6 demos are scheduled on Dec 2nd (with 5% bonus), Dec 8th and Dec 9th. Check the lab schedule for the time window on these days.
Please schedule your demos by emailing me your preferred day(of the above three) and time by Thu, Dec 4th. I will send you the allotted time slot of your demo.
Final Demo Schedule (updated 11/08)
All the demos will take place in 376 PGH. It is open only for the demo purpose. Please be present in the lab 10 minutes before your scheduled time slot.
Solutions to Exam-2
I will be holding my office hours on Tuesday(Dec 16th) between 10:30am and 11:30pm.
Office:527 PGH