CSCI 5333
Database Management Systems (DBMS)
Fall 2021
Syllabus
by K. Yue
The syllabus is tentative. Actual contents and order of coverage may change. There will be around 9 homework assignments, the actual number is subjected to changes.
Date |
Contents |
Comments |
Week #1 (8/24) |
Class starts 8/24/2021 (Tuesday) Introduction and overview Review of the relational model |
How to succeed in the class Syllabus in Concept Map Introduction Introduction to DB Architecture. Read Chapters 1 and 2. |
Week #2 (8/31) |
Additional Materials: Critical Thinking (* if time permits) Introduction to data modeling and database design Data modeling using UML |
Additional Materials: Critical Thinking in CS and DB Introduction to DB Modeling. Read Chapters 3 and 10. Introduction to UML/DB Modeling. Additional Materials: the context of UML class diagram in CM. |
Week #3 (9/7) |
Data modeling using UML UML modeling |
Read Chapter 10 Also read Chapters 7 (ER) and 8 (ER) for references Introduction to UML/DB Modeling. Toy library sample class diagram, in asta. |
Week #4 (9/14) |
Mapping UML data models to relational schema Introduction to the relational model |
Read Chapter 9. Mapping UML class diagrams to relational schema. Read Chapter 3 Introduction to the relational model. |
Week #5 (9/21) |
Relational Algebra | Read Chapter 6 Exercise for query languages Suggested solutions to odd number exercises (RA, RC, SQL) Relational Algebra, RA_RC_Symbols.docx Additional Materials: A RDB critical thinking example in concept map |
Week #6 (9/28) |
Relational Calculus Introduction to SQL Introduction to MySQL |
Read Chapter 6 Relational Calculus Read Chapter 4 An Introduction to SQL |
Week #7 (10/5) |
More SQL Query Optimization |
Read Chapter 5.1 An Introduction to SQL |
Week #8 (10/12) |
Mid-term examination: 10/12 (Tuesday) 1:00 - 3:00pm |
|
Week #9 (10/19) |
Web database developing with MySQL and PHP |
Read Chapter 14 PHP MySQL Web Development |
Week #10 (10/26) |
SQL Programming |
Read Chapter 5 SQL Programming |
Week #11 (11/2) |
Design principles of DB Systems Normalization theory |
Good and bad database design Read Chapter 15 Normalization |
Week #12 (11/9) |
Normalization theory |
Read Chapter 15 Normalization A FD Exercise |
Week 13 (11/16) |
Normalization theory |
Read Chapter 15 Normalization |
Week #14 (11/23) |
XML and Database Not a holiday as thanksgiving holiday starts on 11/24. |
Read Chapter 12 Introduction to XML, Introduction to XPath, Introduction to XQuery |
Week #15: (11/30) |
Physical DB architecture and design Concurrent control and transaction management |
Read Chapters 17, 20 & 21 Physical DB: A brief introduction Introduction to CC & TM |
Week #16 (12/7) |
Final Examination: 12/7 (Tuesday) 1:05- 3:05pm | Final examiniation will be conducted face to face. Closed book. However, you can bring an 'infomation' sheet: A4, print or write both sides, must be prepared by yourself. |
(*) Covered only if time permits. Not in the examinations.