Tentative Schedule

From Courses

• Note: Your first midterm will include all topics we have covered until Sep 25.

The exam will be open book, but closed notes.

• Note: Your second midterm will include all topics we have covered until between Sep 27 and Dec 4th.

Like the first midterm, the exam will be open book, but closed notes.

Contents 1 Week 1 1.1 Tu Aug 21 Course overview 1.2 Th Aug 23 2 Week 2 2.1 Tu Aug 28 2.2 Th Aug 30 3 Week 3 3.1 Tu Sep 4 3.2 Th Sep 6 4 Week 4 4.1 Tu Sep 11 4.2 Th Sep 13 5 Week 5 5.1 Tu Sep 18 5.2 Th Sep 20 6 Week 6 6.1 Tu Sep 25 6.2 Th Sep 27 7 Week 7 7.1 Tu Oct 2 7.2 Th Oct 4 8 Week 8 8.1 Tu Oct 9 Fall Break 8.2 Th Oct 11 Fall Break 9 Week 9 9.1 Tu Oct 16 9.2 Th Oct 18 10 Week 10 10.1 Tu Oct 23 10.2 Th Oct 25 11 Week 11 11.1 Tu Oct 30 11.2 Mini-project 2 (10/31/2007) 11.3 Th Nov 1 12 Week 12 12.1 Tu Nov 6 12.2 Th Nov 8 13 Week 13 13.1 Tu Nov 13 13.2 Th Nov 15 14 Week 14 14.1 Tu Nov 20 14.2 Th Nov 22 Thanksgiving 15 Week 15 15.1 Tu Nov 27 15.2 Th Nov 29 16 Week 16 16.1 Tu Dec 4 16.2 Th Dec 6 17 Week 17 (No Final!) 17.1 Tu Dec 11 cs6530 Project presentations 17.2 Th Dec 13 Finals week

[edit] Week 1

[edit] Tu Aug 21 Course overview

• Introduction to Databases (6 slides per page)

Read textbook: Chapter 1

[edit] Th Aug 23

• Conceptual Design: The Entity Relationship Model (6 slides per page)

Read textbook: 2.1-2.8 (4th ed); 6.1 - 6.9 (5th ed)

[edit] Week 2

[edit] Tu Aug 28

• Practice exercise: ER modeling

[edit] Th Aug 30

• The Relational Model (6 slides per page)

Read textbook: 2.9, 3.1 (4th ed); 2.1, 6.9-6.10 (5th ed)

[edit] Week 3

[edit] Tu Sep 4

• Practice exercise: From ER to relational

• Notes and announcements

[edit] Th Sep 6

• Relational Algebra (6 slides per page)

Read textbook: Chapter 3 (4th ed); 2.2 - 2.7, 3.1 - 3.10 (5th ed)

[edit] Week 4

[edit] Tu Sep 11

• Introduction to SQL

(6 slides per page)

Read textbook: Chapter 4 (4th ed); Chapter 3 (5th ed)

• Homework assignment 1 We will discuss this assignment on Sept 18th.

[edit] Th Sep 13

• More SQL

(6 slides per page)

Read textbook: Chapter 4 (4th ed); Chapter 4 (5th ed)

[edit] Week 5

[edit] Tu Sep 18

• SQL: Practice Exercise

• • Here are the CREATE TABLE and INSERT statements to create the instances we used in class: sailors.sql

• Notes: Using Oracle

• Key to Homework assignment 1 You should self-correct your assignment.

[edit] Th Sep 20

• Finish practice exercises
• SQL Updates, Embedded SQL, DB APIs, PL/SQL and triggers

(6 slides per page)

Read textbook: Chapter 4 (4.9-4.15) (4th ed); Chapter 3 (3.10), Chapter 4 (4.1, 4.4-4.9) (5th ed)

[edit] Week 6

[edit] Tu Sep 25

• Integrity Constraints, Triggers and Security (6 slides per page)

Read textbook: Chapter 5 (5.2) Chapter 6 (4th ed); Chapter 4 (4.2, 4.3), Chapter 5 (5.4) (5th ed)

[edit] Th Sep 27

• Introduction to XML Data Managament

(6 slides per page)

Read textbook: Chapter 10 (5th ed)

• Note: Your first midterm will include all topics we have covered until Sep 25.

[edit] Week 7

[edit] Tu Oct 2

• [http://www.cs.utah.edu/classes/cs5530/Lectures/lecture9-exam1-review.pdf

Midterm review]

[edit] Th Oct 4

• Midterm I

[edit] Week 8

[edit] Tu Oct 9 Fall Break

[edit] Th Oct 11 Fall Break

[edit] Week 9

[edit] Tu Oct 16

• XML Schema, XPath, and XQuery (6 slides per page)

Instructor out of town lecture by David Koop

[edit] Th Oct 18

• Practice exercise

Instructor out of town lecture by David Koop

[edit] Week 10

[edit] Tu Oct 23

• Storing XML Data

(6 slides per page)

[edit] Th Oct 25

• Finish XML query exercises

• Functional Dependencies and Relational Design

(6 slides per page)

Read textbook: Chapter 7 (4th and 5th ed)

[edit] Week 11

[edit] Tu Oct 30

[edit] Mini-project 2 (10/31/2007)

• Your second mini-project has been posted, and it is due Nov 15th at 3:40pm. For details see http://fleixeiras.cs.utah.edu/courses/index.php/Mini-project_2

[edit] Th Nov 1

• Relational Design: Decomposition into BCNF and 3NF

(6 slides per page)

Read textbook: Chapter 7 (4th and 5th ed)

• Transactions in SQL and a peek behind the scenes

(6 slides per page)

Read textbook: Chapter 15 (4th and 5th ed)

[edit] Week 12

[edit] Tu Nov 6

No class. Instructor out of town.

[edit] Th Nov 8

• Concurrency Control

(6 slides per page)

Read textbook: Chapter 15 (4th and 5th ed); 16.1 - 16.7 and 17.1 - 17.7 (5th edition, and the equivalent sections on 4th edition)

[edit] Week 13

[edit] Tu Nov 13

• Concurrency Control

(6 slides per page)

• Recovery strategies

(6 slides per page)

• Concurrency Control Recovery strategies

Read textbook: Chapter 15 (4th and 5th ed); 16.1 - 16.7 and 17.1 - 17.7 (5th edition, and the equivalent sections on 4th edition)

[edit] Th Nov 15

• In lab

[edit] Week 14

[edit] Tu Nov 20

• Storage and File Structure

(6 slides per page)

Read textbook: Chapter 11 in 5th ed -- check what the corresponding chapter is on 4th edition.

[edit] Th Nov 22 Thanksgiving

• Homework assignment 2
• Homework assignment 3

We will discuss this assignment on Dec 4th.

[edit] Week 15

[edit] Tu Nov 27

• Indexing

(6 slides per page)

Read textbook: Chapter 12, 13 and 14 in 5th ed -- check what the corresponding chapter are on 4th edition.

• Key to Homework assignment 2 You should self-correct your assignment.
• Key to Homework assignment 3 You should self-correct your assignment.

[edit] Th Nov 29

• Query Processing and Optimization

(6 slides per page)

[edit] Week 16

[edit] Tu Dec 4

• [http://www.cs.utah.edu/classes/cs5530/Lectures/lecture18-exam2-review.pdf

Midterm review]

[edit] Th Dec 6

• Midterm II

[edit] Week 17 (No Final!)

[edit] Tu Dec 11 cs6530 Project presentations

[edit] Th Dec 13 Finals week