A working SQL script that initializes a learning management system, similar to Canvas and other educational tools. The first half of the script creates the necessary tables, relationships, constraints, and sample records to mimic a management system. The back half contains verification queries and advanced features like procedures, indexes, and triggers to showcase the scalability of the database to handle large datasets in the future.
- 11 relational tables
- 20+ foreign key relationships
- Views
- Stored procedures
- Scalar functions
- Triggers
- Performance indexes
- Sample reporting queries
- Maintaining referential integrity
- Calculating grades dynamically
- Optimizing common lookups
- Foreign key constraints
- Trigger-based recalculations
- Nonclustered indexes
Watch my demonstration of the database features: https://youtu.be/NBEENkTj6T4