C/C/28. Given the structure of the database required by a bookshop, the creation of tables in SQL and formulation of SQL scripts.

This project first creates the SQL tables required for the bookshop, according to the structure of the database that was given. Then SQL scripts are written for populating the database. Then SQL scripts are written for these specific relational database operations: Selection/Projection, Union, Set Difference, Intersection, Cartesian Product, Equijoin, Natural Join, Outer Join, Self join, Division as well as the SQL arithmetic operations of sum, count, average, minimum and maximum. The SQL scripts are written to create views, together with a description of whether they are updateable or not, and why. Each of the scripts of relational database operation, arithmetic operations and views are formulated to simulate a real-world operation.