Navigation auf uzh.ch
|Lecturer:||Prof. Dr. Michael Böhlen|
|Assistants:||AmirReza Alizade Nikoo, Jamal Mohammed|
|Teaching assistants:||Eric Egli, Stefano Benzoni,Gianluca Dvorak,Alessandro Vanzo|
|Teaching Tutors:||Xinyi Qin, Hyeongkyun Kim (Kaden)|
Objectives: The course provides an in-depth understanding of the foundations of database systems. It focuses on the relational data model and covers the following topics: relational algebra and calculus, SQL, relational database design, conceptual database design, physical database design, query processing and optimization, and transactions. The goals of this course are to learn the basic concepts underlying database systems; to understand how these concepts are implemented in concrete systems; and to get hands-on experience in using a database system.
Textbook: The textbook of the course is Fundamentals of Database Systems, 7th Edition, Ramez Elmasri and Shamkant B. Navathe, Pearson Education, 2016.
Evaluation: The course is evaluated through the final exam. The final exam is graded from 1 to 6 with quarter grades. The final exam is a closed-book exam and run as a BYOD (Bring-your-own-device) exama.
Teaching Format: The course consists of weekly lectures, labs and office hours. Every week an assignment is posted online and students are highly encouraged to solve this assignment prior to the next lab. The assignment is discussed in the lab one week after its publication. Solving the assignments is the best preparation for the final exam.
OLAT: All course-related information (including enrolment, lecture slides, assignments, exam etc.) will be published on the course's OLAT page.
Lectures: The lectures take place every Tuesday 12:15 - 14:00 and Friday 14:00 - 15:00.
Lab Exercises: During the semester, there will be twelve (12) weekly lab sessions. The exercises are not part of assessment and students are not required to submit solutions. Solving the lab exercises before the lab sessions and attending the lab sessions is one of the best ways to prepare for the final exam.
The labs will start in the 3rd week of the semester. The assignments will be published each week. Students will have 1 week to solve the exercises on their own. Then solutions will be discussed in the lab sessions.