DASC 5333
Database Systems for Data Science
CSCI 4333 Design of Database Systems
Spring 2024
Lecture Notes and Syllabus
by K. Yue
The syllabus is tentative. Actual contents and order of coverage may change. There will be around eight homework assignments, the actual number is subjected to changes. Additional materials are topics that may be covered if time allows.
Date |
Contents |
Comments |
| Week #1 (1/16,17): MW for CSCI 4333, T for DASC 5333 |
An Introduction and overview of database systems An introduction to Microsoft's Access |
Read Ricardo Chapter 1 Introduction to the course Introduction to MS Access |
| Week #2 (1/22-24) |
An introduction to Microsoft's Access An introduction to simple SQL and MySQL Database basics |
Introduction to MS Access DB Basics Read Ricardo Chapter 2, 4.2, 4.3, 4.4 The Relational Model Read Ricardo Chapter 3 A First Look at SQL Read Ricardo 4.1, 4.2, 5.1, 5.2, 5.4.1 and 5.4.2 |
| Week #3 (1/29-31) |
9/4 Monday Labor Day, university holiday. An introduction to the relational database model An introduction to conceptual data modeling |
Introduction to DB Modeling. Read Chapters 3 and 10. |
| Week #4 (2/5-2/7) |
Data modeling using UML |
Introduction to UML/DB Modeling |
| Week #5 (2/12-14) |
UML modeling Mapping UML data models to relational schema |
Read Chapter 10. Mapping UML Class Diagrams to the relational model |
| Week #6 (2/19-21) |
Introduction to Relational Algebra (RA) and Relational Calculus (RC) SQL |
Read Ricardo 4.5 toyu Query Exercise (in PDF) Introduction to RA and RC Read Ricardo 5.3 to 5.4 An introduction to SQL and MySQL Read Ricardo 5.5-5/8, 9.1, 9.2 Suggested MySQL solution to even numbered questions of toyu exercises |
| Week #7 (2/26-28) |
SQL More SQL |
More SQL |
| Week #8 (3/4-3/6) |
More SQL, Q&A Mid-term Exam, in person, class time (one hour 20 minutes):
|
Mid-term examination will be conducted in face, unless changes in pandemic situation. Closed book. However, you can bring an 'information' sheet: |
| Week #9 (3/11-3/13) |
Spring Break Week Introduction to Python Embedded SQL Programming |
Introduction to Python Read Ricardo Chapter 6 MySQL programming in Python |
| Week #10 (3/18-3/20) |
Embedded SQL Programming Web DB development with Python Introduction to Database Design Normalization theory and normal forms |
MySQL Python Web Development Introduction to Database Design Introduction to Functional Dependency and Normal Forms |
| Week #11 (3/25 - 3/27) |
Normalization theory and normal forms |
Theory of Functional Dependency Normal Forms and Normalization Theory Read Ricardo Chapter 14 |
| Week #12 (4/1-4/3) |
Normalization theory and normal forms |
|
| Week #13 (4/8-10) |
Normalization theory and normal forms Transaction Management Introduction to NoSQL database Last day to withdraw: April, 11. |
Transaction management Introduction to NoSQL database |
| Week #14 (4/15-17) |
NoSQL DB: MongoDB |
Introduction to Mongo DB |
| Week #15 (4/22-24) |
DB Security Physical database |
DB Security and SQL Injection Physical database |
| Week #16 (4/29-5/1) |
CSCI 4333 will have classes on Monday Final Examination:
|
Final examination will be conducted in face, unless changes in pandemic situation. Closed book. However, you can bring two 'information' sheets: letter size, can be printed or written on both sides, which must be prepared by yourself. |
(*) Covered only if time permits. Not in the examinations.