Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Governance Of Financial Management

Authors: John Carver, Miriam Carver

1st Edition

0470392541, 9780470392546

More Books

Students also viewed these Finance questions