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