2) Write the CREATE TABLE statement for these tables and INSERT statements: Customers table customerid firstname...

 

Transcribed Image Text:

2) Write the CREATE TABLE statement for these tables and INSERT statements: Customers table customerid firstname lastname 10101 10298 10339 10357 10409 10410 10429 10415 10428 10438 10449 John Leroy Anthony Jared Caroline Mary Ann Sarah Deborah Robert Kevin Isabela Gray Brown Sanchez McGregor Ziadie Howell Graham Taud Gamble Smith Moore city Lynden Pinetop Winslow San Diego New Orleans Charleston Greensboro New York Miami Durango Yuma 1 state Washington Arizona Arizona California Louisiana South Carolina North Carolina New York Florida Colorado Arizona Items_Ordered table ID customerid 1 2 3 4 5 6 7 8 9 10 11 21 Writ 10101 10339 10449 10415 10438 10449 10101 10438 10409 10101 10298 order_date 30-Jun-1999 27-Jul-1999 14-Aug-1999 18-Dec-1999 02-Dec-1999 22-Dec-1999 02-Jan-2000 18-Jan-2000 29-Feb-2000 08-Mar-2000 01-Apr-2000 CREATE TABLE item Raft Umbrella Ski Poles Tent Pillow Canoe Lantern Tent Flashlight Sleeping Bag Ear Muffs deti. quantity 1 1 2 1 1 1 1 1 1 2 1 price 58.00 4.50 25.50 88.00 8.50 280.00 16.00 79.99 4.50 88.70 12.50 2) Write the CREATE TABLE statement for these tables and INSERT statements: Customers table customerid firstname lastname 10101 10298 10339 10357 10409 10410 10429 10415 10428 10438 10449 John Leroy Anthony Jared Caroline Mary Ann Sarah Deborah Robert Kevin Isabela Gray Brown Sanchez McGregor Ziadie Howell Graham Taud Gamble Smith Moore city Lynden Pinetop Winslow San Diego New Orleans Charleston Greensboro New York Miami Durango Yuma 1 state Washington Arizona Arizona California Louisiana South Carolina North Carolina New York Florida Colorado Arizona Items_Ordered table ID customerid 1 2 3 4 5 6 7 8 9 10 11 21 Writ 10101 10339 10449 10415 10438 10449 10101 10438 10409 10101 10298 order_date 30-Jun-1999 27-Jul-1999 14-Aug-1999 18-Dec-1999 02-Dec-1999 22-Dec-1999 02-Jan-2000 18-Jan-2000 29-Feb-2000 08-Mar-2000 01-Apr-2000 CREATE TABLE item Raft Umbrella Ski Poles Tent Pillow Canoe Lantern Tent Flashlight Sleeping Bag Ear Muffs deti. quantity 1 1 2 1 1 1 1 1 1 2 1 price 58.00 4.50 25.50 88.00 8.50 280.00 16.00 79.99 4.50 88.70 12.50

Answer rating: 100% (QA)

The CREATE TABLE statement for the Customers table is as follows CREATE TABLE Customers customerid I... View the full answer