Library Database Creation in SQL
In this project, i created an automated and functional library database system in Microsoft SQL, with complex steps towards ensurinng data integrity (through triggers, check constraints, stored funnctions, stored procedures, maintenannce wizard set ups) and data security (password hashing, Grant access, Views, revoked access etc) The codes also contain select queries as well as complex join queries used in testing the dataset as well as update queries used in testing triggers
