CS 348: Introduction to Database Systems  

Fall 2022

Course Description

This course is an introduction to database management systems (DBMSs), which are the core software systems that applications use to store, manage, query, and manipulate very large-scale data efficiently. The course covers three core topics. (1) We cover the fundamental topics of database management, which include: the relational data model and its query languages; integrity constraints to enforce invariants about application data; indexes and views to make DBMSs efficient for an application workload; and transactions to ensure safe concurrent access to data, focusing on fundamental topics such as serializability and ACID guarantees of a DBMS. (2) We cover database design methodology, which shows how to design "good" databases instead of "bad" ones and how this can be made formal using the theory of normalization. (3) We cover a suite of topics about the internals and architectures of DBMSs: physical record design, query planning and optimization, indexes, and transaction protocols. While topics under (1) and (2) are topics from the perspective of DBMS users and administrators, and teach students how to use DBMSs efficiently in practice, topics under (3) is from the perspective of system engineers that actually implement the DBMS, and aims to engage students interested in the low-level implementations of the core data structures, algorithms, and protocols DBMSs use to support higher-level applications.

Text Book

Required: Database System Concepts (DSC) (Seventh Edition) Abraham Silberschatz, Henry F. Forth and S.Sudarshan, McGraw Hill. 
Optional: Data Intensive Applications (DIA), Martin Kleppman (First Edition), O'Reilly 

Schedule

Week Lecture Topics & Slides Readings Dates Important Dates
1 Overview of DBMSs, Course Overview, Administrative Information [l1.pdf] DSC Ch 1 Thu, Sep 8
2 Introduction to the Relational Model [l2.pdf] DSC Ch 2 Tue, Sep 13
SQL (1) [l3.pdf] DSC Ch 3 Thu, Sep 15
3 SQL (2) [l4.pdf] DSC Ch 4 Tue, Sep 20
Review lectures 2-4 [pdf] & Project brief Thu, Sep 22
4 SQL (3) [l5.pdf] DSC Ch 4,5 Tue, Sep 27 Project Milestone 0 Due
SQL (4) l6.pdf, l6-optional.pdf] DSC Ch 5 Thu, Sep 29 Assignment 1 Due
5 DB Design: DB Design E/R Model [l7.pdf] DSC Ch 6 Tue, Oct 4
DB Design: E/R-Relational Translation [l8.pdf] DSC Ch 6 Thu, Oct 6
6 Reading Week Oct10-14
7 DB Design: Theory (1) [l9.pdf, additional exercises] DSC Ch 7 Tue, Oct 18
DB Design: Theory (2) [l10.pdf] DSC Ch 7 Thu, Oct 20 Project Milestone 1 Due
8 Review lectures 5-10 [pdf] Tue, Oct 25
DBMS Architecture Overview & Physical Data Organization [l11.pdf] DSC Ch 12,13 Thu, Oct 27
9 Mon, Oct 31 Assignment 2 Due
Indexing [l12.pdf] DSC Ch 14 (Optional: DIA Ch 3) Tue, Nov 1
Midterm Review (Assignments 1 & 2) Thu, Nov 3
Fri, Nov 4 Midterm (4:30-6:00pm)
10 Query Processing [l13.pdf, l13-optional.pdf] DSC Ch 15 Tue, Nov 8
Query Optimization [l14.pdf] DSC Ch 16 Thur, Nov10
11 Review lectures 11-14 Tue, Nov 15
Transactions [l15.pdf] DSC Ch 17 (Optional: DIA Ch 7) Thur, Nov 17 Project Milestone 2 Due
12 Transactions (l15) cont. Tue, Nov 22
Concurrency & Recovery (optional, video) [l16.pdf] DSC Ch 18 and 19 Thu, Nov 24 Assignment 3 Due
13 Project demo week Tue, Nov 29
Project demo week Thur, Dec 1 Project Final Report Due
14 Final Review (Assignments 2 & 3) Tue, Dec 6
15 Exam week Tue, Dec 13 Final (7:30pm-10pm)
Note that the schedule is subject to change. Contingency plan: we may consider online mode for the class for special situations.

Assignments

Crowdmark will be used to submit non-coding assignments. When the CrowdMark instance is ready, all students enrolled in the class will receive an email with a link to their individual submission site. In order to submit, upload a separate PDF file (multiple pages are allowed) to each question. You may resubmit as often as necessary until the due date. (More detailed CrowdMark information is available at https://crowdmark.com/help/completing-and-submitting-an-assignment/.)

Marmoset will be used for the programming questions. More details will be provided in individual assignments.

Assignment release dates and due dates are as follows (dates are tentative and may change):

Assignment Date Posted Due (11:59pm EDT/EST) Hand In Via Markers
1 (lectures 1-4) Tue, Sep 13 Thur, Sep 29 Crowdmark   Marmoset Krishna Kanth Arumugam, Partha Chakraborty
2 (lectures 5-10) Tue, Oct 4 Mon, Oct 31 Crowdmark   Chang Liu, Ruoxi Zhang
3 (lectures 11-15) Tue, Nov 8 Thur, Nov 24 Crowdmark Nimmi Rashinika Weeraddana, Ruoxi Zhang

Instructions for Assignments: Your written solutions will be judged not only for correctness but also for the quality of your presentation and explanations.

Collaboration Policy: The work you hand in must be your own. Unless specified otherwise, you can always use any result from the textbook, notes, or previous assignment just by citing it. You may discuss the assignment questions verbally with others, but you should come away from these discussions with no written or electronic records and you must acknowledge the discussion. Acknowledge any sources you have used. Any assistance received (from human or nonhuman sources) that is not given proper citation may be considered a violation of the university policies.

Late Policy:

Project

The group project is optional. You can choose between doing the group project or having higher weighted exams (refer to the Mark Breakdown section below).

Learn will be used to submit the group project. Detailed instructions will be given in week 2.

Milestone Due (11:59pm EDT/EST)
0 (Team up) Tue, Sep 27
1 (Proposal) Thur, Oct 20
2 (Midterm Report) Thur, Nov 17
3 (Final Report & Demo) Thur, Dec 1

Piazza

We will use Piazza for all course announcements and as a forum for students to ask and answer questions. So you should enroll yourself at your earliest convenience. During Piazza discussions, please do not reveal the solutions to the assignments by requesting or offering detailed advice. We'll delete comments that reveal too much. Violations can result in academic sanctions.

Similarly, do not solicit hints or provide hints about how to solve the homework problems on other bulletin boards, such as Facebook. Violations can result in academic sanctions.

Piazza is not the place to dispute how assignments are marked. If you have a complaint, please follow the process given below.

Organization

Instructor Email (@uwaterloo.ca) Office Hours
Xi He  (xihe) Weds, 2-3pm (see Piazza for Zoom link)

Instructional Apprentices and Teaching Assistants Email (@uwaterloo.ca)
Guy Coccimiglio (gccoccim)
Glaucia Melo (gmelodos)
Krishna Kanth Arumugam (kkarumug)
Partha Chakraborty (p9chakra)
Chang Liu (c589liu)
Nimmi Rashinika Weeraddana (nrweerad)
Ruoxi Zhang (r378zhan)
Instructional Support Coordinator Email (@uwaterloo.ca)
Sylvie Davies (sldavies)

Mark breakdown

Two marking schemes, depending on whether you choose to do the group project:

Points of contact for common questions

Note: If you decide to e-mail the course staff, you must use your uwaterloo Quest e-mail account (WatIAM/Quest userID @uwaterloo.ca); otherwise we cannot verify who you are and are limited on what we can accept and respond to.

Help Topic Contact
Assignment: Missed Deadline We do not accept emailed assignments. The last files submitted before the deadline will be marked (submit early and often, even if not finished).
If the deadline is missed due to illness or other valid, verifiable reason, see Missed Work Due To Illness below.
Assignment: Marking Error Re-mark request, due within one week of release of marks on CrowdMark/Markoset. Contact the TA who marked the specific question and submit a written request. See TAs for contact information.
Assignment: Recording Error Grades will be made available through Marmoset and Crowdmark. Official marks will finally be on Learn. If you notice an error in the recorded value, please contact Sylvie Davies (CS 348 ISC).
Enrollment If Quest won't let you enroll or switch LEC or TUT sections without a permission/override number: Instructors and course staff are unable to help you—you must see a CS academic advisor.
General Course Help Check office hours.
Missed Work due to Illness or Valid & Verifiable Reason (Assignments, Exams) Validation required. See Verification of Illness Services but substitute Sylvie Davies (CS 348 ISC) for references to instructor. Make sure you also read the Math Faculty document on the consequences of submitting a VIF.
Accessibility Services (AAS) exam accommodation forms (request to write at AAS) Submit to AAS at least 3 weeks before exam

Course policy and other information

Plagiarism

Plagiarism is a very serious academic offence and is penalized accordingly. When you plagiarize you damage the learning experience for yourself and others. To avoid plagiarism accusations, do not copy other people's work, and cite all references that you use. If you work with others, only discuss general aspects of the course material, not specific solutions. Write up the solutions yourself, not in groups.

Mental Health Resources

Mental Health: If you or anyone you know experiences any academic stress, difficult life events, or feelings like anxiety or depression, we strongly encourage you to seek support.

On-campus Resources

Off-campus Resources

Diversity: It is our intent that students from all diverse backgrounds and perspectives be well served by this course, and that students’ learning needs be addressed both in and out of class. We recognize the immense value of the diversity in identities, perspectives, and contributions that students bring, and the benefit it has on our educational environment. Your suggestions are encouraged and appreciated. Please let us know ways to improve the effectiveness of the course for you personally or for other students or student groups. In particular:

University Policies (University required text)

Academic Integrity:
In order to maintain a culture of academic integrity, members of the University of Waterloo community are expected to promote honesty, trust, fairness, respect and responsibility. All members of the UW community are expected to hold to the highest standard of academic integrity in their studies, teaching, and research. The Office of Academic Integrity's website ( http://www.uwaterloo.ca/academicintegrity) contains detailed information on UW policy for students and faculty. This site explains why academic integrity is important and how students can avoid academic misconduct. It also identifies resources available on campus for students and faculty to help achieve academic integrity in - and out - of the classroom.

Grievance:
A student who believes that a decision affecting some aspect of his/her university life has been unfair or unreasonable may have grounds for initiating a grievance. Read Policy 70 - Student Petitions and Grievances, Section 4, http://www.adm.uwaterloo.ca/infosec/Policies/policy70.htm .

Discipline:
A student is expected to know what constitutes academic integrity, to avoid committing academic offenses, and to take responsibility for his/her actions. A student who is unsure whether an action constitutes an offense, or who needs help in learning how to avoid offenses (e.g., plagiarism, cheating) or about "rules" for group work/collaboration should seek guidance from the course professor, academic advisor, or the Undergraduate Associate Dean. When misconduct has been found to have occurred, disciplinary penalties will be imposed under Policy 71 - Student Discipline. For information on categories of offenses and types of penalties, students should refer to Policy 71 - Student Discipline, http://www.adm.uwaterloo.ca/infosec/Policies/policy71.htm.

Avoiding Academic Offenses:
Most students are unaware of the line between acceptable and unacceptable academic behaviour, especially when discussing assignments with classmates and using the work of other students. For information on commonly misunderstood academic offenses and how to avoid them, students should refer to the Faculty of Mathematics Cheating and Student Academic Discipline Policy, https://uwaterloo.ca/math/current-undergraduates/regulations-and-procedures/cheating-and-student-academic-discipline-guidelines.

MOSS (Measure of Software Similarities) is used in this course as a means of comparing students' assignments to ensure academic integrity. We will report suspicious activity, and penalties for plagiarism/cheating are severe. Please read the available information about academic integrity very carefully.

Discipline cases involving any automated marking system such as Marmoset include, but are not limited to, printing or returning values in order to match expected test results rather than making an actual reasonable attempt to solve the problem as required in the assignment question specification.

Appeals:
A student may appeal the finding and/or penalty in a decision made under Policy 70 - Student Petitions and Grievances (other than regarding a petition) or Policy 71 - Student Discipline if a ground for an appeal can be established. Read Policy 72 - Student Appeals, https://uwaterloo.ca/secretariat/policies-procedures-guidelines/policy-72 .