Use Microsoft Access to perform the tasks and explain the steps you used in the process or explain how you would use SQL to obtain the desired results.

12. BITS has decided to include I.T. training in its service line and has assigned the item to the category OTH. What change is needed in the database to add items in category OTH to the Tasks table? Would you add any integrity constraints to the fields in the Tasks table? Why or why not?

FL FL Consultant ConsitNum LastName FirstName Street City State Zip Code Hours Rate 19 Turner Christopher 554 Brown Dr. Tri City FL 32889 40 $22.50 22 Jordan Patrick 2287 Port Rd. Easton FL 33998 40 $22.50 35 Allen Sarah 82 Elliott St. Lizton FL 34344 35 $20.00 51 Shields Tom 373 Lincoln Ln. Sunland FL 39876 10 $15.00 Client ClientNum ClientName Street City State Zip Code Balance CreditLimit ConsItNum 143 Hershey, Jarrod 135 E. Mill Street Easton FL 33998 $1,904.55 $2,500.00 19 175 Goduto, Sean 12 Saratoga Parkway Tri City FL 32889 $2,814.55 $5,000.00 19 299 Two Crafty 9787 NCR 350 Sunland FL 39876 $8,354.00 $10,000.00 22 Cousins West 322 Prichard's Pizza & 501 Air Parkway Lizton FL 34344 $7,335.55 $10,000.00 35 Pasta 363 Salazar, Jason 56473 Cherry Tree Dr Easton FI 33998 $900.75 $2,500.00 35 405 Fisherman's Spot 49 Elwood Ave. Harpersburg FL. 31234 $4,113.40 $7,500.00 19 Shop 449 Seymour, 4091 Brentwood Ln Amo 34466 $557.70 $5,000.00 22 Lindsey 458 Bonnie's Beautiful 9565 Ridge Rd. Tri City 32889 $4,053.80 $7,500.00 22 Boutique 677 Yates, Nick 231 Day Rd. Sunland FL 39876 $2,523.80 $2,500.00 35 733 Howler, Laura 1368 E. 1000 S. Lizton FL 34344 $3,658.05 $5,000.00 22 826 Harpersburg Bank 65 Forrest Blvd. Harpersburg FL. 31234 $6,824.55 $10,000.00 19 867 MarketPoint Sales 826 Host St. Easton FL. 33998 $3,089.00 $5,000.00 19 WorkOrders Orderline Order Num Order Date Client Num Order Num TaskID ScheduledDate QuotedPrice 67101 9/6/2018 733 67101 S177 9/10/2018 $144.00 67313 9/7/2018 458 67313 LASI 9/12/2018 $104.00 67424 9/10/2018 322 67424 M049 9/14/2018 $65.00 67838 9/10/2018 867 67424 UP38 9/14/2018 $185.00 67949 9/10/2018 322 67838 LASI 9/20/2018 $104.00 68252 9/12/2018 363 67949 PIS4 9/21/2018 $50.00 68868 9/14/2018 867 67949 VR39 9/21/2018 S88.00 68979 9/17/2018 826 67949 WA33 9/21/2018 $126.00 68252 DISS 9/24/2018 $50.00 68868 SA44 9/24/2018 $200.00 68979 AC65 9/27/2018 $77.00 68979 9/27/2018 $970.00 Tasks TaskID Description Category Price AC65 Accessories ACC $80.00 DA11 Data recovery major DRM $175.00 DI85 Data recovery minor DRM $50.00 HA63 Hardware major HAM $225.00 H131 Hardware minor HAM $165.70 LA81 Local area networking (LAN) LAN $104.00 M049 Mobility MOB $65.00 OT99 Other work OTH $99.99 PI54 Printing issues PRI $50.00 SA44 Software major SOM $200.00 SI77 Software minor SOM $144.00 SI91 Security install/repair SIR $126.00 UP38 Upgrades UPG $185.00 VR39 Virus removal VIR $90.00 WA33 Wide area networking (WAN) WAN $130.00 WC19 Web connectivity WEC $75.00 FIGURE 2-11 Sample data for BITS DA11