COSC 3480 News and Activities Spring 2006

1
COSC 3480News and ActivitiesSpring 2006
2
COSC 3480 Tentative Schedule

• Exam1 Tu., Feb. 28, 2006
• Exam2 Th., April 6, 2006
• Final Exam ??, May ??, 2006 (see catalogue)
• Lab starts on Tu., January 31, 2006

3
News and General Information

• Reading the textbook in the first week of
  February 2006
• Read Chapter 1 of the textbook (covers
  introductory material we discussed in January)
• Read section 3.1, 3.2, and 3.3 (how define
  relations, constraints,? useful for the lab)
• Read sections 5.1, 5.2, 5.3 and Section 4.2 (this
  is what will be covered this week)
• Access http//www2.cs.uh.edu/ceick/3480.html
• regularly

4
Announcements and Discussion

• Huiyuan (Cindy) Ma will be teaching the COSC
  3480 Lab
• The COSC 3480 starts on Th., January 26, 2006 at
  830a in 376 PGH
• The lab is subdivided into lab exercises and lab
  projects
• Lab exercises you perform during the lab time
  the are a preparation for the lab projects, and
  have to be submitted to the lab instructor,
  usually at the end of the lab session
• Lab projects have to be submitted at a specific
  deadline.
• About 10-15 of the credit associated with the
  lab are allocated for lab exercises and 85-90
  are allocated to lab projects.
• The lab will be held regularly through end of
  March 2006, and less regularly in the last 4
  weeks of the semester.
• There will be no lab on days when there is a COSC
  3480 exam
• There will a makeup class and no lab on Tu.,
  March 7, 2006
• Program demos for Project5 will be held during
  the lab time.

5
Lab Project Preview

• Project 1 Defining Relations 1 week
• Project 2/3 Writing SQL queries 2 weeks
• Project 4 Views, PL/SQL, triggers, report
  generators, 3 weeks
• Project 5 Database design, creating a database
  application, C interface to Oracle, updating a
  database, designing user interfaces 4 weeks
• Project 6 TBDL 1 week

6
Relationship of Lab to Other Elements of the
Course

• Lab and Lecture/Exams/Homeworks are complementary
• Topics covered in the lab but not in the class
• PL/SQL
• Triggers
• Database Programming
• How to use a DBMS
• Object-relation features of Oracle
• Topics covered by both class and lab (but
  complementary)
• Relational data model
• Database Design
• Writing SQL queries
• Data Cubes and the Multi-dimensional Data Model
• Topics covered in lecture only
• Relational Algebra
• Entity-Relationship Data Model
• Writing SQL Queries

7
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
Other DBMS (Access/Server 2003
MS SQL 2000 Analysis Server
PL/SQL Triggers
PL/SQL Cursors
PL/SQL Functions Procedures and Packages
OLAP/Data Cubes
Oracle9i
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 2006 Activities