This repository contains materials used to create normalized simple school database.
- Metadata is excel file that describes the data to be inserted.
- Create-school-databse is a SQL script that creates normalized school database.
- Create the database and tables
- Create the constraints of each tables.
- Create the base views for each table
- Create one reporting view that combines the data for all the tables
- Create the transactional stored procedures for each table
- Set the appropriate permission on the tables, views, and stored procedures for the public role
- Create test code that executes each of the stored procedures and shows the data in the tables