Homework Help is Here – Start Your Trial Now!
Engineering
Computer Engineering
omplete the sql querry.  Do asp

omplete the sql querry.  Do asp

Computer Networking: A Top-Down Approach (7th Edition)
Computer Networking: A Top-Down Approach (7th Edition)
7th Edition
ISBN:9780133594140
Author:James Kurose, Keith Ross
Publisher:James Kurose, Keith Ross
Chapter1: Computer Networks And The Internet
Section: Chapter Questions
Problem R1RQ: What is the difference between a host and an end system? List several different types of end...
See similar textbooks
icon
Related questions
Question

Complete the sql querry. 

Do asp

 

 

The Ch07_ConstructCo database stores data for a consulting company that tracks all charges to projects. The charges are based on the hours each employee works on each project. Given the structure and contents of the Ch07_ConstructCo database shown in Figure 2. Figure 2. Ch07_ConstructCo database Relational Diagram Database name: Ch07_ConstructCo ASSIGNMENT V ASSIGN NUM ASSIGN_DATE Table name: EMPLOYEE EMP NUM EMP LNAME EMP FNAME EMP INITIAL EMP HIREDATE JOB_CODE EMP YEARS JOB V JOB.CODE JOB,DESCRIPION JOB CHG HOUR JOB_LAST UPDATE 101 News John G 08-Nov-00 502 8. PROJ NUM 102 Senior David H 12Jul-89 501 19 EMP NUM ASSIGNJOB 12 103 Arbough Ramoras June E 01-Dec-96 503 ASSIGN_CHG HR ASSIGN_HOURS ASSIGN CHARGE 15-Nov-87 501 01-Feb-93 502 104 Anne Alice William K 21 16 4 105 Johnson K EMPLOVEE PROECT V PROLNUM PROJ NAME PROI VALUE PROI BALANCE EMP NUM 106 Smithfield 22-Jun-04 500 10-Oct-93 500 9 EMP NUM EMP LNAME EMP FAME EMP INTAL EMP HOREDATE JOB CODE EMP VEARS 107 Alonzo Maria 15 17 108 109 Washington Smith Ralph B 22-Aug-91 501 18-Jul-97 501 Larry Gerald W 11 110 Olenko A 11-Dec-95 505 13 17 14 12 15 17 12 12 4 04-Apr-91 506 23-Oct-94 507 111 Wabash Geoff B 112 Smithson Darlene 113 Joenbrood Delbert K 15-Nov-96 508 Table name: JOB JOB CODE JOB DESCRIPTION JOB CHG HOUR JOB LAST UPDATE 500 501 502 114 Jones Annelise 115 116 20-Aug-93 508 25-Jan-92 501 Bawangi Travis B Programmer Systems Analyst Database Designer Electrical Engineer Mechanical Engineer Civil Engineer Clerical Support DSS Analyst Applications Designer Bio Technician General Support 20-Nov-09 20-Nov-09 24-Mar-10 20-Nov-09 20-Nov-09 20-Nov-09 Table name: ASSIGNMENT 20-Nov-09 ASSIGN_NUM ASSIGN_DATE PROJ NUM EMP NUM ASSIGN JOB ASSIGN_CHG HR ASSIGN HOURS ASSIGN_CHARGE 20-Nov-09 24-Mar-10 20-Nov-09 20-Nov-09 35.75 Pratt Gerald 05-Mar-97 510 96.75 125.00 84.50 117 Williamson Angie 19-Jun-96 509 04-Jan-05 510 118 Frommer James J 503 504 67.90 505 55.78 506 26.87 103 295.75 145.11 69. 10 498.55 45.95 1001 1002 22-Mar-10 18 503 84.50 3.5 42 507 22-Mar-10 22 117 509 34. 55 508 509 510 48. 10 34.55 1003 22-Mar-10 18 117 509 34.55 20 1004 22-Mar-10 18 103 503 84.50 96.75 96.75 5.9 18.36 1005 22-Mar-10 25 108 501 22 212.85 1006 22-Mar-10 22 104 501 42 406 35 Table name: PROJECT 192 85 76.05 541.80 82 92 451.50 328.95 193.50 270.90 515 45 493 50 1007 22-Mar-10 25 113 103 115 117 105 508 50.75 3.8 22-Mar-10 18 23-Mar-10 15 1008 503 84.50 0.9 PROJ_NUM PROJ_NAME PROJ_VALUE PROJ_BALANCE EMP_NUM 1453500.00 3500500.00 805000.00 2650500.00 1009 501 96.75 5.6 24 4.3 15 Evergreen 1002350.00 103 1010 23-Mar-10 15 509 34. 55 105.00 96.75 18 Amber Wave 2110346.00 108 1011 23-Mar-10 25 23-Mar-10 18 502 500345 20 102 2309880.00 107 22 Rolling Tide Starfight 1012 108 501 3.4 25 1013 23-Mar-10 25 115 501 96.75 20 1014 23-Mar-10 22 104 103 501 96.75 28 1015 23-Mar-10 15 503 84.50 6.1 23-Mar-10 22 23-Mar-10 18 23-Mar-10 25 24-Mar-10 25 1016 105 502 105 00 4.7 1017 117 509 509 501 34.55 38 131.29 1018 117 34.55 22 76.01 541.45 387.50 298.35 541.45 1019 104 110 50 4.9 1020 24-Mar-10 15 101 502 501 125.00 3.1 24-Mar-10 22 24-Mar-10 22 1021 110.50 110 50 108 2.7 1022 115 501 4.9 1023 24-Mar-10 22 105 502 125.00 3.5 437.50 278.85 145.11 1024 24-Mar-10 15 24-Mar-10 18 103 503 509 84.50 3.3 42 1025 117 34.55 Submission Guide: Upload a text file that contains all SQL statements. * SQL statements include creating the four tables(JOB, EMPLOYEE, PROJECT, and ASSIGNMENT), setting primary keys and necessary foreign keys, and inserting at least two records into each table.
Transcribed Image Text:The Ch07_ConstructCo database stores data for a consulting company that tracks all charges to projects. The charges are based on the hours each employee works on each project. Given the structure and contents of the Ch07_ConstructCo database shown in Figure 2. Figure 2. Ch07_ConstructCo database Relational Diagram Database name: Ch07_ConstructCo ASSIGNMENT V ASSIGN NUM ASSIGN_DATE Table name: EMPLOYEE EMP NUM EMP LNAME EMP FNAME EMP INITIAL EMP HIREDATE JOB_CODE EMP YEARS JOB V JOB.CODE JOB,DESCRIPION JOB CHG HOUR JOB_LAST UPDATE 101 News John G 08-Nov-00 502 8. PROJ NUM 102 Senior David H 12Jul-89 501 19 EMP NUM ASSIGNJOB 12 103 Arbough Ramoras June E 01-Dec-96 503 ASSIGN_CHG HR ASSIGN_HOURS ASSIGN CHARGE 15-Nov-87 501 01-Feb-93 502 104 Anne Alice William K 21 16 4 105 Johnson K EMPLOVEE PROECT V PROLNUM PROJ NAME PROI VALUE PROI BALANCE EMP NUM 106 Smithfield 22-Jun-04 500 10-Oct-93 500 9 EMP NUM EMP LNAME EMP FAME EMP INTAL EMP HOREDATE JOB CODE EMP VEARS 107 Alonzo Maria 15 17 108 109 Washington Smith Ralph B 22-Aug-91 501 18-Jul-97 501 Larry Gerald W 11 110 Olenko A 11-Dec-95 505 13 17 14 12 15 17 12 12 4 04-Apr-91 506 23-Oct-94 507 111 Wabash Geoff B 112 Smithson Darlene 113 Joenbrood Delbert K 15-Nov-96 508 Table name: JOB JOB CODE JOB DESCRIPTION JOB CHG HOUR JOB LAST UPDATE 500 501 502 114 Jones Annelise 115 116 20-Aug-93 508 25-Jan-92 501 Bawangi Travis B Programmer Systems Analyst Database Designer Electrical Engineer Mechanical Engineer Civil Engineer Clerical Support DSS Analyst Applications Designer Bio Technician General Support 20-Nov-09 20-Nov-09 24-Mar-10 20-Nov-09 20-Nov-09 20-Nov-09 Table name: ASSIGNMENT 20-Nov-09 ASSIGN_NUM ASSIGN_DATE PROJ NUM EMP NUM ASSIGN JOB ASSIGN_CHG HR ASSIGN HOURS ASSIGN_CHARGE 20-Nov-09 24-Mar-10 20-Nov-09 20-Nov-09 35.75 Pratt Gerald 05-Mar-97 510 96.75 125.00 84.50 117 Williamson Angie 19-Jun-96 509 04-Jan-05 510 118 Frommer James J 503 504 67.90 505 55.78 506 26.87 103 295.75 145.11 69. 10 498.55 45.95 1001 1002 22-Mar-10 18 503 84.50 3.5 42 507 22-Mar-10 22 117 509 34. 55 508 509 510 48. 10 34.55 1003 22-Mar-10 18 117 509 34.55 20 1004 22-Mar-10 18 103 503 84.50 96.75 96.75 5.9 18.36 1005 22-Mar-10 25 108 501 22 212.85 1006 22-Mar-10 22 104 501 42 406 35 Table name: PROJECT 192 85 76.05 541.80 82 92 451.50 328.95 193.50 270.90 515 45 493 50 1007 22-Mar-10 25 113 103 115 117 105 508 50.75 3.8 22-Mar-10 18 23-Mar-10 15 1008 503 84.50 0.9 PROJ_NUM PROJ_NAME PROJ_VALUE PROJ_BALANCE EMP_NUM 1453500.00 3500500.00 805000.00 2650500.00 1009 501 96.75 5.6 24 4.3 15 Evergreen 1002350.00 103 1010 23-Mar-10 15 509 34. 55 105.00 96.75 18 Amber Wave 2110346.00 108 1011 23-Mar-10 25 23-Mar-10 18 502 500345 20 102 2309880.00 107 22 Rolling Tide Starfight 1012 108 501 3.4 25 1013 23-Mar-10 25 115 501 96.75 20 1014 23-Mar-10 22 104 103 501 96.75 28 1015 23-Mar-10 15 503 84.50 6.1 23-Mar-10 22 23-Mar-10 18 23-Mar-10 25 24-Mar-10 25 1016 105 502 105 00 4.7 1017 117 509 509 501 34.55 38 131.29 1018 117 34.55 22 76.01 541.45 387.50 298.35 541.45 1019 104 110 50 4.9 1020 24-Mar-10 15 101 502 501 125.00 3.1 24-Mar-10 22 24-Mar-10 22 1021 110.50 110 50 108 2.7 1022 115 501 4.9 1023 24-Mar-10 22 105 502 125.00 3.5 437.50 278.85 145.11 1024 24-Mar-10 15 24-Mar-10 18 103 503 509 84.50 3.3 42 1025 117 34.55 Submission Guide: Upload a text file that contains all SQL statements. * SQL statements include creating the four tables(JOB, EMPLOYEE, PROJECT, and ASSIGNMENT), setting primary keys and necessary foreign keys, and inserting at least two records into each table.
Expert Solution
steps

Step by step

Solved in 2 steps

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Recommended textbooks for you
Computer Networking: A Top-Down Approach (7th Edi…
Computer Networking: A Top-Down Approach (7th Edi…
Computer Engineering
ISBN:
9780133594140
Author:
James Kurose, Keith Ross
Publisher:
PEARSON
Computer Organization and Design MIPS Edition, Fi…
Computer Organization and Design MIPS Edition, Fi…
Computer Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
Network+ Guide to Networks (MindTap Course List)
Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning
Concepts of Database Management
Concepts of Database Management
Computer Engineering
ISBN:
9781337093422
Author:
Joy L. Starks, Philip J. Pratt, Mary Z. Last
Publisher:
Cengage Learning
Prelude to Programming
Prelude to Programming
Computer Engineering
ISBN:
9780133750423
Author:
VENIT, Stewart
Publisher:
Pearson Education
Sc Business Data Communications and Networking, T…
Sc Business Data Communications and Networking, T…
Computer Engineering
ISBN:
9781119368830
Author:
FITZGERALD
Publisher:
WILEY
SEE MORE TEXTBOOKS