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...

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.

Extracted 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


Extracted 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.