CS360 Tentative Schedule
We will try to cover the material according to the following
schedule, though I will update it as we go along. I expect that you will
read the sections in the text before we cover them in class. The numbers shown in
the Reading Assignments column are chapter.section.subsection numbers in the
textbook.
|
Date
|
Topic
|
Reading Assignments
|
W e e k 1
|
|
Mon 1
|
Syllabus, Why Databases
|
Chapter 1: pp 1 - 12
|
|
Mon 2
|
DBMS
Basic SQL
|
Chapter 1: pp 13 – 19 (top)
Chapter 3: pp 118-131 (top)
|
|
Wed 1
|
Keys
|
Chapter 2 through p. 62
|
|
Wed 2
|
Lab Day - Get familiar with MYSQL and submitting a
lab.
|
Do lab 1
|
W e e k 2
|
|
Mon 1
|
Referential Integrity
|
Chapter 2: pp 64 – 75
|
|
Mon 2
|
Functional Dependencies
|
|
|
Wed 1
|
Functional Dependencies
|
|
|
Wed 2
|
|
|
W e e k 3
|
|
Mon 1
|
SQL Built-in functions
|
Chapter 3: pp 131 – 135 (top)
|
|
Mon 2
|
Subqueries
|
Chapter 3: pp 135 – 137 (top)
|
|
Wed 1
|
Subqueries
|
|
|
Wed 2
|
|
|
W e e k 4
|
|
Mon 1
|
SQL for table creation and alteration
|
Chapter 3: pp 101 – 118
|
|
Mon 2
|
SQL for data insert, update, delete
|
Chapter 3: pp 147 – 151
|
|
Wed 1
|
|
|
|
|
|
W e e k 5
|
|
Mon
|
Cartesian Product
|
Chapter 3: pp 137 – 144
|
|
|
Inner Joins
|
|
|
Wed
|
Exam 1
|
notes/exam1StudyGuide.html
|
|
|
|
W e e k 6
|
|
Mon
|
Outer Joins and Unions
|
Chapter 3: pp 144 – 146
|
|
|
|
|
|
Wed
|
Entity – Relationship Diagrams
|
Chapter 4: pp 215 – 224
notes/ERDIntro.html
|
|
|
|
|
W e e k 7
|
|
Mon
|
Weak/Strong Entities
Recursive relationships
|
Chapter 4: pp 224 – 239
notes/ERDPractice.html
|
|
ERD -> Table schemas
|
Chapter 5: pp 253 – 278
notes/ERDtoSchema.html
|
|
See notes/finalExamStudyGuide.html and refresh
your browser page.
Last moment to hand in labs is
11:59PM on the Friday night of finals week.
Extra content:
|
Transactions / Lock / Deadlock
|
Chapter 6: pp 307 – 311
Notes: ConcurrencyAcid
|
|
Consistency & Isolation
|
Chapter 6: pp 311 – 312 (We will not cover cursors.)
|