WEB 250 Project 1 - SQL

For this project you will create three tables, populate the tables and modify the data in the tables in your database. You will do all of your work through straight code. All of your code should be created in NotePad or NotePad++. I am okay for you to type a section of code in one of these applications and then copy and paste it into PHPMyAdmin. What I will need at the end is your sql file with all of this code in order and to see your final output in PHPMyAdmin.

1) The first part of the assignment is to create the following tables. Make sure you create the tables with SQL code and your SQL scripts are saved to the one SQL file.

Units Table and Structure
Units Structure Units Table

Vacation Packages Structure and Table
Vacation Packages Vacation Package Data

Vacation Package Categories Structure and Table
Vacation Categories Vacation Categories Data

2) For this part you are going to modify the contents in the tables.(Don't forget to include your SQL)

  1. The 1NR in the Units table is for a one night stay. The cost was to low for The View cabin, so please change it to 300 for one night.
  2. In the Units table all the baths should be in a numeric format. Rather than having a two, the format should be 2. This way in the future if we display this data in a drop down menu two and 2 are not both displayed.
  3. River Rapids has bought The Better Rafting Company. We need to update the company name.
  4. We Hike has decided to add Jeep Tours to what they offer. We need it added. You can make up your prices and other information. You will probably notice that data should be added to multiple tables.
  5. River Rapids just created a website. They need to add the website to each of their packages. Go ahead and add it. (You can make up the website)

3) This last section will focus on creating statements that will pull data from the different tables

  1. We need to know the cabins that have two bathrooms.
  2. We also need to know the cabins that cost less than $220.
  3. Now we need to see all the cabins that have three or more bedrooms in Bryson City.
  4. Next we need to see all the rafting trips.
  5. The last thing we need to see is everything from the vacation package table and the notes pulled from the categories table. This should all be in one SQL statement. (HINT: It is a type of JOIN)