Validate and fix SQL

Hello,

That task is a easy task for today
I just need someone very good in SQL to know triggers,, stored procedures, functions, integrity
constraints, etc to fix and validate a little SQL Project.

The SQL is done but need to be fixed, tsted and validate.
And if you fix something you need to comment and explain.

Very fast task,

If you read that task put the work Omen in yout text.
If you dont have that word i will ignore the bid.

Thanks