Tradewins Database Modifications.zip (462.43 KB)
This script was the final assignment for the introduction to the Oracle database class. In the assignment, we tested our SQL skills by creating several scripts that would "enhance" the Northwind Database. The enhancement scenarios include:
- Allowing for better tracking of product stock levels amongst its three different warehouses.
- The modification of the customer code field, so that it can not be modified by users of the database.
- The centralization of country data by creating a country lookup table.
- The addition of a courtesy field on the Employees table.
See the ERD included in the attached file for more information about modifications and for the SQL that was used to achieve this.