<aside> ⚠️

Please use these notes only as a supplement to the lecture slides, for two reasons:

1. The lecture material may have changed since these notes were written
2. These notes focus mainly on challenging & confusing topics, as I did not bother covering stuff I found easy. </aside>

Notes

DBMS & ER Diagram

SQL

Relational Algebra

Integrity Constraints

FD & Normalization

Query Optimization

Concurrency Control

Others

The following material not covered in lectures. I created this when working on the Group Project

SQL-Java: Oracle JDBC