Create a Salesperson table and a Customer Order table using the data in Figure 3-11. Create records for each table using the data provided. Add one more Salesperson record with your own name and an employee number of your choosing. Also add at least one customer order with your number as the salesperson. Finally, create a relationship for the two tables. Create hard-copy documentation of your work.

Customer Order Table (Event) Customer # Order # Employee # Date Comments B104 1003 M24SP 01/03/2014 R63SP 01/03/2014 1004 P202 Ship ASAP 1005 M24SP S200 01/03/2014 CI00 1006 WIISP 01/03/2014 Inventory Table (Resource) Item # Description Unit Cost Sales Price Beg QO $0.20 $0.40 13025 1400 Yummy Bar $0.25 $0.45 1500 Almond Delight 5010 $0.60 $0.70 $0.18 $0.95 1600 Gummy Lions 20109 1700 $1.09 $0.30 Pecan Bar 4508 1800 Milky Bars 2207 Customer Table (Agent) City Customer # Name Address Province Postal Code Credit Limit C1A 1P1 $20000.00 A101 Amanda Wills 22 Yellow Ln. Charlottetown PEI 5,000.00 B104 Boris Bailey 321 Church St. Oxford ON K1S 106 QC C100 Gaily Riccaini 1899 Green St. Montreal Peggy Marlin 1260 Main St. Churchill H4N 3K1 10,000.00 10,000.00 5,000.00 ROB OEO P202 MB V6X 3J9 BC S200 Bill Safer 860 Broad St. Fairfax Salesperson Table (Agent) Employee #Name Address City ProvincePostal CodeDept IDDate Hired 406SF Sally Anderson3026 Skye Ln. Ajax ON 247 1/31/1989 7/2/1999 1/16/2009 M24SP Randy Merit 262 Main St. Brampton ON L6X 2B4 182 Barry Rogers 80N. Long St. Caledon Jim Rudolph 64 Lantern Ave.Orangeville 1028 Fields Ln. Mississauga ON R63SP L8G 4P4 247 R73SP ON L7A 2A1 76 8/15/2010 ON WIISP JolinWalker L5R 4J3 182 9/1/1992