|
|
| 9 Jan 2018 |
| 1. |
|
Introduction to Database Systems |
|
|
Read: |
Chapter 1 & 2 from the textbook |
|
|
Slides: |
in PDF:
4 slides per page
|
|
|
| 11 Jan 2018 |
| 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
|
|
|
| 16, 18 Jan 2018 |
| 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
|
|
|
| 18, 23, 25 Jan 2018 |
| 4. |
|
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 (DBS Design)
|
|
|
|
(Set #2) in PDF:
4 slides per page (Normalization)
|
|
|
|
(Set #3) in PDF:
4 slides per page (RDB Design)
|
|
|
| 30 Jan, 1, 6 Feb 2018 |
| 5. |
|
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.)
|
|
|
|
Set #1 in PDF:
4 slides per page
|
|
|
|
Set #2 in PDF:
4 slides per page
|
|
|
|
Set #3 in PDF:
4 slides per page
|
|
|
|
Set #4 in PDF:
4 slides per page (ER to Relational Mapping)
|
|
|
| 6, 8 Feb 2018 |
| 6. |
|
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
|
|
|
Slides: |
(Set #2) in PDF:
4 slides per page
|
|
|
| 15 Feb 2018 |
| 7. |
|
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 #2, in PDF:
4 slides per page
|
|
|
| 15, 20 Feb 2018 |
|
| 8. |
|
Transaction Processing (TP) - Concurrency Control |
|
|
Read: |
Chapters 20 and 21 from the textbook (7th Ed.) |
|
|
|
Chapters 21 and 22 from the textbook (6th Ed.)
|
|
|
Slides |
Set #1 in PDF:
4 slides per page (Serializability theory)
|
|
|
Slides |
Set #2 in PDF:
4 slides per page (Concurrency control protocols)
|
|
|
|
|
|
MATERIAL FOR FINAL EXAM -- START |
|
|
| 22, 27 Feb 2018 |
| 9. |
|
SQL DML |
|
|
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: |
All sets, in PDF:
1 slide per page
|
|
|
| 13, 15 Mar 2018 |
| 10. |
|
SQL Views and Access Control |
|
|
Read: |
Chapters 5.2-5.5 from the textbook (6th Ed.) |
|
|
|
Chapters 7.2-7.5 from the textbook (7th Ed.)
|
|
|
Slides: |
All sets, in PDF:
1 slide per page (Views)
|
|
|
|
All sets, in PDF:
1 slide per page (Access Control)
|
|
|
| 15, 20 Mar 2018 |
| 11. |
|
SQL Transactions & Integrity Constraints |
|
|
Read: |
Chapters 7.2-7.5 from the textbook (7th Ed.) |
|
|
|
Chapters 5.2-5.5 from the textbook (6th Ed.)
|
|
|
Slides: |
in PDF:
1 slide per page
|
|
|
| 22, 27, 30 Mar 2018 |
| 12. |
|
SQL Programming |
|
|
Read: |
Chapters 10-11 from the textbook (7th Ed.) |
|
|
|
Chapter 13-14 and 21-22 from the textbook (6th Ed.)
|
|
|
Slides: |
All in PDF:
1 slide per page
|
|
|
| 3, 5, 10, 12 Apr 2018 |
| 13. |
|
Physical Organization: Storage, Files & Indexing |
|
|
Read: |
Chapters 16 and 17 from textbook (7th Ed.) |
|
|
|
Chapters 17-18 from the textbook (6th Ed.)
|
|
|
Slides |
Set #1 in PDF:
1 slide per page (Data Storage)
Linear Hashing example
|
|
|
|
Set #2 in PDF:
1 slide per page (Indexing)
|
|
|
| 12 Apr 2018 |
| 14. |
|
Query Optimization |
|
|
Read: |
Chapter 19 from the textbook (7th Ed.) |
|
|
|
Chapters 21, 22 and 23 from the textbook (6th Ed.)
|
|
|
Slides |
in PDF:
1 slide per page
Note: We only covered up until slide #13 in the slides.
|
|
|
| 17 Apr 2018 |
|
| 15. |
|
Recovery |
|
|
Read: |
Chapters 22 from the textbook (7th Ed.) |
|
|
|
Set #1 in PDF:
1 slide per page (Recovery)
|
|
|
|
|
|
MATERIAL FOR FINAL EXAM -- END |
|
|
|
|
|
