FILE 1 has all that has been asked but it's all in the CreateTables.sql file