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

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 (Fall 2024):
CS 186 – MoWe 10:00-11:29, Soda 306 – Alvin Cheung

Class Schedule (Spring 2025):
CS 186 – MoWe 10:00-11:29, Soda 306 – Alvin Cheung, Lakshya Jain

Class homepage on inst.eecs

Related Areas:

• Database Management Systems (DBMS)