Homework Help is Here – Start Your Trial Now!
Engineering
Computer Science
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.

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.

Database System Concepts
Database System Concepts
7th Edition
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Chapter1: Introduction
Section: Chapter Questions
Problem 1PE
See similar textbooks
icon
Related questions
Question

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 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
Transcribed Image 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
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps with 1 images

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Knowledge Booster
Distributed Database Concepts
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Database System Concepts
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education
SEE MORE TEXTBOOKS