CS2102

Materials

Notes

Slide

AY 2023/2024 Sem 2

Assignment

Midterm

AY 2022/2023 Sem 2

Assignment

Midterm

Practices: DDL

Single Table

Column

Table

Multiple Table

Foreign Key

Practices: SQL

Select

SELECT

Where

Part 1

Part 2

Order/Limit

Order/Limit

Tools

ER Diagram

Note

Slide

Tool

Armstrong Proof Checker

Note

Slide

Tool

Closure Algorithm

Note

Slide

Tool

Superkey Algorithm

Note

Slide

Tool

Key Algorithm

Note

Slide

Tool

Projection Algorithm

Note

Slide

Tool