COMPSCI 186: Introduction to Database Systems
Course exam catalog and study material archive for Introduction to Database Systems at University of California, Berkeley (UCB). Request verified past exam papers and study resources directly through our student community.
This archive catalogs 8 free educational resources and past exams for COMPSCI 186 (Introduction to Database Systems) at University of California, Berkeley (UCB), containing 2 midterm papers, 5 final examinations, and 1 study guide. Dated documents represent 5 distinct academic years between 2018 and 2022.
Core Exam Topics & Learning Objectives
- Relational database design: entity-relationship (ER) modeling and schema normalization (1NF-BCNF) in COMPSCI 186
- Declarative query formulation: advanced SQL joins, subqueries, grouping aggregations, and window functions
- Transaction management: ACID guarantees, serializability, two-phase locking (2PL), and WAL recovery
- Physical storage and query execution: B+ tree indexing, hash indexes, and query optimization in Introduction to Database Systems
Study Resource for Introduction to Database Systems
Study Resource
Final Exam 2018
University of California, Berkeley (UCB) COMPSCI 186 Final Exam 2018
Study Resource
Midterm (Exam 1) 2019
University of California, Berkeley (UCB) COMPSCI 186 Midterm (Exam 1) 2019
Study Resource
Final Exam 2019
University of California, Berkeley (UCB) COMPSCI 186 Final Exam 2019
Study Resource
Final Exam 2020
University of California, Berkeley (UCB) COMPSCI 186 Final Exam 2020
Study Resource
Midterm (Exam 1) 2021
University of California, Berkeley (UCB) COMPSCI 186 Midterm (Exam 1) 2021
Study Resource
Final Exam 2021
University of California, Berkeley (UCB) COMPSCI 186 Final Exam 2021
Study Resource
Final Exam 2022
University of California, Berkeley (UCB) COMPSCI 186 Final Exam 2022
Study Resource
Study Guide 5
University of California, Berkeley (UCB) COMPSCI 186 Study Guide 5
Assessment Inventory for COMPSCI 186 (8 Documents)
| Document | Format | Year | Access |
|---|---|---|---|
| Final Exam 2022 | Final | 2022 | Illustrative Archive |
| Midterm (Exam 1) 2021 | Midterm | 2021 | Illustrative Archive |
| Final Exam 2021 | Final | 2021 | Illustrative Archive |
| Final Exam 2020 | Final | 2020 | Illustrative Archive |
| Midterm (Exam 1) 2019 | Midterm | 2019 | Illustrative Archive |
| Final Exam 2019 | Final | 2019 | Illustrative Archive |
| Final Exam 2018 | Final | 2018 | Illustrative Archive |
| Study Guide 5 | Study Guide | — | Illustrative Archive |
| Complete inventory of all 8 assessments (sorted by most recent). Select any document to inspect or use the search bar above to filter. | |||
Frequently Asked Questions
Which assessment formats are cataloged in this COMPSCI 186 archive?
This collection for COMPSCI 186 at University of California, Berkeley (UCB) catalogs 8 total resources across the following formats: Midterms, Finals, Study Guides. Each document is listed in the assessment inventory table below with its individual format tag and academic year where recorded.
What academic years are covered in this COMPSCI 186 collection?
Dated materials in this archive span from 2018 to 2022, representing 5 distinct academic years. Coverage varies by the records currently cataloged for this course.
How can students access these free COMPSCI 186 past exams?
All cataloged COMPSCI 186 past exams and study materials are free to request. The catalog, metadata, assessment inventory, and illustrative thumbnails are public; source documents are not shown on this page. Use the connect options to request a study resource, and confirm current course topics and grading policies with the University of California, Berkeley (UCB) course syllabus.