The goal is for you to work with basic SQL queries and practice using an actual RDBMS.
Use the scripts found in the zip file. This archive contains:
Create the schema with data using the creation SQL script. Then, either use the MySQL Workbench to create an EER diagram, some other software, or do an ER diagram by hand. Turn in a copy of the ER diagram along with a description of what it means. Then execute each SQL query in the query file. For each query tell what it does. I do not want a listing of the result. I want you to describe in English what it is doing. Part should be a description that a non-CS user of the database would understand. You are welcome to use any SQL references you want to determine what is going on. An example of a description could be "Find the highest paid employee who works outside the U.S." What I don't want is "Find the maximum salary of all entries in the Employee table where location <> U.S."
This data came from the textbook you have been reading. The meaning is that s tables (s1, s2, s5) are sailors, b tables (b1, b2) are boats, and r tables (r1, r2) are reservations of boats by sailors. There are multiple versions of the tables to allow for different results by different queries.
You may (and are even encouraged) to work in groups of up to three (3) students. You only need to turn in one solution for each group unless there is a problem. Place all group members names on the solution. All members of the group must know the details and reasoning of the solution. If only some members worked on and understand a particular problem solution then this should be noted on what you turn in by giving the name(s) of the people who accomplished the work for that problem.
There is an assignment link on Moodle. Turn in a file with your answers. It can be in any reasonable format (PDF, RTF, MS Word, Open Office, Pages, ....).