If you do not have the book and need to see an electronic copy of the homework,
I have uploaded a scanned version of the relevant pages in the textbook
to the assignments section of blackboard.
Please submit this homework in an ascii text file named hw2.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.
Use the CREATE TABLE command to create each of the relations shown in
the Hotel Schema defined at the start of the Exercises at the end of Chapter
4 and insert some of your own sample data into each table so you can test
your queries in part 2 of this problem. Assume the following data types:
type: string, 9 characters, variable length string--acceptable
values are 'family', 'double', 'king', 'penthouse', 'queen' (don't
worry in this assignment about declaring a domain constraint, that
will come in the next assignment)
price: decimal, 5 digits, 2 decimal digits (max is 999.99)