Transcript The Relational Model - University of Houston

COSC 3480 Projects &
Homeworks
Fall 2003
Conceptual
Relational
Schema Design Learn how to Database Design
Data Mining
define tables
Decision Trees
ODL/OQL
Clustering
basics
Learn how to load
and create an
Oracle database
PL/SQL PL/SQL
PL/SQL Functions Triggers Cursors
Procedures and Packages
Oracle8/9i
MS SQL 2000
Analysis Server
OLAP
Data Warehousing
Learn how to
Learn how to write
define user
Developer 2000
complex SQL Queries
views
Generate SQL Plus Datablock Forms
Learn PL/SQL
reports
Developer
basics
2000 reports
Object-Relational features
Support for XML Java/C++ Interfaces
Lab 2003 Activities
COSC 3480 Lab Projects I
 There will be 6 lab projects; 5 will be programming projects,
one will be a design project.
 The TU/TH Lab (Sessions 5:30-7:00p) in 200 PGH
 Instructor Aditya Toomula
 The lab sessions will be help in 200 PGH; that host 45 standalone computers that are connected to the internet (no
floppy, no CD).
 Vision: Usually, there will be a short lecture and then
students will be given a task that is similar to the tasks in
the 6 lab projects and each student tries his best to solve the
task on his lab computer.
 Moreover, sometimes the will be just QA-sessions; other
activities include discussions of homework / exams,
student presentations, makeup classes during the lab time;
occasionally, there will be no lab at all. A lab schedule will
be available on the web soon.
Elements of COSC 3480, Christoph F. Eick
COSC 3480 Lab Projects II
 Lab projects can be performed by accessing the departmental
Oracle server; accounts are currently created. It is also okay, if
you install Oracle 8i, 9i, 8.17 on your own computer and
perform the projects on your own computer.
 As I know the “short lecture-do_tasks_on_lab_computer”
approach will be used the first time when teaching COSC 3480;
therefore:
 There likely will be problems at the beginning; it is not
100% certain if what I /we have in mind will work.
 Your feedback is appreciated.
 We might adapt our teaching approach based on
experiences in the first lab sessions.
The lab sessions will hopefully start on Tu.,
September 9.
Elements of COSC 3480, Christoph F. Eick
Announcements