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