Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Part 2 You will insert data into 2nd set of 7 tables. These are the tables that you wrote the SQL to create the 2nd
Part 2 You will insert data into 2nd set of 7 tables. These are the tables that you wrote the SQL to create the 2nd set of 7 tables in Lab # 6. The values that you will insert are provided below. Some data fields are not provided. Please create the necessary values for data that has not been provided. Note: you will need to create the data in the background tables so that foreign key constraints will be satisfied. You will copy/paste the commands you execute along with the messages displayed from the execution of all your commands. Five Customers: Name Address Email John Smith 1235 Main Street, Dunmore, PA 18512 jsmith@hotmail.com Mary Jones 235 Ardmore Blvd, Pittsburgh, PA 15221 jones_mary@gmail.com Sally Ryder 725 Lincoln Way, White Oak, PA 15132 crazy_for_sql@yahoo.com Paul Walker 2 Clay Ave, Scranton, PA 18503 paul@dundermifflin.com Daniel Murphy 5125 Forbes Ave, Pittsburgh, PA 15222 dlm5@cmu.edu Five Customer Rentals: Customer Movie Status Date Out Date Returned Amount Due Smith Superbad Active 7/2/2012 2.59 Jones Spider-Man Reserved Ryder Gone w/ Wind Overdue 6/2/2012 15.78 Walker Fahr 9/11 Returned 5/1/2012 5/20/2012 5.60 Murphy Good Will Active 7/10/2012 4.56 Five Financial Transactions: Customer Movie Type Pay Method Amount Date Smith Superbad Payment Cash 2.59 7/2/2012 Jones Spider-Man Deposit Credit Card 10.00 7/10/2012 Ryder Gone w/ Wind Payment PayPal 15.78 6/2/2012 Walker Fahr 9/11 Payment Check 15.60 5/10/2012 Walker Fahr 9/11 Refund Check 10.00 6/30/2012 Part 2 You will insert data into 2nd set of 7 tables. These are the tables that you wrote the SQL to create the 2nd set of 7 tables in Lab # 6. The values that you will insert are provided below. Some data fields are not provided. Please create the necessary values for data that has not been provided. Note: you will need to create the data in the background tables so that foreign key constraints will be satisfied. You will copy/paste the commands you execute along with the messages displayed from the execution of all your commands. Five Customers: Name Address Email John Smith 1235 Main Street, Dunmore, PA 18512 jsmith@hotmail.com Mary Jones 235 Ardmore Blvd, Pittsburgh, PA 15221 jones_mary@gmail.com Sally Ryder 725 Lincoln Way, White Oak, PA 15132 crazy_for_sql@yahoo.com Paul Walker 2 Clay Ave, Scranton, PA 18503 paul@dundermifflin.com Daniel Murphy 5125 Forbes Ave, Pittsburgh, PA 15222 dlm5@cmu.edu Five Customer Rentals: Customer Movie Status Date Out Date Returned Amount Due Smith Superbad Active 7/2/2012 2.59 Jones Spider-Man Reserved Ryder Gone w/ Wind Overdue 6/2/2012 15.78 Walker Fahr 9/11 Returned 5/1/2012 5/20/2012 5.60 Murphy Good Will Active 7/10/2012 4.56 Five Financial Transactions: Customer Movie Type Pay Method Amount Date Smith Superbad Payment Cash 2.59 7/2/2012 Jones Spider-Man Deposit Credit Card 10.00 7/10/2012 Ryder Gone w/ Wind Payment PayPal 15.78 6/2/2012 Walker Fahr 9/11 Payment Check 15.60 5/10/2012 Walker Fahr 9/11 Refund Check 10.00 6/30/2012
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started