Database about libraries that I developed during the third semester for the Databases course.
- Script for creating the tables
- Script for inserting data
- Large variety of SELECT statements together with their explanation
- Functions and procedures for implementing undo redo
-
Create tables for testing mechanism
- this code was received as starting code for the assignment -
Procedures for creating tests
- tables and views cand be added to a test and the speed of insert and delete is tested for tables, while the speed of select is tested on views
- results are also logged -
Procedures to fill a table with a given number of rows
- for each table a procedure that inserts a row based on an integer is required - Testing indexes
-
Bonus query
- SELECT TOP 0 * INTO AuxTable FROM MyTable copies the structure of a table into a new table that doesn't have to be created beforehand
