Homework 1

General Instructions

  1. Please submit this homework in an ascii text file named hw1.txt, with each exercise clearly marked. For example:
    6.7 SELECT * FROM Hotel;
    6.9 SELECT GuestName, GuestAddress FROM Guest
           WHERE GuestAddress LIKE '%London%';
    We will be creating our own test data, then copying and pasting your answers into the mysql interpreter.

  1. Use the Hotel.sql file that is included with this homework assignment to create the hotel tables from the Hotel Schema example at the end of Chapter 4. The Hotel.sql file also contains some sample data. You can use these tables to test your queries in part 2 of this problem.

  2. The following exercises: