CS2102-Project

Files

1. proc.sql

This file contains the procedures, functions and triggers relevant to our application.

2. schema.sql

This file contains the relational schema for our application.

Notation

Naming

1. All variables are named in CamelCase
2. Constraints are indicated by being preceded by _c_
3. Triggers are indicated by being preceded by _t_, and trigger functions by _tf_
4. Functions are indicated by being preceded by _f_
5. Procedures are indicated by being preceded by _p_

Schema

1. All key constraints are written as table constraints
2. All data integrity constraints involving a single attribute are written as column constraints