Database Project for MS SQL Server
This project uses the Westlake Database project. It adds the tables needed to patient visits / symptoms, adds stored procedures, triggers and indexes, and asks the student to create views using query skills learned previously.
The importance of database security to prevent SQL injection attacks is also demonstrated, and mitigated through the use of stored procedures. In addition, indexes are discussed and demonstrated.