|
CSC 261/461 Introduction to Databases (Spring 2021) |
Intructor: Eustrat Zhupa Lecture time: MW 3:25 - 4:40 Classroom: Online |
Course Description
This course presents the fundamental concepts of database design and use. It provides a study of
data models, data description languages, and query facilities including relational algebra and SQL,
data normalization, transactions and their properties, physical data organization and indexing.
It also looks at the new trends in databases, for example NoSQL databases, etc. The knowledge of the above topics
will be applied in the design and implementation of a database application using a target database management system
as part of a group project.
+ Syllabus
- Syllabus here
+ Schedule
Date | Topic | Readings | Notes |
Mon, February 1, 2021 | Introduction | ||
Wed, February 3, 2021 | Database Model and Basic Definitions | ||
Mon, February 8, 2021 | Introduction to SQL (part 1) | M1 (02/07) |
|
Wed, February 10, 2021 | SQL (part 2) | ||
Mon, February 15, 2021 | SQL (part 3) | ||
Wed, February 17, 2021 | More SQL | ||
Mon, February 22, 2021 | First Exam | M2 (02/21) |
|
Wed, February 24, 2021 | Joins, triggers, assertions | ||
Mon, March 1, 2021 | ER Diagram | ||
Wed, March 3, 2021 | Study Break (no lecture) | ||
Mon, March 8, 2021 | Mapping to Relations | M3 (03/07) |
|
Wed, March 10, 2021 | Database Design, Normal Forms | ||
Mon, March 15, 2021 | Database Design, Normal Forms | ||
Wed, March 17, 2021 | Second Exam | ||
Mon, March 22, 2021 | HTML, PHP, and MySQL | M4 (03/21) |
|
Wed, March 24, 2021 | DB Design - FDs, minimal cover | ||
Mon, March 29, 2021 | DB Design - Algorithms | ||
Wed, March 31, 2021 | Relational Algebra | ||
Mon, April 5, 2021 | Relational Algebra | ||
Wed, April 7, 2021 | Third Exam | ||
Mon, April 12, 2021 | Indexing | ||
Wed, April 14, 2021 | B+ Trees | ||
Mon, April 19, 2021 | Hashing | ||
Wed, April 21, 2021 | Query Processing | ||
Mon, April 26, 2021 | Query Optimization | ||
Wed, April 28, 2021 | Transactions | ||
Mon, May 3, 2021 | NoSQL and MongoDB | ||
Wed, May 5, 2021 | Fourth Exam |
+ General Rules
Disability Services
- The University of Rochester respects and welcomes students of all backgrounds and abil- ities. In the event you encounter any barrier(s) to full participation in this course due to the impact of disability, please contact the Office of Disability Resources. The access coor- dinators in the Office of Disability Resources can meet with you to discuss the barriers you are experiencing and explain the eligibility process for establishing academic accommoda- tions. You can reach the Office of Disability Resources at: disability@rochester.edu; (585) 276-5075; Taylor Hall.
- After you receive accommodation approval, it is imperative that you reach out to the in- structor for the appropriate arrangements.
In an *unpleasant* event of cheating, department policies regarding academic dishonesty will apply.