University of South Carolina

Department of Computer Science and Engineering

CSCE 520 – Database Management Systems

Fall 2005

Tuesday, Thursday 11:00-12:15

Swearingen 2A19

Instructor: Csilla Farkas

Office: Swearingen 3A59

Office Hours: Tuesday, Thursday 9:30—11:00 am, electronically, or by appointment

Telephone: 576-5762

E-mail: farkas@cse.sc.edu

Class homepage:http://www.cse.sc.edu/~farkas/csce520-2005/csce520.html

TA: Sen Xu

Office hours: Tuesday 13:30-15:00 and Friday 15:00-16:30

Office: A111, 300Main

e-mail: xu4@cse.sc.edu

Phone: 7-7506

Description

Database management systems; database design and implementation

Prerequisite

CSCE 245 or GEOG 563 or permission of the instructor. Computer Information Systems and Computer Science majors following the requirements from 1999-2000 or earlier may substitute CSCE 240 for CSCE 245. Computer Engineering majors following the requirements from 1999-2000 or earlier may substitute EECE 352 for CSCE 245.

Course Text

H. Garcia-Molina, J. Ullman, J. Widom: Database Systems: The Complete Book, Prentice Hall, ISBN:0-13-031995-3
R. Sunderraman: Oracle 9 Programming, A Primer, Addison Wesley Longman, Inc., ISBN: 0-321-19498-5

Assignments:

§ Research project: there will be one class project. Students work independently to develop a complete database (design, implementation, testing) of a chosen domain.

§ Homework: there will 4-5 homework assignments during the semester. Homework should be individual work. There will be a late submission penalty of 4%/day (including weekends) after the due date. (You can always turn it in early.)

§ Exams: three closed book tests will cover the course material.

Test schedule:

Test 1: September 22 (Thursday)

Test 2: November 10 (Thursday) -- Preparation guide, sample test, another test with solution

TEST 2 Solution

FINAL EXAM: December 9 (Friday) 2:00 pm -- Preparation Guide, Sample final 1, Sample final 2

No Classes on:

October 13 Thurs. Fall break-no classes

November 24Thurs. Thanksgiving recess - no classes

Syllabus

Homework

Homework 1 – due Sept. 6
Homework 2 – due Oct. 18
Homework 3 – due Nov. 8
Homework 4 – due Dec. 1 – Electronic submission to xu4@cse.sc.edu and farkas@cse.sc.edu

Project

Project Specification – If you choose electronic submission of submission must be sent to both farkas@cse.sc.edu and xu4@cse.sc.edu
Project Support: online support materials, sample code, and documentation
Student Oracle accounts are activated. For further info see:

§ https://www.cse.sc.edu -> My CSE Account -> Oracle account

§ http://www.cse.sc.edu/~okeefe/tutorials/oracle_sqlplus/601.html

Project due date: Dec. 5, 2005, 11:00 a.m.

Project demo: Dec. 5 and 6. 8:00 am – 11:00 am -- Schedule – Location: 1D39 (Unix Lab)

§ each student will give a 10 min. demo to instructor

§ you only have to stay for your demo (be ready about 10 mins beforehand – no delays!)

§ sign up sheet during classes Nov. 17, 22

§ location TBA

Lecture Notes

Aug. 18: Introduction to Database Management Systems (slides)

Aug. 23: Entity-Relationship Data Model (slides)

Aug. 25, 30: Relational Data Model (slides)

Sept 1,6: Functional Dependencies (slides)

Sept. 8: Normalization (slides)

Sept.13: Normalization and MVD (slides)

Sept.15: SQL 1. (slides)

Sept.20: SQL 2.

Sept. 22: TEST 1

Sept. 27: SQL 2. (slides)

Sept. 29

-- Oct 13: SQL 3. (slides)

Oct. 18: Triggers, Assertions, Project (Chapter 3 – Oracle 9 Programming)

Oct. 20: HW2 queries, SQL Programming, JDBC Connectivity (support, sample code)

Oct. 25: PL/SQL (Chapter 3 (Oracle 9 Programming) and Notes on Oracle DBMS – PL/SQL)

Oct. 27

Nov. 1: JDBC (Chapter 5 (Oracle 9 Programming) and Notes on Oracle DBMS – JDBC)