CS348: Introduction to Database Management
Fall, 2018

NOTE: There are two tutorials on Wednesday, December 12th, and Thursday, December 13th, that will take place in RCH 307 from 3pm to 4pm.

LECTURES

Section 1: Tuesday and Thursday from 8:30am to 9:50am in MC 4021.
Section 2: Tuesday and Thursday from 1:00pm to 2:20pm in MC 4045.
Section 3: Tuesday and Thursday from 2:30pm to 3:50pm in MC 4045.

INSTRUCTOR

Grant Weddell
Office: DC 3346; Phone: x34463
gweddell@uwaterloo.ca
Office hours: Tuesdays, from 11:00am to noon.

TEACHING ASSISTANTS / INSTRUCTIONAL APPRENTICE

Xiao Meng
x36meng@uwaterloo.ca
Office hours: Mondays, from 3:00pm to 4:00pm, in MC 4065.

Chang Ge
c4ge@uwaterloo.ca
Office hours: Tuesdays, from noon to 1:00pm, in MC 4065.

Ahmed Aljmiai
aaljmiai@uwaterloo.ca
Office hours: Wednesdays, from 10:00am to 11:00am, in MC 4065.

Hemant Saxena
h2saxena@uwaterloo.ca
Office hours: Wednesdays, from 11:00am to noon, in MC 4065.

Georgios Michalopoulos
gmichalo@uwaterloo.ca
Office hours: Wednesdays, from 3:00pm to 4:00pm, in MC 4065.

Michael Azmy
mwazmy@uwaterloo.ca
Office hours: Thursdays, from noon to 1:00pm, in MC 4065.

Amine Mhedhbi
mamhedhb@uwaterloo.ca
Office hours: Fridays, from 3:30pm to 4:30pm, in MC 4065.

Nalin Chhibber
nchhibbe@uwaterloo.ca
Office hours: Fridays, from 4:30pm to 5:30pm, in MC 4065.

TEXTBOOK

Database System Concepts (Sixth Edition)

Abraham Silberschatz, Henry F. Forth and S.Sudarshan, McGraw Hill, 2009.

There are quite a few copies of the course text that may be borrowed for three hour periods from the math library circulation desk. The call number TBA.

GRADING

Four assignments: weighting 20% total.
Midterm: weighting 30%.
Final exam: weighting 50%.

READING ASSIGNMENTS

Chapter 1 of the course text.
Sections 2.1-4 and 6.3 of the course text.
Chapter 3 of the course text.
Chapter 4 of the course text (advanced SQL).
Sections 5.1, 5.2 and 5.3 of the course text.
Sections 7.1-5, 7.7, 7.8 and 7.9.1 of the course text.
Section 7.6 of the course text.
Sections 8.1 through 8.6 of the course text.

PROGRAMMING AND WRITTEN ASSIGNMENTS

Requests for remarking assignment submissions can be made by sending email to the the Instructional Support Coordinator at ddvorski@uwaterloo.ca.

Assignment 1.
Assignment 2. Sample commands for (re)creating the student enrollment database are here. UPDATE: Assignment submission is now through the submit command. To submit your assignment, use the following: "submit cs348 a2 ." Note that you should be submitting ten files with the file names 1.sql, 2.sql and so on, with each file i.sql containing the SQL code for question i.
Assignment 3. Sample commands for (re)creating the bibiography database are here. Sample embedded SQL programs and a Makefile are here. Assignment submission is again through the submit command. To submit your assignment, use the following: "submit cs348 a3 .". Note that you should be submitting three files with names "bibauthor.sqc", "bibcontent.sqc", and "compile". A file called "makefile" can be submitted instead of "compile".
Assignment 4. Again, use the submit command to submit your assignments: "submit cs348 a4 .". Note that you should be submitting one file with the name "a4.pdf", as explained in the assignment text. UPDATE: The due date is now at noon on Thursday, November 22nd.

MIDTERM

The midterm will take place for all students who have not made special arrangements at 4:30pm on Friday, November 2nd. Note that the duration is 80 minutes, and that the midterm itself is a closed book examimation. An example of a midterm that Professor Weddell has given in the past is here. Except for the second part of the third question that requires deriving a relational schema from a given ER schema, all questions are on topics that might be tested.

FINAL

The final exam will take place on Saturday, December 15th, at 9:00am in DC 1350 and DC 1351. You can download a sample of a final exam I have given for an ealier version of this course here.

LECTURE MATERIAL

ACADEMIC INTEGRITY

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 (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, http://www.math.uwaterloo.ca/navigation/Current/cheating_policy.shtml

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, http://www.adm.uwaterloo.ca/infosec/Policies/policy72.htm