zip -r netid.zip *.*The name of the zip file should be your netid. For example, if your netid is smith1, you would run:
zip -r smith1.zip *.*
Hotel (hotelNo, hotelName, city) Room (roomNo, hotelNo, type, price) Booking (hotel No. guestNo, dateFrom, date To, room No) Guest (guestNo, guestName, guestAddress)where
+---------+-----------------+--------+ | hotelNo | hotelName | city | +---------+-----------------+--------+ | 1 | Grosvenor Hotel | London | +---------+-----------------+--------+
+--------+---------+--------+-------+ | roomNo | hotelNo | type | price | +--------+---------+--------+-------+ | 450 | 2 | double | 27.95 | | 250 | 2 | family | 32.50 | | 110 | 1 | double | 35.00 | +--------+---------+--------+-------+
+----------+ | COUNT(*) | +----------+ | 4 | +----------+
+------------+ | SUM(price) | +------------+ | 362.92 | +------------+
+--------+-----------+ | price | type | +--------+-----------+ | 89.99 | double | | 109.99 | family | | 135.50 | king | | 899.99 | penthouse | | 35.00 | double | +--------+-----------+
+------------+ | SUM(price) | +------------+ | 89.99 | +------------+
+---------+-------+ | hotelNo | count | +---------+-------+ | 1 | 5 | | 2 | 7 | +---------+-------+
+-----------------+-------+ | hotelName | count | +-----------------+-------+ | Grosvenor Hotel | 5 | +-----------------+-------+
Before the update
+--------+---------+-----------+--------+ | roomNo | hotelNo | type | price | +--------+---------+-----------+--------+ | 100 | 1 | double | 89.99 | | 200 | 1 | family | 109.99 | | 300 | 1 | king | 135.50 | | 500 | 2 | king | 205.00 | | 100 | 2 | penthouse | 249.99 | +--------+---------+-----------+--------+After the update
+--------+---------+-----------+--------+ | roomNo | hotelNo | type | price | +--------+---------+-----------+--------+ | 100 | 1 | double | 94.49 | | 200 | 1 | family | 115.49 | | 300 | 1 | king | 142.28 | | 500 | 2 | king | 215.25 | | 100 | 2 | penthouse | 262.49 | +--------+---------+-----------+--------+