CSI 4335 Syllabus

Objective:

An "A" level student will

design a database system for a modern enterprise;
implement a database system;
present a component of the implementation;
demonstrate knowledge of database design fundamentals;
demonstrate knowledge of advanced database concepts.

Instructor:

Texts:

The primary text for the course is Database Systems Concepts by Silberschatz, Korth and Sudarshan. Supplemental materials on PHP, Java, JDBC, etc. will also be helpful. The text, SQL : A Practical Guide for Developers is also helpful. Some practice tables.

Nice Oracle Tuning wiki

Evaluation:

Students will be evaluated based on three exams and a course project. The exam average will be 50% of the grade, with the comprehensive final exam counting 20% of the grade. The project will be a group effort and will count 50% of the grade. The project will have a design, implementation and presentation component. Inidvidual grades will be based on the overall team performance and the individual contribution to the project. The project will be completed on the lab computers in the SPL lab, 212.

Graduate Credit:

Students taking this course for graduate credit must also complete a research paper on a topic related to database design. Potential topics include ORM, workflows, or advanced normalization theory. Topic selection will be mutually agreed upon by the gradaute student and myself. The paper must be between 4000-5000 words, written in LaTeX and have at least 10 references. The paper will be graded on a pass/fail basis. If the paper does not pass, the student will be given additional chances to improve the work. If the paper does not pass by the end of the semester, the student cannot receive more than a C in the course.

Teams

Name	Members
MacroSoft	Brett Phillips, David Romeo, Kevin Rooney
Taurus	Justin Ball, Brandon Crouch, Jeremy Love, Bobby Martin

Schedule

The course meets from 2:00-3:15 Tuesday and Thursday, and from 6:00-9:00 on Tuesday nights. The Tuesday night classes will not always require the entire 3 hours.

Thanksgiving

Time Topic Text Reading Project Work

Week 1 ER Model
Functional Dependenciers Chapter 6
Section 7.4 Problem Description

Week 2 Normalization Theory Chapter 7 (7.1-7.5)
Simple Conditions for Guaranteeing Higher Normal Forms in Relational Databases Oracle Installation

Week 3 SQL
Exam I, Sept. 9 Chapter 3 Drew Pittman

Week 4 Advanced SQL
Indexes Chapter 4
Chapter 12.1-12.3 & 12.10 Initial Database Design

Week 5 Web/DB Applications
Slides
Intro to ORM Chapter 8
Stored Procedures Prototype

Week 6 Query Processing
Exam II, Sept. 30 Chapter 13

Week 7 ACID
Data Mining Chapter 15.1-15.4
Section 18.4

Week 8 OLAP & Information Retrieval Section 18.2
Chapter 19
Google Hack? Final Database Design

Week 9 Review
Final Oct. 21 Note! Time change for final exam has been approved by Dean Kelley.
Week 10 Simulation Testing

Week 11

Week 12 Sales Presentation

Week 13 Documentation Deadline

Week 14

Week 15 Technical Reviews

Time	Topic	Text Reading	Project Work
Week 1	ER Model Functional Dependenciers	Chapter 6 Section 7.4	Problem Description
Week 2	Normalization Theory	Chapter 7 (7.1-7.5) Simple Conditions for Guaranteeing Higher Normal Forms in Relational Databases	Oracle Installation
Week 3	SQL Exam I, Sept. 9	Chapter 3	Drew Pittman
Week 4	Advanced SQL Indexes	Chapter 4 Chapter 12.1-12.3 & 12.10	Initial Database Design
Week 5	Web/DB Applications Slides Intro to ORM	Chapter 8 Stored Procedures	Prototype
Week 6	Query Processing Exam II, Sept. 30	Chapter 13
Week 7	ACID Data Mining	Chapter 15.1-15.4 Section 18.4
Week 8	OLAP & Information Retrieval	Section 18.2 Chapter 19 Google Hack?	Final Database Design
Week 9	Review Final Oct. 21	Note! Time change for final exam has been approved by Dean Kelley.
Week 10			Simulation Testing
Week 11
Week 12			Sales Presentation
Week 13			Documentation Deadline
Week 14
Week 15			Technical Reviews