More SQL Queries

Details:

This lab will continue to build your SQL (Structured Query Language) skills. You will use both a MySQL database to create and test your queries. You will use Word to answer the questions by copying and pasting both the SQL query and the table results of each query.

You will use SQL (pronounced either S-Q-L or seekwel) queries throughout Project 1 and the rest of your projects. PHP relies heavily on SQL queries. The main purpose of PHP is to interact with a database. In the next lab, we will be building PHPs that query a database and display the results in a browser. For this lab, we are only learning SQL using the MySQL Database Management Systems (DBMS).

Note: a common mistake is to refer to the database management system Microsoft SQL Server as simply SQL. You should understand that "SQL" is a language - Structured Query Language - not a product. If you make this mistake, others will think you don't know what you are talking about and question your web programming abilities. The software name is "SQL Server."

Materials to turn in on the server:

• In your Lab06 folder:
• Lab06Queries.docx

Exercise Specifications

1. Log onto MySQL using PhpMyAdmin and choose the northwind database
   • http://cgtweb2.tech.purdue.edu/phpMyAdmin-4.6.4/
   • Choose the SQL tab
   • You are now ready to begin writing SQL queries.
   • Here is an Entity Relationship Diagram (ERD) of the database to help you understand how the tables are related:
     
      
2. Download this Word document with the lab questions
• Put your Name, Course, Section Number, and Date at the top of the first page.
• For each question, you should copy and paste the SQL query form of that question
• For each question, you should copy and paste the results of the query
• Thus, your final Word document that you turn in will be in the format:
• Question?
• SQL query from MySQL
• Results
• Question?
• SQL query from MySQL
• Results
• etc., etc.
   
3. Save your Word document to your Lab06 folder.
    
4. Save a backup copy to your personal drive space.
    
5. Do not modify any files after the deadline. Timestamps on all files will be checked during grading.

Grading