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