University of Wisconsin - Parkside

Department of Computer Science

CSCI 380 Database Management Systems

Fall 2011


Instructor J. U. Quevedo
Textbook Database Management Systems,
by Raghu Ramakrishnan and Johannes Gehrke.
McGraw-Hill; 3rd edition (2003)
Syllabus Fall 2011

Check your grades in D2L

Assignments
Homework #1
Due on 9-14-11
Exercises 1.1,  1.5, and 1.6

Homework #2
Due on 9-30-11

Homework #3
Due on 10-19-11

Programming Assignment #1
Due on 10-12-11
Design two Oracle DB that correspond to exercises 2 and 6 from the DB package A. Submit your create table, insert into statements and personal experiences in the corresponding D2L drop box. Be sure that appropriate  integrity constraints are included in your statements. Populate your tables with at least 5 valid tuples per table.

Programming Assignment #2
Due on 11-7-11

Programming Assignment # 3

Due on  12-07-11

Write a non-trivial JDBC  application to connect to one of your Oracle databases.

Example 1

Example 2

Example 3

Example 4

Introduction to JDBC - The Stanford University InfoLab

Trail: JDBC(TM) Database Access (The Java™ Tutorials)

JDBC Tutorial for the CS lab

Submit a report that includes code, sample executions and learning experience




Resources
ORACLE
Oracle 10g Express Edition
Web Interface SSH connection
Using the Oracle Bulk Loader
Example on using using Oracle Bulk loader
SQL PLUS
Date Lecture documents
9-7-11 Syllabus, Database concepts, History of DB, homework #1 given in class
9-14-11 Rules of Relational DB, E-R model
9-21-11 Sample E-R diagrams, E-R transformations into relations
9-28-11 More on E-R, Oracle Lab
10-5-11 Answers to exercises 2, 3 and 6 from package A
Oracle tables, some PL/SQL,  relational algebra
lab2
10-12-11 Relational Algebra: Division, more on integrity constraints, SQL
10-19-11 More on SQL
Exam 1
10-26-11 More on SQL
E-R terminology conventions
lab3
11-2-11 PL/SQL
lab4
11-9-11 Triggers
lab5
11-16-11 JDBC, Normalization
11-23-11 No Classes - Thanksgiving break
11-30-11 Normalization
Notes
Exam 2
12-7-11 Normal Forms
12-14-11 BCNF and 3NF Normalization