BITS Corporation Exercises Open a new Microsoft Word document and answer each of the following questions using the BITS data shown in Figure 1-5. No computer work is required. Save the file on your computer with your last name in the file name. (Example: case_1-1 _Jones.doc) Click the Choose File button to find and select your saved document. Consultant ConstNum 19 22 LastName PrstName Street Tumer Christopher 554 Brown Dr Jordan Patrick 2287 Port Rd. Alen Sarah 82 Flott St. Shields Tom 373 Lincoln In City State ZipCodo Tr City FI. 32889 Faston 3 3948 Linton FL 34344 Sunland 11. 39876 Hours Rate 40 $22:50 40 522.50 5 $20.00 10 $15.00 3 City Client clientNum 143 175 299 Balance CreditLimit Constum $1,904.35 $2,500,00 19 $2,814:55 $5,000.00 19 58,354.00 $10,000.00 22 322 5733555 510,000.00 35 363 405 5900.75 54,113.40 $2,500.00 37.500.00 ClientName Street State Zip Code Hershey, Jarrod 135 E MU Street Easton 1 1. 33998 Goduto, Sean 12 Saratoga Parkway Tn Cay 11 32889 Two Crafty 9787 NCR 350 West Sunland 11. 39876 Cousins Prichards Pigra 501 Air Parkway inton F. 34314 & Pasta Salazar, Jason 56473 Cherry Tree Dr. Easton Fisherman's 49 wood Ave. Harpenburg 11. 1234 Spot Shop Seymour, 4091 Brentwood In Amo F1. Lindsey Bonnie's 9565 Ridge Rd. . Beautiful Boutique Yates, Nick 231 Day Rd. Sunland FL 39876 Howlet, Laura 1368 E. 1000 S Luton 11. 34344 Harpersburg 65 Forrest Blvd. Harpersburg FL 31234 35 19 34466 5357.70 $5,000.00 22 458 54,053,80 37.500.00 22 733 $2,523.80 $2,500.00 35 $3,658.05 $5,000.00 22 $6,82455 510,000.00 19 26 Faston 26 Host St. L. 33998 $3,089.00 19 $5,000.00 Market Point Sales WDTAP e 1 BITS Corporation Exercises Q Search this cour Tasks Taska AC65 DA11 DISS. HA63 H131 LAS MO-49 OT99 PI54 SA44 Description Category Accessories ACC Data recovery major DRM Data recovery minor DRM Hardware major HAM Hardware minor HAM Local area networking (LAN LAN Mobility MOB Other work OTH Printing issues PRI Software major SOM Software minor SOM Security install repair Upgrades UPG Virus removal VIR Wide area networking (WAN) WAN Web connectivity WEC Price $80.00 $175.00 $50.00 $225.00 $165.70 $10400 $65.00 $99.99 $50,00 $200.00 $144.00 $126.00 S185.00 $90.00 $130.00 $75.00 5177 Orderline Order Num Taskid Taskid ScheduledDate QuotedPrice 67101 S177 9/10/2018 67313 $144.00 LAST 9/12/2018 $104.00 67424 M049 9/14/2018 $65.00 67424 UPIS 9/14/2018 $185.00 67838 1.ASI 9/20/2018 $104.00 67949 P154 9/21/2018 $50.00 67949 VR 39 9/21/2018 $88.00 67949 WA33 921/2018 $126.00 68252 DISS 9/24/2018 $50.00 68868 SA44 9/24/2018 $200.00 68979 AC65 927/2018 $77.00 68979 DA11 9/27/2018 $970.00 Work Orders Order Num Order Date ClientNum 67101 9,6/2018 733 67313 97/2018 458 67424 9/10/2018 322 67838 9/10/2018 867 67949 9/10/2018 322 68252 9/12/2018 363 68868 9/14/2018 867 68979 9/17/2018 826 SIR S191 UP38 VR39. WA33 WC19 FIGURE 1-5 Sample data for BITS 1. List the names of all clients that have a credit limit that is less than $10,000. 2. List the descriptions of all items in the Tasks table that have the category DRM. 3. List the order numbers for orders placed by client number 322 on September 10, 2018. 4. List the order date and the scheduled date any work order involving task SA44. 5. List the name of each client that placed an order for two different tasks in the same order. 6. List the name of each client that has a credit limit of $5,000 and is represented by Patrick Jordan. 7. Find the sum of the balances for all customers represented by Christopher Turner 8. For each order, list the order number, order date, client number, and client name. 9. For each order placed on September 10, 2018, list the order number, order date, client number, and client name. 10. For each order placed on September 17, 2018, list the order number and client name, along with the name of the client's consultant. 11. BITS needs to be able to contact clients when problems arise concerning an order. What other attributes could BITS Auguste Dock Savedim.Me 21 Q Search this Corporation Exercises 68979 9/17/2018 826 FIGURE 1-5 Sample data for BITS 1. List the names of all clients that have a credit limit that is less than $10,000. 2. List the descriptions of all items in the Tasks table that have the category DRM. 3. List the order numbers for orders placed by client number 322 on September 10, 2018. 4. List the order date and the scheduled date any work order involving task SA44. 5. List the name of each client that placed an order for two different tasks in the same order. 6. List the name of each client that has a credit limit of $5,000 and is represented by Patrick Jordan. 7. Find the sum of the balances for all customers represented by Christopher Turner. 8. For each order, list the order number, order date, client number, and client name. 9. For each order placed on September 10, 2018, list the order number, order date, client number, and client name. 10. For each order placed on September 17, 2018, list the order number and client name, along with the name of the client's consultant. 11. BITS needs to be able to contact clients when problems arise concerning an order. What other attributes could BITS include in the Customer table to assist in contacting customers? 12. BITS wants the database to include data on all its employees, not just consultants. What additional entities would the DBA need to include in the database to store this data? What attributes? 13. What kinds of unstructured data or big data might the BITS corporation want to gather in the future? What kind of devices might they use for input? How would they store the data? BITS Corporation Exercises Open a new Microsoft Word document and answer each of the following questions using the BITS data shown in Figure 1-5. No computer work is required. Save the file on your computer with your last name in the file name. (Example: case_1-1 _Jones.doc) Click the Choose File button to find and select your saved document. Consultant ConstNum 19 22 LastName PrstName Street Tumer Christopher 554 Brown Dr Jordan Patrick 2287 Port Rd. Alen Sarah 82 Flott St. Shields Tom 373 Lincoln In City State ZipCodo Tr City FI. 32889 Faston 3 3948 Linton FL 34344 Sunland 11. 39876 Hours Rate 40 $22:50 40 522.50 5 $20.00 10 $15.00 3 City Client clientNum 143 175 299 Balance CreditLimit Constum $1,904.35 $2,500,00 19 $2,814:55 $5,000.00 19 58,354.00 $10,000.00 22 322 5733555 510,000.00 35 363 405 5900.75 54,113.40 $2,500.00 37.500.00 ClientName Street State Zip Code Hershey, Jarrod 135 E MU Street Easton 1 1. 33998 Goduto, Sean 12 Saratoga Parkway Tn Cay 11 32889 Two Crafty 9787 NCR 350 West Sunland 11. 39876 Cousins Prichards Pigra 501 Air Parkway inton F. 34314 & Pasta Salazar, Jason 56473 Cherry Tree Dr. Easton Fisherman's 49 wood Ave. Harpenburg 11. 1234 Spot Shop Seymour, 4091 Brentwood In Amo F1. Lindsey Bonnie's 9565 Ridge Rd. . Beautiful Boutique Yates, Nick 231 Day Rd. Sunland FL 39876 Howlet, Laura 1368 E. 1000 S Luton 11. 34344 Harpersburg 65 Forrest Blvd. Harpersburg FL 31234 35 19 34466 5357.70 $5,000.00 22 458 54,053,80 37.500.00 22 733 $2,523.80 $2,500.00 35 $3,658.05 $5,000.00 22 $6,82455 510,000.00 19 26 Faston 26 Host St. L. 33998 $3,089.00 19 $5,000.00 Market Point Sales WDTAP e 1 BITS Corporation Exercises Q Search this cour Tasks Taska AC65 DA11 DISS. HA63 H131 LAS MO-49 OT99 PI54 SA44 Description Category Accessories ACC Data recovery major DRM Data recovery minor DRM Hardware major HAM Hardware minor HAM Local area networking (LAN LAN Mobility MOB Other work OTH Printing issues PRI Software major SOM Software minor SOM Security install repair Upgrades UPG Virus removal VIR Wide area networking (WAN) WAN Web connectivity WEC Price $80.00 $175.00 $50.00 $225.00 $165.70 $10400 $65.00 $99.99 $50,00 $200.00 $144.00 $126.00 S185.00 $90.00 $130.00 $75.00 5177 Orderline Order Num Taskid Taskid ScheduledDate QuotedPrice 67101 S177 9/10/2018 67313 $144.00 LAST 9/12/2018 $104.00 67424 M049 9/14/2018 $65.00 67424 UPIS 9/14/2018 $185.00 67838 1.ASI 9/20/2018 $104.00 67949 P154 9/21/2018 $50.00 67949 VR 39 9/21/2018 $88.00 67949 WA33 921/2018 $126.00 68252 DISS 9/24/2018 $50.00 68868 SA44 9/24/2018 $200.00 68979 AC65 927/2018 $77.00 68979 DA11 9/27/2018 $970.00 Work Orders Order Num Order Date ClientNum 67101 9,6/2018 733 67313 97/2018 458 67424 9/10/2018 322 67838 9/10/2018 867 67949 9/10/2018 322 68252 9/12/2018 363 68868 9/14/2018 867 68979 9/17/2018 826 SIR S191 UP38 VR39. WA33 WC19 FIGURE 1-5 Sample data for BITS 1. List the names of all clients that have a credit limit that is less than $10,000. 2. List the descriptions of all items in the Tasks table that have the category DRM. 3. List the order numbers for orders placed by client number 322 on September 10, 2018. 4. List the order date and the scheduled date any work order involving task SA44. 5. List the name of each client that placed an order for two different tasks in the same order. 6. List the name of each client that has a credit limit of $5,000 and is represented by Patrick Jordan. 7. Find the sum of the balances for all customers represented by Christopher Turner 8. For each order, list the order number, order date, client number, and client name. 9. For each order placed on September 10, 2018, list the order number, order date, client number, and client name. 10. For each order placed on September 17, 2018, list the order number and client name, along with the name of the client's consultant. 11. BITS needs to be able to contact clients when problems arise concerning an order. What other attributes could BITS Auguste Dock Savedim.Me 21 Q Search this Corporation Exercises 68979 9/17/2018 826 FIGURE 1-5 Sample data for BITS 1. List the names of all clients that have a credit limit that is less than $10,000. 2. List the descriptions of all items in the Tasks table that have the category DRM. 3. List the order numbers for orders placed by client number 322 on September 10, 2018. 4. List the order date and the scheduled date any work order involving task SA44. 5. List the name of each client that placed an order for two different tasks in the same order. 6. List the name of each client that has a credit limit of $5,000 and is represented by Patrick Jordan. 7. Find the sum of the balances for all customers represented by Christopher Turner. 8. For each order, list the order number, order date, client number, and client name. 9. For each order placed on September 10, 2018, list the order number, order date, client number, and client name. 10. For each order placed on September 17, 2018, list the order number and client name, along with the name of the client's consultant. 11. BITS needs to be able to contact clients when problems arise concerning an order. What other attributes could BITS include in the Customer table to assist in contacting customers? 12. BITS wants the database to include data on all its employees, not just consultants. What additional entities would the DBA need to include in the database to store this data? What attributes? 13. What kinds of unstructured data or big data might the BITS corporation want to gather in the future? What kind of devices might they use for input? How would they store the data