|
CSC 261/461 Introduction to Databases (Spring 2020) |
|
Intructor: Eustrat Zhupa Lecture time: MW 3:25 - 4:40 (PM) Classroom: Lattimore 201 |
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, security issues and object databases.
It also looks at the new trends in databases, for example NoSQL systems.
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 semester-long
group project.
+ Syllabus
- Syllabus here
+ Schedule
Note: Work in progress ...
| Date | Topic | Readings | Notes |
|---|---|---|---|
| Wed, January 15, 2020 | Introduction | ||
| Mon, January 20, 2020 | |||
| Wed, January 22, 2020 | Database Model and Basic Definitions | ||
| Mon, January 27, 2020 | Introduction to SQL (part 1) | ||
| Wed, January 29, 2020 | SQL (part 2) | ||
| Mon, February 3, 2020 | SQL (part 3) | ||
| Wed, February 5, 2020 | More SQL | ||
| Mon, February 10, 2020 | First Midterm | ||
| Wed, February 12, 2020 | Joins, triggers, assertions | ||
| Mon, February 17, 2020 | ER Diagram | ||
| Wed, February 19, 2020 | Mapping to Relations | ||
| Mon, February 24, 2020 | Database Design, Normal Forms | ||
| Wed, February 26, 2020 | Database Design, Normal Forms | ||
| Mon, March 2, 2020 | Second Midterm | ||
| Wed, March 4, 2020 | HTML, PHP, and MySQL | ||
| Mon, March 9, 2020 | |||
| Wed, March 11, 2020 | |||
| Mon, March 16, 2020 | DB Design - FDs, minimal cover | ||
| Wed, March 18, 2020 | DB Design - Algorithms | ||
| Mon, March 23, 2020 | Relational Algebra | ||
| Wed, March 25, 2020 | Relational Algebra | ||
| Mon, March 30, 2020 | Third Midterm | ||
| Wed, April 1, 2020 | Indexing | ||
| Mon, April 6, 2020 | B+ Trees | ||
| Wed, April 8, 2020 | Hashing | ||
| Mon, April 13, 2020 | Query Processing | ||
| Wed, April 15, 2020 | Query Optimization | ||
| Mon, April 20, 2020 | Transactions | ||
| Wed, April 22, 2020 | NoSQL and MongoDB | ||
| Mon, April 27, 2020 | TBD | ||
| Wed, April 29, 2020 | Final Exam |
| Note | The schedule reflects the lecture dates, respective topics and the 'no lecture' days (in yellow). The ordering and list of topics is subject to change at the discretion of the instructor. |
+ 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.