Corrected the SQL schema for some syntax errors and to fit the project requirements