Concepts of Database Management |(9th Edition) See this solution in the app E Chapter 6, Problem 2BCE Bookmark Show all steps: ON Problem The following exercises are based on the BITS database user views as designed in Your Turn 6-1 in this chapter. In each exercise, represent your answer in DBDL and with a diagram. You may use any of the styles presented in this chapter for the diagram. Indicate the changes you need to make to the design of the BITS database to support the following situation. There is no relationship between clients and consultants. When a client places an order (service request), it may be performed by any consultant. On the order, identify both the client placing the order and the consultant responsible for the order. Many of the examples in this chapter use data froll Hours Rate 40 $22.50 40 $22.50 35 10 $15.00 FirstName Street Christopher 554 Brown Dr. City State ZipCode Tri City FL 32889 2287 Port Rd. Easton FI 33998 82 Elliott St. FL 34344 373 Lincoln Ln. Sunland FL 39876 Lizton 164 Balance $1,904.55 $2,814.55 State ZipCode FL 33998 FL 32889 FL 39876 City Easton Tri City Sunland FL 34344 FL Harpersburg FL 33998 31234 $900.75 $4,113.40 $557.70 32889 $4,053.80 Consultant ConsitNum LastName $20.00 19 Turner 22 Jordan Patrick 35 Allen Sarah 51 Shields Tom CreditLimit Consitum Client $2,500.00 19 ClientNum ClientName Street $5,000.00 19 143 Hershey, Jarrod 135 E. Mill Street $8,354.00 $10,000.00 22 175 Goduto, Sean 12 Saratoga Parkway 299 Two Crafty 9787 NCR 350 West Cousins $7,335.55 $10,000.00 35 322 Prichard's 501 Air Parkway Lizton $2,500.00 35 Pizza & Pasta 363 Salazar, Jason 56473 Cherry Tree Dr. Easton $7,500.00 19 405 Fisherman's 49 Elwood Ave. Spot Shop $5,000.00 22 FL 34466 449 Seymour, 4091 Brentwood Ln. Amo Lindsey $7,500.00 22 458 Bonnie's 9565 Ridge Rd. Tri City FL Beautiful Boutique 677 $2,523.80 $2,500.00 35 Yates, Nick Sunland FL 231 Day Rd. 39876 733 Howler, Laura $5,000.00 22 FI Lizton 1368 E. 1000 S. 34344 $3,658.05 826 $6,824.55 $10,000.00 19 Harpersburg 65 Forrest Blvd. Harpersburg FL 31234 Bank 867 MarketPoint 826 Host St. Easton FL 33998 $3,089.00 $5,000.00 19 Sales Tasks OrderLine TaskID Description Category Price Order Num TaskID Scheduled Date QuotedPrice AC65 Accessories ACC $80.00 67101 SI77 9/10/2018 $144.00 DA11 Data recovery major DRM $175.00 67313 LA81 9/12/2018 $104.00 D185 Data recovery minor DRM $50.00 67424 MO49 9/14/2018 $65.00 HA63 Hardware major HAM $225.00 67424 UP38 9/14/2018 $185.00 HI31 Hardware minor HAM $165.70 67838 LA81 9/20/2018 $104.00 LA81 Local area networking (LAN) LAN $104 00 67949 PI54 9/21/2018 $50.00 M049 Mobility MOB $65.00 67949 VR39 9/21/2018 OT99 Other work OTH $99.99 67949 WA33 9/21/2018 $126.00 PI54 Printing issues PRI $50.00 DISS 9/24/2018 SA44 Software major SOM $200.00 68868 SA44 9/24/2018 $200.00 SI77 Software minor SOM $144.00 68979 AC65 SI91 Security install/repair 9/27/2018 SIR $126.00 68979 9/27/2018 UP38 Upgrades UPG $185.00 Virus removal VIR $90.00 WA33 Wide area networking (WAN) WAN Client Num 67101 WC19 Web connectivity WEC $75.00 67313 733 67424 458 67838 322 867 322 68868 363 68979 867 826 FIGURE 5-1 Sample data for BITS $88.00 68252 $50.00 $77.00 $970.00 VR39 $130.00 DA11 Work Orders Order Num Order Date 9/6/2018 9/7/2018 9/10/2018 9/10/2018 67949 9/10/2018 68252 9/12/2018 9/14/2018 9/17/2018 Concepts of Database Management |(9th Edition) See this solution in the app E Chapter 6, Problem 2BCE Bookmark Show all steps: ON Problem The following exercises are based on the BITS database user views as designed in Your Turn 6-1 in this chapter. In each exercise, represent your answer in DBDL and with a diagram. You may use any of the styles presented in this chapter for the diagram. Indicate the changes you need to make to the design of the BITS database to support the following situation. There is no relationship between clients and consultants. When a client places an order (service request), it may be performed by any consultant. On the order, identify both the client placing the order and the consultant responsible for the order. Many of the examples in this chapter use data froll Hours Rate 40 $22.50 40 $22.50 35 10 $15.00 FirstName Street Christopher 554 Brown Dr. City State ZipCode Tri City FL 32889 2287 Port Rd. Easton FI 33998 82 Elliott St. FL 34344 373 Lincoln Ln. Sunland FL 39876 Lizton 164 Balance $1,904.55 $2,814.55 State ZipCode FL 33998 FL 32889 FL 39876 City Easton Tri City Sunland FL 34344 FL Harpersburg FL 33998 31234 $900.75 $4,113.40 $557.70 32889 $4,053.80 Consultant ConsitNum LastName $20.00 19 Turner 22 Jordan Patrick 35 Allen Sarah 51 Shields Tom CreditLimit Consitum Client $2,500.00 19 ClientNum ClientName Street $5,000.00 19 143 Hershey, Jarrod 135 E. Mill Street $8,354.00 $10,000.00 22 175 Goduto, Sean 12 Saratoga Parkway 299 Two Crafty 9787 NCR 350 West Cousins $7,335.55 $10,000.00 35 322 Prichard's 501 Air Parkway Lizton $2,500.00 35 Pizza & Pasta 363 Salazar, Jason 56473 Cherry Tree Dr. Easton $7,500.00 19 405 Fisherman's 49 Elwood Ave. Spot Shop $5,000.00 22 FL 34466 449 Seymour, 4091 Brentwood Ln. Amo Lindsey $7,500.00 22 458 Bonnie's 9565 Ridge Rd. Tri City FL Beautiful Boutique 677 $2,523.80 $2,500.00 35 Yates, Nick Sunland FL 231 Day Rd. 39876 733 Howler, Laura $5,000.00 22 FI Lizton 1368 E. 1000 S. 34344 $3,658.05 826 $6,824.55 $10,000.00 19 Harpersburg 65 Forrest Blvd. Harpersburg FL 31234 Bank 867 MarketPoint 826 Host St. Easton FL 33998 $3,089.00 $5,000.00 19 Sales Tasks OrderLine TaskID Description Category Price Order Num TaskID Scheduled Date QuotedPrice AC65 Accessories ACC $80.00 67101 SI77 9/10/2018 $144.00 DA11 Data recovery major DRM $175.00 67313 LA81 9/12/2018 $104.00 D185 Data recovery minor DRM $50.00 67424 MO49 9/14/2018 $65.00 HA63 Hardware major HAM $225.00 67424 UP38 9/14/2018 $185.00 HI31 Hardware minor HAM $165.70 67838 LA81 9/20/2018 $104.00 LA81 Local area networking (LAN) LAN $104 00 67949 PI54 9/21/2018 $50.00 M049 Mobility MOB $65.00 67949 VR39 9/21/2018 OT99 Other work OTH $99.99 67949 WA33 9/21/2018 $126.00 PI54 Printing issues PRI $50.00 DISS 9/24/2018 SA44 Software major SOM $200.00 68868 SA44 9/24/2018 $200.00 SI77 Software minor SOM $144.00 68979 AC65 SI91 Security install/repair 9/27/2018 SIR $126.00 68979 9/27/2018 UP38 Upgrades UPG $185.00 Virus removal VIR $90.00 WA33 Wide area networking (WAN) WAN Client Num 67101 WC19 Web connectivity WEC $75.00 67313 733 67424 458 67838 322 867 322 68868 363 68979 867 826 FIGURE 5-1 Sample data for BITS $88.00 68252 $50.00 $77.00 $970.00 VR39 $130.00 DA11 Work Orders Order Num Order Date 9/6/2018 9/7/2018 9/10/2018 9/10/2018 67949 9/10/2018 68252 9/12/2018 9/14/2018 9/17/2018