CS 186. Introduction to Database Systems
Catalog Description: Access methods and file systems to facilitate data access. Hierarchical, network, relational, and object-oriented data models. Query languages for models. Embedding query languages in programming languages. Database services including protection, integrity control, and alternative views of data. High-level interfaces including application generators, browsers, and report writers. Introduction to transaction processing. Database system implementation to be done as term project.
Units: 4
Related Areas:
Prerequisites: COMPSCI 61C or COMPSCI 47C. COMPSCI 47C may be taken as a co-requisite for transfer students.
Credit Restrictions: Students will receive no credit for COMPSCI 186 after completing COMPSCI W186. A deficient grade in COMPSCI 186 may be removed by taking COMPSCI W186.
Formats:
Spring: 3.0 hours of lecture and 1.0 hours of discussion per week
Fall: 3.0 hours of lecture and 1.0 hours of discussion per week
Grading Basis: letter
Final Exam Status: Written final exam conducted during the scheduled final exam period
Class Schedule (Spring 2025):
CS 186 – MoWe 10:00-11:29, Soda 306 –
Alvin Cheung, Lakshya Jain
Class Notes
* Prereqs systematically enforced: Only declared EECS/CS majors who have passed CS 61C and have a letter grade or have completed or are concurrently enrolled in CS 47C will be allowed to enroll/waitlist for CS 186.
* NO exceptions to enforced prerequisites will be granted. If you currently taking or are waiting for a grade for CS 61C, you will be able to enroll/waitlist for the class once you can see the grade on your CalCentral.
* Time conflicts ARE allowed.
* The in-person lecture will be recorded for playback later.
* Final exams are IN PERSON ON CAMPUS only!
* One alternate final timeslot will be offered, which will be right after the main final. This will be the ONLY alternate final offered (barring DSP exceptions, which will be worked out with the DSP office on an individual basis).
Class Schedule (Fall 2025):
CS 186 – MoWe 10:00-11:29, Soda 306 –
Alvin Cheung
Class Notes
* Time conflicts ARE allowed but no alternate final exam offered.
* The lecture WILL be recorded for playback later but no alternate final exam will be offered.
Links: