Information and Database Management Systems I

  (CIS 4301)

Spring 2017

Instructor: Dr. Markus Schneider

Course Information


Time and Location of Lectures

Mondays, Wednesdays, Fridays: 3rd period (9:35 am - 10:25 am)

Lectures are held in room TUR L011.


Office Hours

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


TA and Grader Information

Name: Yang Peng (TA)
Email: ypeng@cise.ufl.edu
Office hours: Mondays and Wednesdays from 1:00 pm - 3:00 pm

Location: CSE 457

Name: Andrew Zhang (grader)
Email: andrewzhang@ufl.edu
Office hours: TBD

Location: E309


Course Syllabus

Syllabus (last update: January 23, 2017)


Required and Recommended Readings


Lecture Schedule

Date Lecture Topic Slides Readings1 Milestones
We
01/04
Preliminaries
Lecture 01 SKS: Sections 1.1-1.5
CB: Sections 1.1-1.2
Read syllabus
Fr
01/06
Introduction (I), Project discussion (I)
Lecture 02 SKS: Sections 1.6-1.10
CB: Sections 1.3-1.4
Read project specification
Mo
01/09
 Project discussion (II), Introduction (II)
Lecture 03 SKS: Sections 1.11-1.14
CB: Sections 1.5-1.6
 
We
01/11
Introduction (III), Short Introduction to Oracle (I)
Lecture 04 CB: Sections 2.1-2.4  
Fr
01/13
Short Introduction to Oracle (II), Entity-Relationship Model (I) Lecture 05 SKS: Sections 7.1-7.4
CB: Sections 12.1-12.7
Homework 1
(Note: Always sign and submit the first page of a homework assignment.)
Mo
01/16
Martin Luther King Jr. Day (Holidays)
We
01/18
Entity-Relationship Model (II) Lecture 06 SKS: Sections 7.5, 7.7-7.8
CB: Sections 13.1-13.3
 
Fr
01/20
Entity-Relationship Model (III), Relational Data Model (I) Lecture 07 SKS: Sections 2.1-2.3
CB: Section 4.1
 
Mo
01/23
Relational Data Model (II) Lecture 08
SKS: Sections 2.4-2.7
  CB: Section 4.2
 
We
01/25
Relational Data Model (III), Transformation of an Entity-Relationship diagram into a relational database schema
Lecture 09 SKS: Section 7.6
CB: Sections 17.1
 
Fr
01/27
Relational Algebra (I) Lecture 10 SKS: Sections 6.1.1-6.1.2
CB: Sections 5.1.1-5.1.2
Project Deliverable for Phase 1 due before2 class
Mo
01
/30
Relational Algebra (II) Lecture 11 SKS: Sections 6.1.3
CB: Sections 5.1.3-5.1.4
 
We
02/01
Relational Algebra (III) Lecture 12  
Homework 1 due before2 class
(No late policy this time!)
Homework 1 Solutions
Fr
02/03
Exam 1 - Part 1 (Solutions)
Mo
02/06
Exam 1 - Part 2 (Solutions)
We
02/08
Relational Calculi, SQL (I)
Lecture 13 SKS: Sections 6.2-6.4
CB: Section 5.2
 
Fr
02/10
Discussion of Phase II of the database project, SQL (II)
Lecture 14 SKS: Sections 3.1-3.2, 4.5
CB: Sections 6.1, 7.1-7.2
Homework 2
Mo
02/13
SQL (III) Lecture 15 SKS: Section 3.3
CB: Section 7.3, 6.2
Project Deliverable for Phase 2 due before2 class
We
02/15
SQL (IV) Lecture 16 SKS: Section 3.4
CB: Section
6.3.1
 
Fr
02/17
SQL (V) Lecture 17
SKS: Sections 3.5-3.7
CB: Sections 6.3.2-6.3.6
 
Mo
02/20
SQL (VI) Lecture 18
SKS: Sections 3.8-3.10
CB: Sections 6.3.7-6.3.10
Project Deliverable for Phase 3 due before2 class
Start of Project Phase 4: System Implementation
We
02/22
SQL (VII) Lecture 19 SKS: Sections 4.1-4.2
CB: Section 7.4
 
Fr
02/24
SQL (VIII), QBE (I) Lecture 20 QBE (original paper) Homework 2 due before2 class
Homework 2 Solutions
Homework 3
Mo
02/27
QBE (II) Lecture 21  
 
We
03/01
Functional Dependencies (I) Lecture 22 SKS: Section 8.1
CB: Sections 14.1-14.3
 
Fr
03/03
 
Lecture 23  
 
Mo
03/06


Spring Break
(Holidays)

We
03/08
Fr
03/10
Mo
03/13
 
Lecture 24  
Homework 3 due before2 class
(No late policy this time!)
Homework 3 Solutions
Homework 4
Project Checkpoint 1 (whole week)
We
03/15
Exam 2 - Part 1 (Solutions)
Fr
03/17
Exam 2 - Part 2 (Solutions)
Mo
03/20
 
Lecture 25
   
We
03/22
 
Lecture 26
   
Fr
03/24

Lecture 27
   
Mo
03/27
 
Lecture 28
   
We
03/29
 
Lecture 29
  Homework 4 due before2 class
Homework 4 Solutions
Homework 5
Fr
03/31
 
Lecture 30
   
Mo
04/03
 
Lecture 31
   
We
04/05
 
Lecture 32
  Project Checkpoint 2 (whole week)
Fr
04/07
 
Lecture 33
   
Mo
04/10
 
Lecture 34
   
We
04/12
 
Lecture 35
   
Fr
04/14
 
Lecture 36
  Homework 5 due before2 class
Homework 5 Solutions
Mo
04/17
Exam 3 - Part 1 (Solutions)
We
04/19
Exam 3 - Part 2 (Solutions)

1 Readings should be completed before the lecture to which they correspond. The references in the Required Readings section relate to the recommended textbooks from Silberschatz,Korth, and Sudarshan (SKS) and Connolly and Begg (CB).
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.
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: February 27, 2017
Markus Schneider (mschneid@cise.ufl.edu)