Homework Assignment: MySQL VIEWS - Homework Assignment: for the The Little League Baseball Team Database.

  • Due Apr 15, 2024 by 11:59pm
  • Points 100
  • Submitting a text entry box or a file upload
  • File Types sql
  • Available Apr 8, 2024 at 12am - Apr 22, 2024 at 11:59pm
This assignment was locked Apr 22, 2024 at 11:59pm.

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

 

The script should perform the following tasks

 

  • CREATE Two SQL CREATE VIEW Statements.  One of the CREATE VIEW Statements must use two joined tables.
  • Use the two created VIEWS in two different SELECT Statements.  One created VIEW per SELECT Statement.  
  • Use the SHOW FULL TABLES Statement to list the stored VIEWS in the Database

Upload the following in your single submission

  1. SQL Script to create the The  Little League Baseball Team Database. and the statements to load the sample data using INSERT INTO Statements.

  2. SQL Script to create the two VIEWS for the assigned database.  One of the views must involve two or more tables. 
     
  3. SELECT Statement commands to execute  the VIEWS

  4. SQL Statement to list the VIEWS

  5. All components should be combined into one file

 

It is recommended to include all the script into a single text file with a SQL extension

 

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
  • 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

 

 

 

 

 

 

1713239999 04/15/2024 11:59pm