The homework is the BITS Corporation Exercises: QBE on pg 70, #2, 3, 4, 5, 6, 8, 9, 10, 12 and 13. Draw the lower pane of the QBE design grid. Do NOT use Access to complete the exercises. Do NOT give me the results of the queries.

.

List the complete Tasks table.

List the number and name of all clients represented by consultant 19.

List the number and name of all clients that are represented by consultant 19 and that have a credit limit of $10,000.

List the number and name of all clients that are represented by consultant 19 or that have a credit limit of $10,000.

For each order, list the order number, order date, number of the client that placed the order, and name of the client that placed the order.

I'm not looking for the complete assignment to be done just a sample I am lost. This is to use the QBE method and not have results any help is welcomed.

Transcribed Image Text:

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

Answer rating: 100% (QA)

DT ConsitNum First Name Lastolame Consultant 2 T TASKID Desc... View the full answer