COMPSCI 2DB3: Databases
Relational database management systems covering relational algebra, SQL querying, Entity-Relationship modeling, schema normalization, transaction management, indexing, and ACID properties.
Independent study archive Learn more
Materials are uploaded by users for self-study purposes. PwnHero is an independent platform, not affiliated with, sponsored by, or endorsed by any university or institution.
Common aliases: COMPSCI 2DB3
Study Resources for Databases
Midterm (Exam 1) 2012
Midterm (Exam 2) 2011
Final Exam 2014
Midterm (Exam 1) 2014
Midterm (Exam 1) 2015
Midterm (Exam 1) 2016
Midterm (Exam 1) 2018
Midterm (Exam 1) 2019
Midterm (Exam 1) 2020
Worksheet 9
Assessment Inventory for COMPSCI 2DB3 (10 Documents)
| Document | Format | Year | Access |
|---|---|---|---|
| Midterm (Exam 1) 2020 | Midterm | 2020 | Illustrative Archive |
| Midterm (Exam 1) 2019 | Midterm | 2019 | Illustrative Archive |
| Midterm (Exam 1) 2018 | Midterm | 2018 | Illustrative Archive |
| Midterm (Exam 1) 2016 | Midterm | 2016 | Illustrative Archive |
| Midterm (Exam 1) 2015 | Midterm | 2015 | Illustrative Archive |
| Final Exam 2014 | Final | 2014 | Illustrative Archive |
| Midterm (Exam 1) 2014 | Midterm | 2014 | Illustrative Archive |
| Midterm (Exam 1) 2012 | Midterm | 2012 | Illustrative Archive |
| Midterm (Exam 2) 2011 | Midterm | 2011 | Illustrative Archive |
| Worksheet 9 | Worksheet | — | Illustrative Archive |
Complete inventory of all 10 assessments (sorted by most recent). Select any document to inspect or use the search bar above to filter.
Course Overview & Exam Syllabus
This archive catalogs 10 free educational resources and past exams for COMPSCI 2DB3 (Databases) at McMaster University, containing 8 midterm papers, 1 final examination, and 1 worksheet. Dated documents represent 8 distinct academic years between 2011 and 2020.
Core Exam Topics & Learning Objectives
- Relational database design: entity-relationship (ER) modeling and schema normalization (1NF-BCNF) in COMPSCI 2DB3
- 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 Databases
Frequently Asked Questions
Which assessment formats are cataloged in this COMPSCI 2DB3 archive?
This collection for COMPSCI 2DB3 at McMaster University catalogs 10 total resources across the following formats: Midterms, Finals, Worksheets. Each document is listed in the assessment inventory table with its individual format tag and academic year where recorded.
What academic years are covered in this COMPSCI 2DB3 collection?
Dated materials in this archive span from 2011 to 2020, representing 8 distinct academic years. Coverage varies by the records currently cataloged for this course.
How can students access these free COMPSCI 2DB3 past exams?
All cataloged COMPSCI 2DB3 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 McMaster University course syllabus.