|
CSC261 Database Systems |
|
Intructor: Eustrat Zhupa Lecture time: MW 12:30 - 13:45 Classroom: Harkness 115 |
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, Big Data, MapReduce, and NoSQL.
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
| Date | Topics | Readings |
|---|---|---|
| 08/29/18 | Introduction | Lecture notes |
| 09/03/18 | ||
| 09/05/18 | Database Model | Slides from lecture here Required readings: Lecture notes + textbook 2.1, 2.2, 5.1 Optional readings: Textbook 2.3, Codd's paper here |
| 09/10/18 | Introduction to SQL (part 2) | 6.1 |
| 09/12/18 | Introduction to SQL (part 3) | 5.2, 5.3.1 - 5.3.3, 6.2 |
| 09/17/18 | SQL (part 4) | 6.3 |
| 09/19/18 | SQL (5) | 6.4, 7.1.1-7.1.5, 7.1.7 - 7.1.8 |
| 09/24/18 | SQL (6) | 7.1.6, 7.2, 7.3, 30.2.5 |
| 09/26/18 | ER Model | 3.1 - 3.6, 3.7.1, 3.7.2, 3.7.3 |
| 10/01/18 | ER Diagram to Relation Mapping | 9.1 |
| 10/03/18 | Database Design | |
| 10/08/18 | Database Design | |
| 10/10/18 | Midterm Review | |
| 10/15/18 | ||
| 10/17/18 | Midterm Examination | |
| 10/22/18 | Database Design | |
| 10/24/18 | Database Design | |
| 10/29/18 | HTML, PHP, and MySQL | |
| 10/31/18 | Relational Algebra | |
| 11/05/18 | Relational Algebra | |
| 11/07/18 | Relational Algebra | |
| 11/12/18 | Relational Algebra | |
| 11/14/18 | File Structures | |
| 11/19/18 | Indexing | |
| 11/21/18 | ||
| 11/26/18 | Indexing | |
| 11/28/18 | Query Processing (Sorting and Join) | |
| 12/03/18 | Query optimization | |
| 12/05/18 | MongoDb | |
| 12/10/18 | Transactions | |
| 12/12/18 | Review | |
| Mon 12/17/18 | Final Exam | Harkness 115, 7:15PM |
| 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.
In an *unpleasant* event of cheating, department policies regarding academic dishonesty will apply.