COSC 3480 Projects

1
COSC 3480 Projects HomeworksFall 2003
2
Conceptual Schema Design
Relational Database Design
Learn how to define tables
Data Mining
Decision Trees Clustering
ODL/OQL basics
Learn how to load and create an Oracle database
MS SQL 2000 Analysis Server
PL/SQL Triggers
PL/SQL Cursors
PL/SQL Functions Procedures and Packages
OLAP
Oracle8/9i
Data Warehousing
Learn how to define user views
Learn how to write complex SQL Queries
Developer 2000 Datablock Forms
Generate SQL Plus reports
Learn PL/SQL basics
Developer 2000 reports
Object-Relational features
Java/C Interfaces
Support for XML
Lab 2003 Activities
3
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 530-700p) in 200 PGH
• Instructor Aditya Toomula
• The lab sessions will be help in 200 PGH that
  host 45 stand-alone 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.

4
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_compu
  ter 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.

5
Announcements