Your tasks are the following. 1. In order to create the database objects, you will need to define a set of SQL DDL scripts. These must be included as part of your submission in a file named...

Your tasks are the following.
1. In order to create the database objects, you will need to define a set of SQL DDL scripts. These must be included as part of your submission in a file named createdb.sql. [20 marks]
2. To populate your tables, create a sequence of INSERT statements. These must be included as part of your submission in a file named inserts.sql. Every table should have at least 5 rows, since this is the minimum number of rows expected for testing purposes. It is strongly recommended that your data is not too simplistic – e.g., if a relation is defined as many-to-many in the design, then you should not populate it with data that makes it “accidentally one-to-one”, since such data would be bad for testing. [20 marks]
3. Define queries, in SQL, to obtain the following information over the database you created. Note that these should work with any data that can be present in the model, not just for the test data you used. The queries must be included as part of your submission in a file named queries.sql.
(a) The name and email of the user with ID 1. [10 marks]