CSC261 Database Systems
Intructor: Eustrat Zhupa
Lecture time: MW 12:30 - 13:45
Classroom: Harkness 115
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 here
|09/05/18||Database Model|| |
Slides from lecture hereRequired 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/29/18||HTML, PHP, and MySQL|
|11/28/18||Query Processing (Sorting and Join)|
|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.|
- 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: firstname.lastname@example.org; (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.