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:
Dr. Greg Speegle
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.
| 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 | | | |
| Week 11 | | | Simulation Testing |
| Week 12 | | | Sales Presentation |
| Week 13 | | | Documentation Deadline |
| Week 14 | Thanksgiving | |
| Week 15 | | | Technical Reviews |