Week
|
Dates
|
Topic
|
Reading
|
Slides
|
W01 |
11 Jan 2022
|
Overview of Database Management Systems |
Chapter 1 & 2 from the textbook |
Set #1 |
W01 |
13 Jan 2022
|
Overview of Database Management Systems |
Chapter 1 & 2 from the textbook |
Set #2 |
W02 |
18 Jan 2022
|
DB Design - Conceptual Design, ER Model |
Chapters 3, 4 and 9 from the textbook (7th Ed.) |
Set #1 |
DB Design - Conceptual Design, ER Model |
Chapters 3, 4 and 9 from the textbook (7th Ed.) |
Set #2 |
W02 |
20 Jan 2022
|
DB Design - Conceptual Design, ER Model |
Chapters 3, 4 and 9 from the textbook (7th Ed.) |
Set #2 |
W03 |
25 Jan 2022
|
Relational Database Model |
Chapter 5 from the textbook |
Set #1 |
W03 |
27 Jan 2022
|
Relational Database Model |
Chapter 5 from the textbook |
Set #2 |
W04 |
1 Feb 2022
|
Structured Query Language SQL - DDL |
Chapters 6.1-6.2 and 7.4 from the textbook (7th Ed.) |
Set #1 ER to
RM |
W04 |
3 Feb 2022
|
Relational Algebra |
Chapter 8.1-8.5 from the textbook (7th Ed.) |
Set #1 |
W05 |
8 Feb 2022
|
Relational Algebra |
Chapter 8.1-8.5 from the textbook (7th Ed.) |
Set #2 |
W05 |
10 Feb 2022
|
Relational Algebra |
Chapter 8.1-8.5 from the textbook (7th Ed.) |
Set #3 |
W06 |
15 Feb 2022
|
SQL DML Introduction |
Chapters 6.3-6.6 & 7.1 from the textbook (7th Ed.) |
Set #1 |
W06 |
17 Feb 2022
|
SQL DML |
Chapters 6.3-6.6 & 7.1 from the textbook (7th Ed.) |
Set #2 |
W07 |
22 Feb 2022
|
SQL DML |
Chapters 6.3-6.6 & 7.1 from the textbook (7th Ed.) |
Set #3 |
W07 |
24 Feb 2022
|
SQL DML |
Chapters 6.3-6.6 & 7.1 from the textbook (7th Ed.) |
Set #3 |
W08 |
1 Mar 2022
|
SQL DML |
Chapters 6.3-6.6 & 7.1 from the textbook (7th Ed.) |
Set #3 |
W08 |
3 Mar 2022
|
DB Design - Normalization |
Chapter 14 and Sections 15.2-15.5 from the textbook (7th Ed.) |
Set #1 |
W09 |
8 Mar 2022
|
Spring Recess for students (no classes) |
W09 |
10 Mar 2022
|
W10 |
15 Mar 2022
|
Midterm |
Material: Until SQL DML included (Jan 11 - Mar 1) |
Midterm Review |
W10 |
17 Mar 2022
|
DB Design - Normalization |
Chapter 14 and Sections 15.2-15.5 from the textbook (7th Ed.) |
Set #2 |
W11 |
22 Mar 2022
|
DB Design - Normalization |
Chapter 14 and Sections 15.2-15.5 from the textbook (7th Ed.) |
Set #2 |
SQL Views |
Chapters 7.2-7.5 from the textbook (7th Ed.) |
Set #1 |
W11 |
24 Mar 2022
|
SQL Views |
Chapters 7.2-7.5 from the textbook (7th Ed.) |
Set #1 |
SQL Access Control |
Chapters 7.2-7.5 from the textbook (7th Ed.) |
Set #1 |
W12 |
29 Mar 2022
|
SQL Integrity Constraints |
Chapters 7.2-7.5 from the textbook (7th Ed.) |
Set #1 |
W12 |
31 Mar 2022
|
Transaction Processing |
Chapters 20 to 22 from the textbook (7th Ed.) |
Set #1 |
DB Internal Programming (ESQL & PLSQL) |
Chapters 10-11 from the textbook (7th Ed.) |
Set #1 |
W13 |
5 Apr 2022
|
DB Programming (PLSQL) |
Chapters 10-11 from the textbook (7th Ed.) |
Set #1 |
W13 |
7 Apr 2022
|
DB External Programming |
Chapters 10-11 from the textbook (7th Ed.) |
Set #1 |
W14 |
12 Apr 2022
|
Transaction Processing (TP) - Concurrency Control |
Chapters 20 and 21 from the textbook (7th Ed.) |
Set #1 |
W14 |
14 Apr 2022
|
Transaction Processing (TP) - Recovery |
Chapters 20 and 21 from the textbook (7th Ed.) |
Set #1 |
W15 |
19 Apr 2022
|
Physical Organization: Storage & Files |
Chapters 16 and 17 from textbook (7th Ed.) |
Set #1 |
W15 |
21 Apr 2022
|
Physical Organization: Indexing |
Chapters 16 and 17 from textbook (7th Ed.) |
Set #1 |