CSCI 585 Fall 2015 Course Syllabus
Textbook: “Database Systems”, by Coronel/Morris, ISBN:9781305425958
Alternate Textbooks: “Database System Concepts” by Silberschatz, Korth, and Sudarshan
; “Database Systems: The Complete Book” by Garcia-Molina, Ullman, and Widom;
“Database Management Systems” by Ramakrishnan and Gehrke
Planned Schedule
Week Date Topic Reading (C & M)
1 Introduction Chapter 1
Data Modeling Chapter 2
2, 3 Relational Model and E-R Chapters 3 & 4
Relational Algebra (cont.) Chapters 3 & 4
Basic SQL Chapter 7
4 Advanced Data Modeling Chapter 5
5 More SQL Chapter 8
6 Normalization Chapter 6
7 Review
Exam I
8, 9 Transaction Management Chapter 10
Performance Tuning Chapter 11
9,10 Performance Tuning Chapter 11
Distributed Chapter 12
Databases
11 Database Security Chapter 15
12,13 Databases and the Web Paper (to be provided)
Big Data
Data Visualization
14 TBD
Catch up
15 Final Exam