Consultant ConsltNum LastName FirstName Street City State ZipCode Hours Rate Christopher 554 Brown Dr. Patrick 19 Turner Tri City FL 32889 40 $22.50 22 $22.50 Jordan Allen Shields 2287 Port Rd. Easton...


Create a class diagram for the BITS Corporation database, as shown in Figure 1-5 in Chapter 1 (see attached image). If you need to make any assumptions when preparing the class diagram, document those assumptions.



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

Extracted text: Consultant ConsltNum LastName FirstName Street City State ZipCode Hours Rate Christopher 554 Brown Dr. Patrick 19 Turner Tri City FL 32889 40 $22.50 22 $22.50 Jordan Allen Shields 2287 Port Rd. Easton FL 33998 40 35 Sarah 82 Elliott St. Lizton FL 34344 35 $20.00 51 Tom 373 Lincoln Ln. Sunland FL 39876 10 $15.00 Client ClientNum ClientName Street City State ZipCode Balance CreditLimit ConsltNum Hershey, Jarrod 135 E. Mill Street 12 Saratoga Parkway 143 Easton FL 33998 $1,904.55 $2,500.00 19 175 Goduto, Sean Tri City FL 32889 $2,814.55 $5,000.00 19 299 Two Crafty 9787 NCR 350 W'est Sunland FL 39876 $8,354.00 $10,000.00 22 Cousins 322 Prichard's Pizza 501 Air Parkway Lizton FL 34344 $7,335.55 $10,000.00 35 & Pasta FL Harpersburg FL 363 Salazar, Jason 56473 Cherry Tree Dr. Easton 33998 $900.75 $2,500.00 35 405 Fisherman's 49 Elwood Ave. 31234 $4,113.40 $7,500.00 19 Spot Shop 449 Seymour, 4091 Brentwood Ln Amo FL 34466 $557.70 $5,000.00 22 Lindsey 458 Bonnie's 9565 Ridge Rd. Tri City FL 32889 $4,053.80 $7,500.00 22 Beautiful 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 65 Forrest Blvd. Harpersburg FL 31234 $6,824.55 $10,000.00 19 Bank 867 MarketPoint 826 Host St. Easton FL 33998 $3,089.00 $5,000.00 19 Sales Tasks OrderLine TaskID Description Category Price OrderNum TaskID ScheduledDate QuotedPrice 9/10/2018 9/12/2018 АС65 Accessories ACC $80.00 67101 SI77 $144.00 DA11 Data recovery major DRM $175.00 67313 LA81 $104.00 DI85 Data recovery minor DRM $50.00 67424 МО49 9/14/2018 $65.00 НА63 Hardware major НАМ $225.00 67424 UP38 9/14/2018 $185.00 HI31 Hardware minor НАМ $165.70 67838 LA81 9/20/2018 $104.00 LA81 Local area networking (LAN) LAN $104 00 67949 PI54 9/21/2018 $50.00 МО49 Mobility МОВ $65.00 67949 VR39 9/21/2018 $88.00 ОТ9 Other work ΟΤΗ $99.99 67949 WA33 9/21/2018 $126.00 68252 DI85 9/24/2018 $50.00 PI54 Printing issues PRI $50.00 68868 SA44 9/24/2018 $200.00 SA44 Software major SOM $200.00 SI77 Software minor SOM $144.00 68979 AC65 9/27/2018 $77.00 68979 DA11 9/27/2018 $970.00 S191 Security install/repair SIR $126.00 UP38 Upgrades UPG $185.00 WorkOrders VR39 Virus removal VIR $90.00 WA33 Wide area networking (WAN) WAN $130.00 OrderNum OrderDate ClientNum WC19 Web connectivity $75.00 67101 9/6/2018 733 WEC 67313 9/7/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

Jun 11, 2022
SOLUTION.PDF

Get Answer To This Question

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here