|
6/7, 8/9 Jan 2020 |
1. |
|
Introduction to Database Systems |
|
|
Read: |
Chapter 1 & 2 from the textbook |
|
|
Slides: |
(Set #1) in PDF: 4 slides per page
|
|
|
|
(Set #2) in PDF: 4 slides per page
|
|
13/14, 15/16 Jan 2020 |
2. |
|
Relational Model |
|
|
Read: |
Chapter 5 from the textbook (7th Ed.) |
|
|
          |
Chapters 3 from the textbook (6th Ed.) |
|
|
Slides: |
in PDF:
4 slides per page
|
|
15/16, 21/22 Jan 2020 |
3. |
|
SQL DDL |
|
|
Read: |
Chapters 6.1-6.2 and 7.4 from the textbook (7th Ed.) |
|
|
          |
Chapters 4.1-4.2 and 5.4 from the textbook (6th Ed.)
|
|
|
Slides: |
in PDF:
4 slides per page
|
|
27/28, 29/30 Jan, 3/4 Feb 2020 |
5. |
|
Relational Algebra |
|
|
Read: |
Chapter 8.1-8.5 from the textbook (7th Ed.) |
|
|
          |
Chapters 6.1-6.5 from the textbook (6th Ed.)
|
|
|
Slides: |
(Set #1) in PDF:
4 slides per page
|
|
|
|
(Set #2) in PDF:
4 slides per page
|
|
5/6, 10/11, 12/13 Feb 2020 |
6. |
|
SQL DML Introduction |
|
|
Read: |
Chapters 6.3-6.6 & 7.1 from the textbook (7th Ed.) |
|
|
          |
Chapters 4.3-4.6 & 5.1 from the textbook (6th Ed.)
|
|
|
Slides: |
Set #1, in PDF:
4 slides per page
|
|
|
Slides: |
Set #2, in PDF:
4 slides per page
|
|
17/18, 19/20, 24/25 Feb 2020 |
7. |
|
SQL Views, Access Control, Integrity Constraints & Transactions |
|
|
Read: |
Chapters 5.2-5.5 from the textbook (6th Ed.) |
|
|
          |
Chapters 7.2-7.5 from the textbook (7th Ed.)
|
|
|
Slides: |
(Set #1) in PDF:
4 slides per page (Views)
|
|
|
|
(Set #2) in PDF:
4 slides per page (Access Control)
|
|
|
|
(Set #3) in PDF:
4 slides per page (Integrity Constraints)
|
|
|
|
(Set #4) in PDF:
1 slide per page (Transactions)
|
|
|
|
|
|
|
ONLINE MATERIAL START |
17 Mar 2020 |
|
|
Online Logistics |
|
|
Slides: |
in PDF:
4 slides per page
|
|
|
Video: |
|
|
|
26 Feb/2 Mar, 3, 23 Mar 2020 |
8. |
|
SQL Programming |
|
|
Read: |
Chapters 10-11 from the textbook (7th Ed.) |
|
|
          |
Chapter 13-14 and 21-22 from the textbook (6th Ed.)
|
|
|
Slides: |
(Set #1) in PDF:
1 slide per page (PL/SQL)
|
|
|
Video: |
|
|
|
Slides: |
(Set #2) in PDF:
1 slide per page (Embedded SQL)
|
|
|
Video: |
|
|
|
Slides: |
(Set #3) in PDF:
1 slide per page (JDBC)
|
|
|
Video: |
|
|
Week of 23-26 Mar 2020 |
9. |
|
DB Design - Normalization |
|
|
Read: |
Chapter 14 and Sections 15.2-15.5 from the textbook (7th Ed.) |
|
|
          |
Chapters 15 and Sections 16.2-16.5 from the textbook (6th Ed.)
|
|
|
Slides: |
(Set #1) in PDF:
4 slides per page,
1 slides per page
Updated
|
|
|
Video: |
|
|
|
|
(Set #2) in PDF:
4 slides per page,
1 slides per page
Updated
|
|
|
Video: |
|
|
Week of 20 Mar - Apr 3 2020 |
10. |
|
DB Design - Conceptual Design, ER and EER Model |
|
|
Read: |
Chapters 3, 4 and 9 from the textbook (7th Ed.) |
|
|
          |
Chapters 7-10 from the textbook (6th Ed.)
|
|
|
Slides: |
(Set #1) in PDF:
4 slides per page,
1 slides per page (E-R Model)
|
|
|
Video: |
|
|
|
Slides: |
(Set #2) in PDF:
4 slides per page
1 slides per page (E-R Diagrams)
|
|
|
Video: |
|
|
|
Slides: |
(Set #3) in PDF:
4 slides per page,
1 slides per page (EER Model & UML)
|
|
|
Video: |
|
|
|
Slides: |
(Set #4) in PDF:
4 slides per page (ER to Relational Mapping)
|
|
Week of 6-10 Apr 2020 |
11. |
|
Physical Organization: Data Storage & Files |
|
|
Read: |
Chapters 16 and 17 from textbook (7th Ed.) |
|
|
          |
Chapters 17-18 from the textbook (6th Ed.)
|
|
|
Slides: |
(Set #1) in PDF:
4 slides per page,
1 slide per page (Data Storage & Files)
|
|
|
Video: |
|
|
|
Slides: |
(Set #2) in PDF:
4 slides per page,
1 slide per page (Dynamic Hashing)
|
|
|
Video: |
|
|
Week of 13-17 Apr 2020 |
12. |
|
Index Stuctures |
|
|
Read: |
Chapters 16 and 17 from textbook (7th Ed.) |
|
|
          |
Chapters 17-18 from the textbook (6th Ed.)
|
|
|
Slides |
in PDF:
4 slides per page,
1 slide per page
|
|
|
Video: |
|
|
|
|
13. |
|
Transaction Processing (TP) - Concurrency Control & Recovery |
|
|
Read: |
Chapters 20 to 22 from the textbook (7th Ed.) |
|
|
          |
Chapters 21 to 23 from the textbook (6th Ed.)
|
|
|
Slides |
(Set #1) in PDF:
4 slides per page,
1 slide per page
(Concurrency control protocols)
|
|
|
Video: |
|
|
|
Slides |
(Set #2) in PDF:
4 slides per page,
1 slide per page
(recovery protocols)
|
|
|
Video: |
|
|