CSCI 5333
Database Management Systems (DBMS)
Spring 2020
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 (1/21,23) |
Class starts 1/21/2020 (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 (1/28, 1/30) |
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. The context of UML class diagram in CM. |
| Week #3 (2/4, 2/6) |
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 (2/11, 2/13) |
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 (2/18, 2/20) |
Relational Algebra | Read Chapter 6 Exercise for query languages Relational Algebra, RA_RC_Symbols.docx Additional Materials: A RDB critical thinking example in concept map (*: if time allows) |
| Week #6 (2/25, 2/27) |
Relational Calculus Introduction to SQL Introduction to MySQL |
Read Chapter 6 Relational Calculus Read Chapter 4 An Introduction to SQL |
| Week #7 (3/3, 3/5) |
Mid-term examination: 3/5 (Thursday) 2:30-3:50pm | |
| Week #8 (3/10, 3/12) |
Spring break |
Happy vacation |
| Week #9 (3/17, 3/19) |
More SQL Query Optimization Web database developing with MySQL and PHP |
Read Chapter 5.1 An Introduction to SQL Read Chapter 14 PHP MySQL Web Development |
| Week #10 (3/24, 3/26) |
SQL Programming |
Read Chapter 5 SQL Programming |
| Week #11 (3/31, 4/2) |
Design principles of DB Systems Normalization theory |
Good and bad database design Read Chapter 15 Normalization |
| Week #12 (4/7, 4/9) |
Normalization theory |
Read Chapter 15 Normalization |
| Week 13 (4/14, 4/16) |
Normalization theory |
Read Chapter 15 Normalization |
| Week #14 (4/21, 4/23) |
XML and Database (will be skipped if time becomes an issue) |
Read Chapter 12 Introduction to XML, Introduction to XPath, Introduction to XQuery |
| Week #15: (4/28, 4/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 (5/5, 5/7) |
Final Examination: 5/5 (Tuesday) 1:05- 2:35pm | Final examiniation will be conducted through blackboard in an open book manner. Time allowed is 1 hour and 30 minutes so time management is important. We will have a short meeting at 1:00pm in Blackboard's Collaborate for 5 minutes for me to answer any questions. The final examination will start 5 minutes later (i.e 1:05 pm) and your solution must be submitted at the scheduled time. Late submission will have per minute penalty. |
(*) Covered only if time permits. Not in the examinations.