Database homework

profileDarkGemini
ACLab1GardenNaturallyDatabase.accdb
Home>Computer Science homework help>Database homework
Customer Number Customer Name Address City State Postal Code Amount Paid Balance Due Sales Rep Number
AA30 All About Gardens 47 Berton St. Greer PA 19158 ¤ 1,190.00 ¤ 365.00 26
CT02 Christmas Tree Farm 483 Cantor Rd. Pleasantburg NJ 07025 ¤ 2,285.50 ¤ 825.35 29
GG01 Garden Gnome 10 Main St. Gossett PA 19157 ¤ 1,300.00 ¤ 297.50 29
GT34 Green Thumb Growers 26 Jefferson Hwy. Pleasantburg NJ 07025 ¤ 3,325.45 ¤ 865.50 32
LH15 Lawn & Home Store 33 Maple St. Chambers NJ 07037 ¤ 895.00 ¤ 515.00 26
ML25 Mum's Landscaping 196 Lincoln Ave. Quaker DE 19719 ¤ 0.00 ¤ 1,805.00 29
OA45 Outside Architects 234 Magnolia Rd. Gaston DE 19723 ¤ 4,205.50 ¤ 945.00 32
PL10 Pat's Landscaping 22 Main St. Chesnee NJ 07053 ¤ 1,165.00 ¤ 180.00 26
PN18 Pyke Nurseries 10 Grant Blvd. Adelphia PA 19159 ¤ 2,465.00 ¤ 530.00 32
SL25 Summit Lawn Service 345 Oaktree Rd. Chesnee NJ 07053 ¤ 3,225.45 ¤ 675.50 26
TG38 TriState Growers 24 Main St. Gaston DE 19723 ¤ 1,075.00 ¤ 0.00 29
TW34 TAL Wholesalers 234 Cantor Rd. Pleasantburg NJ 07025 ¤ 4,125.00 ¤ 350.00 26
TY03 TLC Yard Care 24 Berton St. Greer PA 19158 ¤ 1,845.00 ¤ 689.45 29
YS04 Yard Shoppe 124 Elm St. Quaker DE 19719 ¤ 445.00 ¤ 575.00 32
YW01 Young's Wholesalers 5239 Lancaster Hwy. Adelphia PA 19156 ¤ 1,785.50 ¤ 345.60 32
Sales Rep Number Last Name First Name Address City State Postal Code Start Date Commission Rate Salary YTD
26 Jones Pat 43 Third St Greer PA 19158 5/16/16 0.05 ¤ 33,100.50
29 Gupta Rufus 678 Hillcrest Rd. Gossett PA 19157 6/1/15 0.06 ¤ 35,075.30
32 Ortiz Gloria 982 Victoria Ln Chesnee NJ 07053 9/12/15 0.05 ¤ 32,555.65
35 Sinson Mike 45 Elm St. Quaker DE 19719 8/28/17 0.04 ¤ 1,500.00
SELECT Customer.[Customer Number], Customer.[Customer Name], Customer.[Amount Paid], Customer.[Balance Due], Customer.[Sales Rep Number] FROM Customer;