Flower I Customer Customerld - FirstName ZipCode - PhoneNumbe - Click to Add 21228 4108695532 21236 4102568831 LastName - StreetAddress State ItemDescription Price City Baltimore Itemld Click to Add 1 Sally 2 Karen 3 Thomas 4 Cecilia Smith Walters Williams Jamil 2601 Holly Court 46 Tealeaf Road 243555 Ambermill Stree Frederick MD 1 Red Rose Long Stem Individual $5.99 MD Baltimore $40.99 2 Red Rose Long Stem Dozen 3 Red and White Rose Bouquet 4 Bouquet- Roses Valentines Day 5 Bouquet- Mother's Day Small 6 Bouquet- Mother's Day Medium 7 Bouquet- Mother's Day Large 8 Bouquet -Apology- Small MD 21703 18 Cochoran Way 1 Ocean Street 34 Ridge Road Apt. 3 Frederick MD $38.99 5 Bryan 6 Thomas 7 Torey Frederick Frederick 21702 21705 4435109733 21702 4104512394 MD $45.99 Henley Wright Watson Gonzales Paisley Jimenez MD 675 Broad Street 16 Rossville Blvd 46 Greenwood Circle $29.99 $49.99 Bel Air Baltimore MD 21014 4435453311 21237 7814223451 MD 8 Sam Edgemere MD 21219 3016775444 $69.99 9 Robert 10 Katura 11 Tammy 12 Josh 13 Michele 8 Tiger Lane, First floor Baltimore 2344 Wise Avenue 16 Silver Spring Road 501 Boston Street 451 Painters Mill Road Owings Mills MD MD 21222 $19.99 Baltimore MD 21222 4107662301 9 Bouquet- Apology- Medium 10 Bouquet- Apology- Large 11 Bouquet- Birthday Mix 12 Bouquet - Holiday 13 Bouquet- All Occasion 14 Bouquet- All Occasion with Vase 15 Bouquet- All Occasion with Teddy Bear 16 Bouquet- All Occasion with Teddy Bear and Vase $39.99 Knott Franz Savarese Baltimore Baltimore MD 21236 21224 4106753814 21117 $99.99 $25.99 $29.99 MD O'Leary Hawkins 14 Scott 15 Tyler 16 Sonya 512 Blythe Court Apt B Columbia MD 9948 Beaver Dam Road Hunt Valley Randallstown MD MD 21045 6175446300 Patel Helfrich 21031 4432109777 4 Liberty Road 5130 Wilkens Ave 45 Cockeysville Road, A¡ Hunt Valley 675 Grand Cental Avenu Owings Mills $29.99 $39.99 $39.99 17 Karen 21133 4107665511 Abrams Baltimore MD 21228 3012771007 18 Scott 19 Susan 20 David Geaney MD 21031 4439912397 21117 4437664519 $49.99 Order Orderld Customerld - Itemld TransactionDate - Click 6. 1/15/2014 2 12 1/16/2014 3 2 10 1/16/2014 4 2 6 5/1/2014 5/1/2014 6. 15 5/2/2014 5/11/2014 2 5/12/2014 10 5/12/2014 10 19 15 5/16/2014 11 11 5/27/2014 12 10 6/1/2014 13 1. 6/1/2014 14 14 16 8/1/2014 15 20 8/8/2014 16 4 8/8/2014 17 16 14 8/12/2014 18 3 8/16/2014 19 11 8/30/2014 20 17 9 8/30/2014 3.

Computer Networking: A Top-Down Approach (7th Edition)
7th Edition
ISBN:9780133594140
Author:James Kurose, Keith Ross
Publisher:James Kurose, Keith Ross
Chapter1: Computer Networks And The Internet
Section: Chapter Questions
Problem R1RQ: What is the difference between a host and an end system? List several different types of end...
icon
Related questions
Question

For this assignment, write SQL code based on the tables provided.

Create three tables 

Tables -1.Customer 2.Flower 3.Order

Decide what fields, field lengths, and datatypes you need. Do this for each of the 3 tables. 

Only use VARCHAR2, NUMBER, and DATE datatypes.

Assign a primary key to one field in each table

Provide the code to insert the records into each of the tables in the database.  

 

Flower
I Customer
Customerld - FirstName
ZipCode
- PhoneNumbe - Click to Add
21228 4108695532
21236 4102568831
LastName -
StreetAddress
State
ItemDescription
Price
City
Baltimore
Itemld
Click to Add
1 Sally
2 Karen
3 Thomas
4 Cecilia
Smith
Walters
Williams
Jamil
2601 Holly Court
46 Tealeaf Road
243555 Ambermill Stree Frederick
MD
1 Red Rose Long Stem Individual
$5.99
MD
Baltimore
$40.99
2 Red Rose Long Stem Dozen
3 Red and White Rose Bouquet
4 Bouquet- Roses Valentines Day
5 Bouquet- Mother's Day Small
6 Bouquet- Mother's Day Medium
7 Bouquet- Mother's Day Large
8 Bouquet -Apology- Small
MD
21703
18 Cochoran Way
1 Ocean Street
34 Ridge Road Apt. 3
Frederick
MD
$38.99
5 Bryan
6 Thomas
7 Torey
Frederick
Frederick
21702
21705 4435109733
21702 4104512394
MD
$45.99
Henley
Wright
Watson
Gonzales
Paisley
Jimenez
MD
675 Broad Street
16 Rossville Blvd
46 Greenwood Circle
$29.99
$49.99
Bel Air
Baltimore
MD
21014 4435453311
21237 7814223451
MD
8 Sam
Edgemere
MD
21219 3016775444
$69.99
9 Robert
10 Katura
11 Tammy
12 Josh
13 Michele
8 Tiger Lane, First floor Baltimore
2344 Wise Avenue
16 Silver Spring Road
501 Boston Street
451 Painters Mill Road Owings Mills MD
MD
21222
$19.99
Baltimore
MD
21222 4107662301
9 Bouquet- Apology- Medium
10 Bouquet- Apology- Large
11 Bouquet- Birthday Mix
12 Bouquet - Holiday
13 Bouquet- All Occasion
14 Bouquet- All Occasion with Vase
15 Bouquet- All Occasion with Teddy Bear
16 Bouquet- All Occasion with Teddy Bear and Vase
$39.99
Knott
Franz
Savarese
Baltimore
Baltimore
MD
21236
21224 4106753814
21117
$99.99
$25.99
$29.99
MD
O'Leary
Hawkins
14 Scott
15 Tyler
16 Sonya
512 Blythe Court Apt B Columbia
MD
9948 Beaver Dam Road Hunt Valley
Randallstown MD
MD
21045 6175446300
Patel
Helfrich
21031 4432109777
4 Liberty Road
5130 Wilkens Ave
45 Cockeysville Road, A¡ Hunt Valley
675 Grand Cental Avenu Owings Mills
$29.99
$39.99
$39.99
17 Karen
21133 4107665511
Abrams
Baltimore
MD
21228 3012771007
18 Scott
19 Susan
20 David
Geaney
MD
21031 4439912397
21117 4437664519
$49.99
Transcribed Image Text:Flower I Customer Customerld - FirstName ZipCode - PhoneNumbe - Click to Add 21228 4108695532 21236 4102568831 LastName - StreetAddress State ItemDescription Price City Baltimore Itemld Click to Add 1 Sally 2 Karen 3 Thomas 4 Cecilia Smith Walters Williams Jamil 2601 Holly Court 46 Tealeaf Road 243555 Ambermill Stree Frederick MD 1 Red Rose Long Stem Individual $5.99 MD Baltimore $40.99 2 Red Rose Long Stem Dozen 3 Red and White Rose Bouquet 4 Bouquet- Roses Valentines Day 5 Bouquet- Mother's Day Small 6 Bouquet- Mother's Day Medium 7 Bouquet- Mother's Day Large 8 Bouquet -Apology- Small MD 21703 18 Cochoran Way 1 Ocean Street 34 Ridge Road Apt. 3 Frederick MD $38.99 5 Bryan 6 Thomas 7 Torey Frederick Frederick 21702 21705 4435109733 21702 4104512394 MD $45.99 Henley Wright Watson Gonzales Paisley Jimenez MD 675 Broad Street 16 Rossville Blvd 46 Greenwood Circle $29.99 $49.99 Bel Air Baltimore MD 21014 4435453311 21237 7814223451 MD 8 Sam Edgemere MD 21219 3016775444 $69.99 9 Robert 10 Katura 11 Tammy 12 Josh 13 Michele 8 Tiger Lane, First floor Baltimore 2344 Wise Avenue 16 Silver Spring Road 501 Boston Street 451 Painters Mill Road Owings Mills MD MD 21222 $19.99 Baltimore MD 21222 4107662301 9 Bouquet- Apology- Medium 10 Bouquet- Apology- Large 11 Bouquet- Birthday Mix 12 Bouquet - Holiday 13 Bouquet- All Occasion 14 Bouquet- All Occasion with Vase 15 Bouquet- All Occasion with Teddy Bear 16 Bouquet- All Occasion with Teddy Bear and Vase $39.99 Knott Franz Savarese Baltimore Baltimore MD 21236 21224 4106753814 21117 $99.99 $25.99 $29.99 MD O'Leary Hawkins 14 Scott 15 Tyler 16 Sonya 512 Blythe Court Apt B Columbia MD 9948 Beaver Dam Road Hunt Valley Randallstown MD MD 21045 6175446300 Patel Helfrich 21031 4432109777 4 Liberty Road 5130 Wilkens Ave 45 Cockeysville Road, A¡ Hunt Valley 675 Grand Cental Avenu Owings Mills $29.99 $39.99 $39.99 17 Karen 21133 4107665511 Abrams Baltimore MD 21228 3012771007 18 Scott 19 Susan 20 David Geaney MD 21031 4439912397 21117 4437664519 $49.99
Order
Orderld
Customerld -
Itemld
TransactionDate - Click
6.
1/15/2014
2
12
1/16/2014
3
2
10
1/16/2014
4
2
6
5/1/2014
5/1/2014
6.
15
5/2/2014
5/11/2014
2
5/12/2014
10
5/12/2014
10
19
15
5/16/2014
11
11
5/27/2014
12
10
6/1/2014
13
1.
6/1/2014
14
14
16
8/1/2014
15
20
8/8/2014
16
4
8/8/2014
17
16
14
8/12/2014
18
3
8/16/2014
19
11
8/30/2014
20
17
9
8/30/2014
3.
Transcribed Image Text:Order Orderld Customerld - Itemld TransactionDate - Click 6. 1/15/2014 2 12 1/16/2014 3 2 10 1/16/2014 4 2 6 5/1/2014 5/1/2014 6. 15 5/2/2014 5/11/2014 2 5/12/2014 10 5/12/2014 10 19 15 5/16/2014 11 11 5/27/2014 12 10 6/1/2014 13 1. 6/1/2014 14 14 16 8/1/2014 15 20 8/8/2014 16 4 8/8/2014 17 16 14 8/12/2014 18 3 8/16/2014 19 11 8/30/2014 20 17 9 8/30/2014 3.
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps with 6 images

Blurred answer
Similar questions
Recommended textbooks for you
Computer Networking: A Top-Down Approach (7th Edi…
Computer Networking: A Top-Down Approach (7th Edi…
Computer Engineering
ISBN:
9780133594140
Author:
James Kurose, Keith Ross
Publisher:
PEARSON
Computer Organization and Design MIPS Edition, Fi…
Computer Organization and Design MIPS Edition, Fi…
Computer Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
Network+ Guide to Networks (MindTap Course List)
Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning
Concepts of Database Management
Concepts of Database Management
Computer Engineering
ISBN:
9781337093422
Author:
Joy L. Starks, Philip J. Pratt, Mary Z. Last
Publisher:
Cengage Learning
Prelude to Programming
Prelude to Programming
Computer Engineering
ISBN:
9780133750423
Author:
VENIT, Stewart
Publisher:
Pearson Education
Sc Business Data Communications and Networking, T…
Sc Business Data Communications and Networking, T…
Computer Engineering
ISBN:
9781119368830
Author:
FITZGERALD
Publisher:
WILEY