Database Management Systems (COP 5725)

Database Management Systems

(COP 5725)

Spring 2012

Instructor: Dr. Markus Schneider

Course Information

Time and location of lectures
Office hours
TA information
Course syllabus
Required and recommended readings
Lecture and presentation schedule (incl. dates, lecture topics, presenters, lecture slides, and reading assignments)
Project information
Information about the Oracle DBMS
- Registration for a CISE account
- Registration for a CISE Oracle account
- Oracle CISE Web Site (provided by the CISE system administration)
- Additional information about creating Oracle accounts and sharing a database (provided by the CISE system administration)
- Primer for Oracle SQLPLUS
- Information about PHP and Oracle at the CISE department
- Information about JDBC and Oracle at the CISE department

Time and Location of Lectures

Tuesdays: 8th & 9th period (3:00 pm - 3:50 pm, 4:05 pm - 4:55 pm)
Thursdays: 9th period (4:05 pm - 4:55 pm)

Lectures are held in room NEB 201.

Office Hours

Tuesdays: 2:00 pm - 2:40 pm
Thursdays: 3:00 pm - 3:45 pm
and by appointment

TA Information

Name: Nam Nguyen
Email: nanguyen@cise.ufl.edu
Office hours and location: Wednesdays and Fridays from 4:00 pm to 6:00 pm, room E309

Course Syllabus

Syllabus.pdf (last update: December 20th, 2011)

Required and Recommended Readings

R. Elmasri & S. B. Navathe. Fundamentals of Database Systems. Addison Wesley, 6th edition, 2010. (required)
A. Silberschatz, H. F. Korth & S. Sudarshan. Database System Concepts. McGraw Hill, 6th edition, 2010. (recommended)
T. Connolly & C. Begg. Database Systems - A Practical Approach to Design, Implementation, and Management. Addison Wesley, 5th edition, 2009. (recommended)
H. Garcia-Molina, J. D. Ullman & J. Widom. Database Systems: The Complete Book. Prentice Hall, 2nd edition, 2008. (recommended)
M. M. Zloof. Query-By-Example: A Data Base Language. IBM Systems Journal, 16(4):324-343, 1977.

Lecture and Presentation Schedule

Date	Lecture Topic	Slides	Readings¹	Comments
Tu 01/10	Preliminaries, Introduction (I)	Lecture 01	Chapter 1	Read syllabus Solution to the Lacking Email in Class Roll problem
Th 01/12	Introduction (II)	Lecture 02	Chapter 2	Read project specification
Tu 01/17	Short Oracle Introduction, ER model (I)	Lecture 03	Section 7.1-7.5
Th 01/19	ER model (II)	Lecture 04	Sections 7.6-7.7, 7.9 Sections 8.1-8.3, 8.5, 8.7	Homework 1
Tu 01/24	Relational Data Model, transformation of an ER diagram into a relational database schema (I)	Lecture 05	Sections 3.1-3.2, 9.1
Th 01/26	Transformation of an ER diagram into a relational database schema (II), Relational Algebra (I)	Lecture 06	Sections 6.1-6.2
Tu 01/31	Relational Algebra (II)	Lecture 07	Sections 6.3-6.4	Project Deliverable for Phase 1 due before² class
Th 02/02	Relational Algebra (III), Tuple Relational Calculus, Domain Relational Calculus (I)	Lecture 08	Sections 6.5-6.6	Homework 1 due before² class Homework 1 Solutions
Tu 02/07	Exam 1 (Solutions)
Th 02/09	Domain Relational Calculus (II), SQL (I)	Lecture 09	Sections 6.7-6.8, Sections 4.1-4.2	Homework 2
Tu 02/14	SQL (II)	Lecture 10	Section 4.3, 4.5, 4.6, 5.4
Th 02/16	SQL (III)	Lecture 11	Section 5.1
Tu 02/21	SQL (IV)	Lecture 12	Section 5.5	Project Deliverable for Phase 2 due before class
Th 02/23	SQL (V), QBE (I)	Lecture 13	Sections 4.4, 5.3, Appendix C, QBE	Homework 2 due before class Homework 2 Solutions Homework 3
Tu 02/28	QBE (II), Functional Dependencies (I)	Lecture 14	Sections 15.1-15.2
Th 03/01	Functional Dependencies (II)	Lecture 15	Section 16.1	Project Deliverable for Phase 3 due before class Start of Project Phase 4: System Implementation
Tu 03/06	Spring Break
Th 03/08	Spring Break
Tu 03/13	Functional Dependencies (III), Normalization (I)	Lecture 16		Homework 3 due before class Homework 3 Solutions Homework 4
Th 03/15	Normalization (II)	Lecture 17	Sections 16.2, 15.3	Project Checkpoint 1
Tu 03/20	Exam 2 (Solutions)
Th 03/22	Normalization (III)	Lecture 18	Sections 16.3, 15.4
Tu 03/27	Normalization (IV), Database Application Programming (I)	Lecture 19	Sections 15.5, 13.1-13.2
Th 03/29	Database Application Programming (II)	Lecture 20	Sections 13.3-13.6	Homework 4 due before class Homework 4 Solutions Homework 5 Project Checkpoint 2
Tu 04/03	Database Application Programming (III), Data Integrity (I)	Lecture 21	Sections 4.2, 5.2
Th 04/05	Data Integrity (II), Object-Relational Databases (I)	Lecture 22	Section 11.1
Tu 04/10	Object-Relational Databases (II), Algebraic Optimization (I)	Lecture 23	Section 11.2
Th 04/12	Algebraic Optimization (II)	Lecture 24	Section 19.7
Tu 04/17	Project Demonstration Day 1 (8 am - 12:00 pm)
Tu 04/17	Algebraic Optimization (III)	Lecture 25		Homework 5 due before class Homework 5 Solutions
Th 04/19	Project Demonstration Day 2 (8 am - 1:00 pm)
Tu 04/24	Exam 3 (Solutions)

¹ Readings should be completed before the lecture to which they correspond. The references in the Required Readings section relate to the required textbook from Elmasri & Navathe.
² The term before class means that the homework or deliverable has to be put in person on the desk in the classroom before the lecture begins. Electronic submissions will not be accepted.
³ The term no late policy this time means that the late policy rule (see syllabus) is invalidated in this case. The reason is that we aim to post the homework solutions immediately after the homework submissions in order to enable you to use the homework solutions as a preparation for the next exam. However, we cannot post the solutions if we have not received your submissions.

Project information

The project specification is available here.

Last update: April 23, 2012.
Markus Schneider (mschneid@cise.ufl.edu)