Description

Secure Coding (CNT 4419)
Assignment III

Objectives: To gain experience writing SQL statements.

Assignment Description
Complete this assignment by yourself. While doing this assignment you will need a Database Management System (DBMS) to process the queries. To this end, please use SQL Fiddle (http://sqlfiddle.com/), a website that provides access to a DBMS and allows developers to test and share SQL statements. Unlike Paiza, SQL Fiddle does not have accounts, so be sure to save your queries on your own device. SQL Fiddle offers several DBMS options; please use the default MySQL option.

Create at least 3 tables, insert values into them, and perform nontrivial queries on them. The queries should illustrate all of the following SQL keywords/features in practically useful ways:
1. SELECT *
2. LIKE
3. (INNER) JOIN
4. LEFT JOIN
5. RIGHT JOIN
6. UNION
7. GROUP BY
8. OFFSET

Important: The example tables, data, and queries you create are up to you. This assignment requires you to be creative and come up with your own compelling examples. Do not use any examples from class or that you find online. Your examples should be different from those of your classmates and from examples we can find online.

Submit two files to Canvas, one for the code in the left-side panel in the SQL Fiddle interface (call the file containing this code schema.sql) and one for the code in the right-side panel in the SQL Fiddle interface (call the file containing this code queries.sql). In total, you should submit 8 unique queries, one query for each feature/keyword.