I know that we need to populate our tables with sample data to test them out, but do we need to submit said sample data as part of the wider .txt file or do we just need to provide the tables and required views?

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