Fall 2008
Instructor: Dr. Markus Schneider
Tuesdays: 7th period (1:55 pm - 2:45 pm)
Thursdays: 7th & 8th period (1:55 pm - 2:45 pm, 3:00 pm - 3:50 pm)Lectures are held in room CSE E118.
Tuesdays: 1:00 pm - 1:45 pm
Thursdays: 1:00 pm - 1:45 pm
and by appointment
Name: Mingsong Chen
Email: mchen@cise.ufl.edu
Office hours and location: Fridays from 9:00 am to 11:00 am, room E309Name: Wenjie Yuan
Email: wyuan@cise.ufl.edu
Office hours and location: Wednesdays from 2:00 pm to 4:00 pm, room E309
Syllabus (last update: November 4, 2008)
| [EN04] | R. Elmasri & S. B. Navathe. Fundamentals of Database Systems. Addison Wesley, 5th edition, 2007, ISBN 0-321-36957-2. (required) |
| [SKS06] | Abraham
Silberschatz, Henry F. Korth & S. Sudarshan. Database System
Concepts. McGraw Hill, 5th edition, ISBN
0-07-342177-4 (recommended). |
| [CB05] | T. Connolly & C. Begg. Database Systems - A Practical Approach to Design, Implementation, and Management. Addison Wesley, 4th edition, 2005. (recommended) |
| [GUW02] | H. Garcia-Molina, J. D. Ullman & J. Widom. Database Systems: The Complete Book. Prentice Hall, 2nd edition, 2008. (recommended) |
| [KBL06] | M. Kifer, A. Bernstein & P.M. Lewis. Database Systems - An Application-Oriented Approach. Addison Wesley, 2nd edition, 2006. (recommended) |
| [RG03] | R. Ramakrishnan & J. Gehrke. Database Management Systems. McGraw-Hill, 3rd edition, 2003. (recommended) |
| [Ric04] | C.M. Ricardo. Databases Illuminated. Jones and Bartlett Publishers, 1st edition, 2004. (recommended) |
| [Zlo77] | M. M. Zloof. Query-By-Example: A Data Base Language. IBM Systems Journal, 16(4):324-343, 1977. [pdf] |
|
Date |
Lecture Topic |
Slides |
Readings* |
Comments |
|---|---|---|---|---|
| Tu 08/26 |
Preliminaries, structure of class, introduction | Lecture 01 | Chapter 1 |
|
| Th 08/28 |
File management vs. database management, database terminology, data model | Lecture 02 | Chapter 2 | |
| Tu 09/02 |
Three-Level Model, data independence, software architecture of a database management system, introduction into Oracle (I) | Lecture 03 | ||
| Th 09/04 |
Introduction into Oracle (II), Entity-Relationship Model (I) | Lecture 04 | Sections 3.1-3.7, 3.9 | Homework 1 |
| Tu 09/09 |
Entity-Relationship Model (II) | Lecture 05 | Sections 4.1-4.2 | |
| Th 09/11 |
Entity-Relationship Model (III), Relational Data Model, some basic mathematical concepts | Lecture 06 | Sections 5.1-5.2 | |
| Tu 09/16 |
Key concept, transformation of an ER diagram into a database schema (I) | Lecture 07 | Chapter 7 | Project Deliverable for Phase 1 due before class |
| Th 09/18 |
Transformation of an ER diagram into a database schema (II), Relational Algebra (I)
|
Lecture 08 | Sections 6.1-6.2 | |
| Tu 09/23 |
Relational Algebra (II) | Lecture 09 | Sections 6.3-6.4 | Homework 1 due
before
class (Sorry, no late policy this time!) Homework 1 Solutions Homework 2 |
| Th 09/25 |
Exam 1 (Solutions) | |||
| Tu 09/30 |
Relational Algebra (III) | Lecture 10 | Section 6.5 | Project Deliverable for Phase 2 due before class |
| Th 10/02 |
Relational Algebra (IV), Relational Calculi (I) | Lecture 11 | Section 6.6-6.7 | |
| Tu 10/07 |
Relational Calculi (II) | Lecture 12 | Homework 2 due
before
class Homework 2 Solutions Project Deliverable for Phase 3 due before class Start of P roject Phase 4: System Implementation Homework 3 |
|
| Th 10/09 |
Multi-relations, SQL (I) | Lecture 13 | Section 8.1 | |
| Tu 10/14 |
SQL (II) | Lecture 14 | Sections 8.2-8.4 | |
| Th 10/16 |
SQL (III) | Lecture 15 | Section 8.5 |
|
| Tu 10/21 |
SQL (IV) | Lecture 16 | Section 8.8 |
Homework 3 due
before
class (Sorry, no late policy this time!) Homework 3 Solutions |
| Th 10/23 |
Exam 2 (Solutions) | |||
| Tu 10/28 |
SQL (V) | Lecture 17 | Sections 8.6, 8.9 | Homework 4 Project Checkpoint 1 |
| Th 10/30 |
SQL (VI), QBE | Lecture 18 | Appendix C, QBE paper | |
| Tu 11/04 |
Design Theory (I) | Lecture 19 | Sections 10.1-10.2 | |
| Th 11/06 |
Design Theory (II) | Lecture 20 Ganesh's slides |
||
| Tu 11/11 |
Veterans Day | |||
| Th 11/13 |
Design Theory (III) | Lecture 21 | Sections 10.3-10.6 | Homework 4 due
before
class Homework 4 Solutions Homework 5 |
| Tu 11/18 |
Design Theory (IV) | Lecture 22 | Project Checkpoint 2 | |
| Th 11/20 |
Data Integrity (I) | Lecture 23 | Section 1.6.8, 5.3 | |
| Tu 11/25 |
Data Integrity (II), Application Programming (I) | Lecture 24 | ||
| Th 11/27 |
Thanksgiving Day | |||
| Tu 12/02 |
Application Programming (II) | Lecture 25 | Sections 9.1-9.5 | Homework 5 due
before
class (Sorry, no late policy this time!) Homework 5 Solutions |
| Th 12/04 |
Exam 3 | |||
| Tu 12/09 |
Project Demonstration | |||
* Readings should be completed before the lecture to which they correspond. The tags in brackets refer to the publications in the Required Readings section.