Database Management Systems

  (COP 5725)

Spring 2017

Instructor: Dr. Markus Schneider

Course Information


Time and Location of Lectures

Tuesdays:     2nd period (8:30 am - 9:20 am)
Thursdays:    2nd & 3rd period (8:30 am - 9:20 am, 9:35 am - 10:25 am)

Lectures are held in room NEB 100.


Office Hours

Wednesdays and Fridays: 8:30 am - 9:30 am
and by appointment


TA Information

Name: Keke Zhai (TA)
Email: keke@cise.ufl.edu
Office hours:
Mondays 3:00 pm - 5:00 pm in room E309 and Thursdays 5:00 pm - 7:00 pm in room E312

Name: Man Mohan Devineni
Email: manmdevineni@ufl.edu
Office hours:
will be announced
Location: As for the TA


Course Syllabus

Syllabus (last update: December 26th, 2016)


Required and Recommended Readings


Lecture and Presentation Schedule

Date Lecture Topic Slides Readings1 Milestones
Th
01/05
Preliminaries, Introduction (I) Lecture 01 Chapter 1 Read syllabus
Tu
01/10
Introduction (II), Project discussion (I) Lecture 02 Chapter 2 Read project specification
Th
01/12
Project discussion (II), Short Oracle Introduction, Entity-Relationship Model (I)
Lecture 03 Section 3.1-3.5 Homework 1
(Note: Always sign and submit the first page of a homework assignment.)
Tu
01/17
Entity-Relationship Model (II), Relational Data Model (I) Lecture 04 Sections 3.6-3.7, 3.9-3.10
Sections 4.1-4.3, 4.5, 4.7
 
Th
01/19
Relational Data Model (II)Transformation of an Entity-Relationship diagram into a relational database schema Lecture 05 Sections 5.1-5.2, Section 9.1
 
Tu
01/24
Relational Algebra (I) Lecture 06 Sections 8.1-8.2 Project Deliverable for Phase 1 due before2 class
Th
01/26
Relational Algebra (II) Lecture 07 Sections 8.3-8.4 Homework 1 due before2 class
Homework 1 Solutions
Tu
01/31
Relational Algebra (III), Tuple Relational Calculus Lecture 08 Sections 8.5-8.6 Homework 2
Th
02/02
Exam 1 (Solutions)
Tu
02/07
Domain Relational Calculus, SQL (I) Lecture 09 Sections 8.7-8.8,
Sections 6.1-6.2
Project Deliverable for Phase 2 due before class
Th
02/09
SQL (II) Lecture 10 Section 6.3, 6.5, 6.6, 7.4  
Tu
02/14
SQL (III) Lecture 11 Section 7.1  
Th
0
2/16
SQL (IV) Lecture 12 Section 7.5 Homework 2 due before class
Homework 2 Solutions
Homework 3
Tu
02/21
SQL (V), QBE (I) Lecture 13 Sections 6.4, 7.3, Appendix C, QBE  
Th
02/23
QBE (II), Functional Dependencies (I) Lecture 14 Sections 14.1-14.2 Project Deliverable for Phase 3 due before class
Start of Project Phase 4: System Implementation
Tu
02/28
Functional Dependencies (II)Lecture 15 Section 15.1  
Th
03/02
Functional Dependencies (III),Normalization (I)Lecture 16   Homework 3 due before class
Homework 3 Solutions
Homework 4
Tu
03/07
Spring Break
Th
03/09
Spring Break
Tu
03/14
Normalization (II)Lecture 17 Sections 15.2, 14.3 Project Checkpoint 1
Th
03/16
Exam 2 (Solutions)
Tu
03/21
Normalization (III) Lecture 18 Sections 15.3, 14.4, 14.5  
Th
03/23
Normalization (IV) Lecture 19   Homework 4 due before class
Homework 4 Solutions
Homework 5

Tu
03/28
Database Application Programming (I) Lecture 20 Sections 10.1-10.4  
Th
03/30
Database Application Programming (II), Data Integrity (I) Lecture 21 Sections 10.5-10.6,
Section 6.2
 
Tu
04/04
 
Lecture 22  
Project Checkpoint 2
Th
04/06
 
Lecture 23    
Tu
04/11
 
Lecture 24   Homework 5 due before class
(no late policy granted)
Homework 5 Solutions
Th
04/13
Exam 3 (Solutions)
Mo
04/17
Project Demonstration Day 1
Tu
04/18
Project Demonstration Day 2
We
04/19
Project Demonstration Day 3
Th
04/20
Project Demonstration Day 4

1 Readings should be completed before the lecture to which they correspond. The references in the Required Readings section relate to the recommended textbook from Elmasri & Navathe.
2 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. This procedure only holds for on-campus students. EDGE students submit their assignments by email as PDF files.
3 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: March 29, 2017
Markus Schneider (mschneid@cise.ufl.edu)