Practice Assignment - Sample Database Tutorial using Sub Query Operations

Submit an SQL Text File for the SQL portion of this assignment.  An SQL Text File is a text file with a ".SQL" extension on the file name. 

• The script should be well documented with comments
• Comments should contain Your Name, Name of Project, Date Created, Semester Created
• Comments should describe the different Sections of the Script
• All the script should be placed in one file
• The script should run continuously without errors

You will practice some of the Sub Query Operations  exercises from this Website

http://www.mysqltutorial.org/ Links to an external site.

I selected the practice examples from the mysqltutorial.org (Links to an external site.) website.   I would like you to follow the Guided Video and replicate the actions that I perform in the Guided Video.  Copy and Paste the SQL Script that I Copy and Paste into a text editor.   Run the script that you placed in the text editor in Maria DB to make sure that you wrote or transposed it correctly.  Make sure that all your script in the submitted SQL text file runs correctly and continuously.  Make Sure to comment the script as well.   

Link to the Tutorial Website

https://www.mysqltutorial.org/mysql-subquery/ Links to an external site.

Link to the Guided Video  Links to an external site.

You will use the Sample Database for the exercises in Assignment 

Link to Download Sample Database

mysqlsampledatabase.sql Download mysqlsampledatabase.sql

Link to Download ER Diagram for the Sample Database

Sample Database- ER Diagram.pdf Download Sample Database- ER Diagram.pdf

Link to Download Metadata for the Sample Database

Sample Database Metadata.pdf Download Sample Database Metadata.pdf

Use a SOURCE command to create and configure the database

 Submit an SQL text file created from following along with the tutorial

If you are using comments in the script files or file, you must use them correctly.  The script must run continuously.  Any commands that do not operate correctly due to improperly formatted comments will not be assessed in the final point accumulation for the assignment.

Submit an SQL Text File for the SQL portion of this assignment.  An SQL Text File is a text file with a ".SQL" extension on the file name. 

• The script should be well documented with comments
  
  
• All the script should be placed in one file
  
  
• The script should run continuously without errors