CIS 4301

Discussion

Oracle 10g Express

Installing this software is not all that hard in linux or Windows, as they both have packages that simply install without too much trouble. One place that I am now finding trouble is with the interface to the linux installation from a linux machine, as there appears to be some sort of java interface that is not quite working right in firefox or mozilla, at least when it comes to editing script inputs.

Handouts / Slides

Foundations

• Chapter 1: Introduction
• Chapter 2: ER Model and Conceptual Design
• Chapter 3: The Relational Model and SQL DDL
• Chapter 4: Relational Algebra and Relational Calculus
• Chapter 5: SQL

Applications

• Chapter 6: Database Applications
• PL/SQL
• Chapter 7: Internet Applications

Other Items

• ER Modeling Exercise

Project

• Project Description

Homework

1. Homework 1
2. Homework 2
3. Solve problem 5.4 from the text. Due on 10/04 in class

Textbook

Database Management Systems, Third Edition
Raghu Ramakrishnan, Johannes Gehrke
ISBN: 0-07-246563-8
Publisher: McGraw-Hill Higher Education
Pub. Date: 2003