Practice Assignment: INSERT INTO statements for the Pizza Delivery Shop Database

This assignment will be based on a Video Presentation that will be published.  After reviewing the video, you are to duplicated the tasks performed in the video.  After duplicating the tasks, submit the SQL script that you wrote for assessment.

I am supplying the SQL Script to that contains the CREATE TABLE Statements that corresponds to the INSERT INTO Statements being illustrated and executed in the video.

Below are inks to Alternate SQL files to create the database.  

EER_PizzaDelivery_DB_Demo.sql Download EER_PizzaDelivery_DB_Demo.sql

Alternate Design

EER_PizzaDelivery_DB_Demo Summer 2020.sql Download EER_PizzaDelivery_DB_Demo Summer 2020.sql

I am also including the sample data that I created and used in the INSERT INTO Statements that you will view in the sequence of videos.

Below is the link to Excel file that contains the test data used in the INSERT INTO Statements

TestDataPizzaDelivery.xlsx Download TestDataPizzaDelivery.xlsx

Create sample data for your Pizza Delivery Lab Database.  Use a Spreadsheet Workbook or a sequence of Tables in a Word Processor to document the test data values that you will use.   Keep your Sample Size Small.  Between 5 to 10 rows per table.

Once your test data values are organized, write the SQL Statements to populate the tables of the database with your test data.  You can use all INSERT INTO Statements, or a combination of the two. 

Upload the Following Documents for the Assignment

1. Spreadsheet Workbook or Word Processing Document containing the Test Data.  Must be in DOCX or PDF Format
   
   
2. SQL Text File containing the SQL Script to Create the Home Database and Tables
   
   
3. SQL Text file containing the SQL Script to Populate the Tables of your Database data

Many Students had problems with their Schema and Metadata Documentation. If you received feedback concerning Primary and Foreign Key Problems, you may want to use the Metadata and Schema that I provided below. 

One of the main goals of this assignment is for you to create a continuous sequence of SQL statements to create the database, use the database, create the tables, and insert data into the database without the any errors.

The Excel File that I provided contains all the necessary data needed. The Excel File is a Workbook consisting of multiple worksheets.  Each worksheet can be accessed through a tab at the bottom of the screen.  Each worksheet has a name representing the table that it is aligned with. 

A prerequisite for CIS 205 is CIS 103 which covers the basic use of a spreadsheet, particularly Microsoft Excel. If working with multiple worksheets in a workbook was not one of your strong points, I can point you to some online tutorials to refresh your understanding. Send me an email if you require a refresher on working with multiple worksheets

In Conclusion

for the INSERT INTO Assignment for the Pizza Delivery Company, I provided the Sample Data in an Excel Spreadsheet.  The Excel File is a Workbook consisting of multiple worksheets.  Each worksheet can be accessed through a tab at the bottom of the screen.  Each worksheet has a name representing the table that it is aligned with. 

I also provided my own version of the Script to Create the Database and Tables that match a Video Guide that I provided. My expectations are that students will use the Video Guide for Inserting Data into the Pizza Delivery Database. 

The Bottom Line Is This

1. if you received a 100 on the CREATE TABLE Assignment then your structure is sound, and you can make a choice on which CREATE TABLE Script to use. 
   
   
2. If you did not receive a 100, then it is likely you will may have a view referential integrity errors in your INSERT INTO Statements using the your Script from the previous CREATE TABLE Assignment, you should use my script then. 
   
   
3. Then there is also the likelihoodthat a student used the feedback from the previous CREATE TABLE Assignment to correct the problems.  If this is the case, then you can also choose which CREATE TABLE Script that you would like to use.
   
   

Since you have been exposed to the CREATE TABLE Statements, you can use them as your metadata.  You can also use the DESCRIBE Table Statement to obtain the Metadata from the RDBMS

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