Homework Assignment: Stored Procedure Statements for the Sales Rep - Customer - Invoice Database
- Due Jun 20, 2020 by 11:59pm
- Points 100
- Submitting a text entry box or a file upload
- Available Jun 13, 2020 at 12am - Jun 23, 2020 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
Write a stored procedure for the Sales Rep - Customer - Invoice Database.
Submit the following code in the SQL script file you are submitting
- Your Version of the SQL script to create the Sales Rep - Customer - Invoice Database and Insert Test Data. This version must use INSERT INTO Statements to place data into the database
- SQL Script containing the Stored Procedure for the Sales Rep - Customer - Invoice Database and the 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 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
Find Rubric