Guidelines for database assignments

You should supply the following:

  1. Your team name and the names of its members
  2. A one paragraph description of the problem
  3. The data model in png format (File > Export > Export as PNG…)
  4. The name of the database on the MySQL server
  5. Ten queries
  6. The ten queries should cover the following SQL features:
  7. You may combine some of the preceding list of features into a single query. Indicate in matrix format in your report which features are covered in a query. A sample matrix is shown

    Query 1 Query 2
    multiple table join x
    subquery x x
    x