Atabase Systems (Entity-Relationship Modelling, Relational Model, SQL and Relational Database Design)

-the uploaded file has six pages, just ignore first two pages. The assignment starts at page 3.
-All SQL must be compatible with PostgreSQL 9.2.4. SQL obtained through the use of any code generation tool is not allowed.
-the assignment has two parts. th