| Mon-24-Jan |
Chapter 1 |
|
| Wed-26-Jan |
Chapter 2 |
Homework 1 |
| Fri-28-Jan |
Chapter 3 through 3.3.1 |
|
| Mon-31-Jan |
Chapter 3 through 3.5 |
|
| Wed-2-Feb |
Chapter 3.6 through 3.7 |
Populate parts/suppliers tables, clean data for Friday
|
| Fri-4-Feb |
Chapter 3.8 through 3.10. Note: MySQL does not support
UNIQUE,WITH, INTERSECT,
or EXCEPT.
|
-
Quiz Monday Feb 7.
-
Homework 2 due
Friday Feb 11.
|
| Mon-7-Feb |
Chapter 3.8 through 3.10. Note: MySQL does not support
UNIQUE,WITH, INTERSECT,
or EXCEPT.
|
Review notes. We covered set operations union, intersect, and
difference, and the group by clause.
|
| Wed-9-Feb |
Reading 3.8-3.10
|
Homework 2 is due Monday Feb 14.
|
| Fri-11-Feb |
Reading 4.1 - 4.2
|
We also will cover query keywords
all and any.
|
| Mon-14-Feb |
Reading 4.3,4.6 (skip 4.4,4.5)
|
HW 2 Solutions
|
| Wed-16-Feb |
Reading: 5.1
|
HW 3
|
| Fri-18-Feb |
Reading: 7.1 - 7.2
|
|
| Mon-21-Feb |
Reading: 7.3 - 7.5
|
Installed Visual Paradigm
|
| Wed-23-Feb |
ER Diagram Case Study (Online Bookstore)
|
Sample Exam 1
|
| Fri-25-Feb |
Online Bookstore ER Diagram Case Study continued
|
Sample Exam 1 Solutions
|
| Mon-28-Feb |
Exam 1
|
|
| Wed-2-Mar |
Finish ER diagram for online bookstore in Visual Paradigm
|
Form project teams and project proposals
|
| Fri-4-Mar |
Relational Database Design Theory
|
Reading 8.1 - 8.2
|
| Mon-7-Mar |
Boyce-Codd normal Form, Functional dependency theory
|
Reading 8.3
|
| Wed-9-Mar |
Guest Lecture from Shawn Golley
|
|
| Fri-11-Mar |
Discussion of project proposals.
|
Reading: 8.4
|
| Mon-21-Mar |
Functional Dependency Theory (continued),
Attribute Closure Algorithm.
|
20-minute Quiz Monday March 28. Reading: Continue digesting 8.4.
|
| Wed-23-Mar |
Functional Dependency Theory continue.
Canonical cover, lossless decomposition, dependency preservation.
|
- Reading: Section 8.4.
- Quiz Monday, April 4.
- Project proposal due this Friday
- Look at practice problems 8.1 - 8.7, 8.9
(for 8.9 do the first part of problem described in the first sentence),
8.13
|
| Fri-25-Mar |
Storage and File Structure: Memory Hierarchy and RAID levels.
|
- Reading: Section 10.1 - 10.4
-
Functional requirements document due Friday April 1.
|
| Mon-28-Mar |
Storage and File Structure
- RAID levels
- Text vs. Binary Files (Java example)
|
- Quiz Monday, April 11.
- Reading: Section 10.5
-
Functional requirements document due this Friday, April 1.
|
| Wed-30-Mar |
Storage and File Structure
- Text vs. Binary Files (Java example)
- Fixed-length Records
- Random Access Files (Java example)
- Sequential Files
|
-
Quiz Monday, April 11. Look at practice problems 8.1 - 8.7, 8.9
(for 8.9 do the first part of problem described in the first sentence),
8.13. Review terms on pages 368, 469.
- Reading: Section 10.6
-
Functional requirements document due this Friday, April 1.
|
| Fri-1-Apr |
Storage and File Structure
- Random Access Files (Java example)
- Sequential Files
|
-
Quiz Wednesday, April 6. Look at practice problems 8.1 - 8.7, 8.9
(for 8.9 do the first part of problem described in the first sentence),
8.13. Review terms on pages 368, 469.
- Reading: Section 10.6
-
ER and dependency analysis due Friday April 8.
|
| Mon-4-Apr |
Storage and File Structure
- Sequential Files on disk
- Variable length records
|
-
Exam 2 moved to Wednesday April 20
-
Quiz Wednesday, April 6. Look at practice problems 8.1 - 8.7, 8.9
(for 8.9 do the first part of problem described in the first sentence),
8.13. Review terms on pages 368, 469.
- Reading: Section 10.6
-
ER and dependency analysis due Friday April, 8.
|
| Wed-6-Apr |
Storage and File Structure
- Finish Sequential Files on disk
|
Quiz 2 Solutions.
|
| Fri-8-Apr |
Project Work Day
|
ER-Diagram and dependency analysis due.
|
| Mon-11-Apr |
- Finish chapter 10 on file structures.
- Begin Chapter 11 on Indexing.
- Reading: 11.1 - 11.2
|
Project: Table creation, table data population.
|
| Wed-13-Apr |
- Balanced Trees, 2-3 trees.
|
|
| Fri-15-Apr |
- B-Trees
- B-Tree Leaf Node
- Example B-Tree
- Example B-Tree Index
|
Reading: Section 11.3
|
| Mon-18-Apr |
- Exam 2 Study Guide
|
Reading: Section 11.3
|
| Wed-20-Apr |
Exam 2
|
|
| Wed-22-Apr |
XML Example
|
|
| Mon-25-Apr |
Continue with Library XML example, and DTD.
|
|
| Wed-27-Apr |
XML Schema
|
- Exam 2 Solutions
- Exam 2 BTree Q6 Answer
|
|
