Question

2. Add the following magazine data to the appropriate tables: Magazine Name Price Formats Time $2.50 print Cosmopolitan $1.50 print Sports Illustrated $2.29 print, CD People $2.75 print Wired $0.99 CD, web PC World $1.50 print, web 3. Place subscriptions for the following customers (start the sequence of customer ids at 10000001): Customer Magazines Paula Harris 1156 Water Street, Apt. #3 Osseo, SK G2L 1T5 3065558943 pharris@gmail.com Time, print People, print Maria Garcia 2211 Pine Drive Radisson, SK G5W 2K2 3065558332 maria.garcia@widgetco.ca PC World, web Cosmopolitan, print Lee Miller 699 Pluto St. NW Silver Lake, SK G2M 5R2 3065554978 Sports Illustrated, CD Alissa Chang 1987 Durham Rd. Apple Valley, MB E9L 4R1 2045557651 Time, print Wired, CD PC World, web Mitch Edwards 4204 Garner Street Washburn, SK G1K 2G1 mitch211@hotmail.com People, print Kyle Nelson kylen@gmail.com Wired, web Part 1 Logically group the insert statements: First enter all of the magazines and their formats (in an appropriate order). COMMIT the changes. Then enter each customer along with their subscription committing after each one

          2. Add the following magazine data to the appropriate tables:
Magazine Name Price Formats
Time
$2.50 print
Cosmopolitan $1.50 print
Sports Illustrated $2.29 print, CD
People
$2.75 print
Wired
$0.99 CD, web
PC World
$1.50 print, web
3. Place subscriptions for the following customers (start the sequence of customer ids at 10000001):
Customer
Magazines
Paula Harris
1156 Water Street, Apt. #3
Osseo, SK G2L 1T5
3065558943
pharris@gmail.com
Time, print
People, print
Maria Garcia
2211 Pine Drive
Radisson, SK G5W 2K2
3065558332
maria.garcia@widgetco.ca
PC World, web
Cosmopolitan, print
Lee Miller
699 Pluto St. NW
Silver Lake, SK G2M 5R2
3065554978
Sports Illustrated, CD
Alissa Chang
1987 Durham Rd.
Apple Valley, MB E9L 4R1
2045557651
Time, print
Wired, CD
PC World, web
Mitch Edwards
4204 Garner Street
Washburn, SK G1K 2G1
mitch211@hotmail.com
People, print
Kyle Nelson
kylen@gmail.com
Wired, web
Part 1
Logically group the insert statements: First enter all of the magazines and their formats (in an appropriate order). COMMIT the changes. Then enter each customer along with their subscription
committing after each one

2. Add the following magazine data to the appropriate tables:
Magazine Name Price Formats
Time
2.50 print
Cosmopolitan1.50 print
Sports Illustrated 2.29 print, CD
People2.75 print
Wired
0.99 CD, web
PC World1.50 print, web
3. Place subscriptions for the following customers (start the sequence of customer ids at 10000001):
Customer
Magazines
Paula Harris
1156 Water Street, Apt. #3
Osseo, SK G2L 1T5
3065558943
pharris@gmail.com
Time, print
People, print
Maria Garcia
2211 Pine Drive
Radisson, SK G5W 2K2
3065558332
maria.garcia@widgetco.ca
PC World, web
Cosmopolitan, print
Lee Miller
699 Pluto St. NW
Silver Lake, SK G2M 5R2
3065554978
Sports Illustrated, CD
Alissa Chang
1987 Durham Rd.
Apple Valley, MB E9L 4R1
2045557651
Time, print
Wired, CD
PC World, web
Mitch Edwards
4204 Garner Street
Washburn, SK G1K 2G1
mitch211@hotmail.com
People, print
Kyle Nelson
kylen@gmail.com
Wired, web
Part 1
Logically group the insert statements: First enter all of the magazines and their formats (in an appropriate order). COMMIT the changes. Then enter each customer along with their subscription
committing after each one

Added by Dean P.

Question

Please give Ace some feedback