Name		Name	Last commit message	Last commit date
parent directory ..
CS2102 Finals Cheatsheet.pdf		CS2102 Finals Cheatsheet.pdf
CS2102 Midterms Cheatsheet.pdf		CS2102 Midterms Cheatsheet.pdf
README.md		README.md

README.md

CS2102 - Database Systems (Cheatsheets)

Taught by Dr Chan Chee Yong and Prof Xiao Xiaokui, AY20/21 Semester 2

^{Midterms cheatsheet contains content on Relational Algebra, SQL and Entity-Relationship Model.}

^{Finals Cheatsheet}

Concepts Covered

Introduction to DBMS
Relational Algebra
SQL
Entity-Relationship Model
Statement-Level & Call-Level Interfaces
SQL/Persistent Stored Modules - PL/pgSQL
- Functions & Procedures
- Triggers
SQL Injection Attacks
Normal Forms
- Functional Dependencies
- BCNF & 3NF