Lecture Time and Place
Location: MSTB 118;
Canvas: COMPSCI 220P LEC A: DATABAS & DATA MGMT (35210) (uci.edu)
GradeScope: CS 220P Dashboard | Gradescope
Time:
5:00- 6:20 pm PST on Tuesday, Thursday
Lab Time and Place
Friday 10:00- 10:50 am, SSL 140
Grading Criteria
Assignments - 45 %
Mid-term Exam - 25 %
End Term Exam - 30 %
Exam Dates:
Mid-term Exam: (during class hours)
2nd class of week 6 (Nov. 7)
End-term Exam: (during class hours)
Dec 5 Thursday 5:00pm - 6:20pm
Instructor
Sharad Mehrotra (sharad AT ics DOT uci DOT edu)
TA
Keming Li (kemingl1 AT uci DOT edu), office hour: Fri 2:00pm-2:50pm, location: ICS 415.
Shiyuan (Eric) Zhou (szhou20 AT uci DOT edu), office hour: Fri 10:00am-10:50am, location: ICS 458F
Office hours won't be hosted on holidays.
Reader
TBD (TBD)
Course Objectives and Goals
This course provides students with an introduction to the design of databases and the use of database management systems for applications. We will cover the entity relationship (E/R) approach to database design. We will cover the relational data model, mapping E/R designs to relations, relational design theory, abstract query language such as relational algebra, and programming in SQL. Students will get exposure on how to program with relational database management systems. Time permitting, we will also consider some key database technologies including indexing and transactions. We will also introduce students to semi-structured data and NoSQL movement. This course is aimed at database design and use of database management systems in implementing database applications. It does NOT cover the implementation of database management systems which will be covered in extensive details in the follow-on courses CS 222, CS 223 and CS 224.
Pre-requisites
Students should have some experience of programming in at least Python.
Homework Assignments
Homework assignments must be turned in by the assigned due dates/times. Turning in an assignment will involve submitting the solution to the Gradescope. There will be 7 assignments which will be carrying 45% of the total grade.
Grade Change Policy
For all of the graded assignments as well as the midterm exam, if you disagree with the grading, you may discuss your concerns with the relevant instructor (professor, TA, or reader) within two weeks after they are returned. After that, all grades will be considered final.
Your graded assignment will identify the specific reader/TA/instructor who graded your assignment/exam. It is best to first approach the very same grader with your request. In case of dispute, you can meet the instructors' -- the best time would be the instructor office hours to handle these issues (or you can make a separate appointment).
Collaboration Policy
All homework assignments are to be completed solo or in groups of at most 3 students.
See http://www.ics.uci.edu/ugrad/policies/index.php#academic_honesty for a good discussion of what is/isn't considered honest collaboration.
Late Policy
The due date will be clearly indicated on all problem sets and projects. Assignments will NOT be accepted after the due date. We will strive to post the solutions immediately after the due date of the assignment which precludes the possibility of allowing late submissions. If you find yourself in a special situation which prevents you from submitting multiple assignments in time, please talk to the instructor for special permission.
Academic Honesty Policy
Cheating is one area where the instructor for this course has zero patience or sympathy. You are here to learn, and cheating defeats that purpose. All students will be expected to adhere to the UCI and ICS Academic Honesty policies (see http://www.editor.uci.edu/catalogue/appx/appx.2.htm#academic andhttp://www.ics.uci.edu/ugrad/policies/index.php#academic_honesty to read their details). Any student found to be involved in cheating or aiding others in doing so will be academically prosecuted to the maximum extent possible: that means you will fail this course. (Ask around.) Just say no to cheating!
Discussion Forum for All Things CS220P
This term we will be using Ed for online class discussions. The system is highly catered to getting you the help you need fast and efficiently from classmates, the TAs, the Reader, and the instructor. Rather than emailing course or HW content questions to the teaching staff, you will be expected to post your questions on Ed.
Please find Ed for this class or through Canvas.