Yes, please write everything in one single file. ===== Start with DROP table statements (to drop any existing tables in the database with the same name as your tables) Create tables (Using CREATE Table statements) Create Triggers (if required) Populate the tables (Using INSERT INTO keyword) Create Views ======== During the demonstration: In addition to the correct structure of your database, we should be able to retrieve data from your views/tables. You should be able to demonstrate the use of any triggers that you have created in the database. Cheers Mehwish