Homework Assignment: Stored Procedure Statements for the Homework Database: for the Martial Arts University Database

  • Due Apr 25, 2022 by 11:59pm
  • Points 100
  • Submitting a text entry box or a file upload
  • Available Apr 18, 2022 at 12am - Apr 26, 2022 at 11:59pm
This assignment was locked Apr 26, 2022 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 scripts should be placed in one file
  • The script should run continuously without errors

 

Write a stored procedure for the Martial Arts University Database

 

Students can use their creativity based on what they studied to choose the SQL Statements in the body of the Procedure. I am looking for the following

 

  1. Script to Create the Database and Create the Required Tables being used from the Homework Database.
  2. Script to insert necessary Test Data 
  3. A Functional Syntax Error Free Stored Procedure
  4. A Statement to Invoke the Stored Procedure.
  5. All the Script is contained in a single SQL Text File
  6. The Script runs continuously without any Syntax Errors

 

Submit the following code in the Single SQL script Text File you are submitting

 

  • Your version of the SQL script to create the Martial Arts University Database and the SQL Script to Insert the Test Sample Data.  This version must use INSERT INTO Statements to place data into the database

 

  • SQL Script containing the Stored Procedure for the Martial Arts University Database and the SQL statement to Call to the Stored Procedure

 

The File must have a SQL Extension to receive points for the submission

 

If you are using comments in the script files or files, 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 scripts should be placed in one file
  • The script should run continuously without errors

 

 

1650945599 04/25/2022 11:59pm