Question: FIGURE P7.1 THE CH07_CONSTRUE Relational diagram ASSEMENT Passion 105 EMPLOYEE Pob Code ob Description Rob Che Hour Job Last Update PK -H--04 ---- ump Name

FIGURE P7.1 THE CH07_CONSTRUE Relational diagram

FIGURE P7.1 THE CH07_CONSTRUE Relational diagram ASSEMENT Passion 105 EMPLOYEE Pob Code ob Description Rob Che Hour Job Last Update PK -H--04 ---- ump Name Emp_Pame Emp Initi Emprebate FKI Rob Code Emp_Years Assign Date FK Prol. Num FKL Emp Num AssignJob PROTECT Air Cher ---- Assign_Hears PIL Assign Charge Praj Name Prol Value Prol_Balance FRI Emp Nam Database name: Ch07 Constructco Tabie naine: EMPLOYEE CMP_NUMEWP_LNAME EMPFNAME EMP_INTIAL I EROP JEREBATE JOB_CODE EMP_YEARS 101 News John 08-Nov-00 502 17 102 Senior David H 12-Jul-89 501 28 103 Arbcugh June E 01-Dec-96 500 21 104 Ramoras Anne K 15-Nov-87 501 30 105 Johnson Alice K 01-Feb-93 502 25 106 Smithfield William 22-Jun-04 500 13 107 Alonzo Maria D 10-Oct-93 500 24 108 Washington Ralph B 22-Aug-91 501 26 109 Smith Larry W 18-Jul-97 501 20 110 Olenko Gerald A 11-Dec-95 505 22 111 Wabash B Geoff 11 27 04-Apr-91 506 112 Smithson Darlene M 23-Oct-94 507 23 Joenbrood 113 Delbert K 21 15-Nov-96 508 114 Jones Annelise 20-Aug-93 508 24 115 Bawangi Travis 25-Jan-92 501 26 116 Pratt Gerald 05-Mar-97 510 21 117 Viliamson Angie 19-Jun-96 509 21 118 Frommer James 04-Jan-OS 510 13 CIO ZOO Table name: JOB 008_CODE JOE_DESCRPTION 500 Programmer 501 Systems Analyst 502 Database Designer 500 Bectrical Engineer 504 Mechanical Engineer SOS CM Engineer 508 Clerical Support 507 DSS Analyst 508 Applications Designer 509 Bio Technician 510 General Support JOB_CHG_HOUR JOB LAST UPDATE 35.75 20-Nov-17 96.75 20-Nov-17 125 00 24-Mar-18 84.50 20-Nov-17 67.90 20-Nov-17 55.78 20-Nov-17 26 87 20-Nov-17 45 95 20-Nov-17 48 10 24-Mar-18 34.55 20-Nov-17 18.36 20-Nov-17 Table name: PROJECT PROJ_NUM PROJ NAME PROJ_VALUE 15 Evergreen 1453500.00 18 Amber Wave 3500500.00 22 Rolling Tide 805000.00 25 Starfight 2850500.00 PROJ_BALANCE EMP_NUM 1002350.00 103 2110346.00 108 500345 20 102 2309880.00 107 Table name: ASSIGNMENT ASSION_NUM ASSIGN_DATE PROJ_NUM EMP NUM ASSION_JOB ASSION_CHOIR ASSIGN HOURS ASSIGN CHARGE 1001 22 Mar 18 18 103 503 84.5 3.5 295.75 1002 22-Mar-18 22 117 909 34.55 4.2 145.11 1003 22-Mar-18 18 117 509 34.55 2 69.1 1004 22-Mar-18 18 103 500 84.5 5.9 498.56 1005 22-Mar-18 25 108 501 96.75 22 212.85 1006 22-Mar-18 22 104 501 96.75 4.2 408.35 1007 22-Mar-18 25 113 508 50.75 3.B 192 BS 100B 22-Mar-18 18 100 503 84.5 0.9 7805 1009 23-Mi-18.15 115 501 96.75 5.6 541.8 1010 23-Mar-1815 117 509 34.55 2.4 82.92 1011 23-Mar-18/25 109 502 105 4.3 451.5 1012 23-Mar-18 18 100 501 96.75 3.4 328.95 1013 23-Mar-18 25 115 501 96.75 2 193.5 1014 23-Mar-18 22 104 501 93.75 28 2709 1015 23-Mar-18 15 103 SO3 84.5 6.1 $15.45 1016 23-Mar-18 22 105 902 105 4.7 4935 1017 23 Mar-18 18 1117 509 34.55 3.8 13129 1010 23-Mar-18 25 117 509 3455 22 76.01 1019 24-Mar-18 25 104 501 110.5 4.9 541.45 1020 24-Mar-18 15 101 502 125 3.1 3875 24-Mar-18 22 1021 108 110.5 501 2.7 298 35 1022 24 Mar-18 22 115 501 110.5 4.9 541 45 1023 24-Mar-18 22 105 502 125 3.5 437 1024 24-Mar-18 15 103 503 84.5 3.3 278 85 1025 24-Mar-18 18 117 509 34.55 4.2 145.11 2. Using the EMPLOYEE, JOB, and PROJECT tables in the Ch07_ConstructCo data- base, write the SQL code that will join the EMPLOYEE and PROJECT tables using EMP_NUM as the common attribute. Display the attributes shown in the results presented in Figure P7.2, sorted by project value. FIGURE P7.2 THE QUERY RESULTS FOR PROBLEM 2 PROJ_NAME Rolling Tide Evergreen Starflight Amber Wave PROJ_VALUE PROJ_BALANCE EMP_LNAME EMP_FNAME EMP_INITIAL JOB_CODE JOB_DESCRIPTION JOB_CHG_HOUR 805000.00 500345 20 Senior David H 501 Systems Analyst 96.75 1453500.00 1002350.00 Arbough June E 500 Programmer 35.75 2650500.00 2309880.00 Alonzo D 500 Programmer 35.75 3500500.00 2110346.00 Washington Ralph B 501 Systems Analyst 96.75 Maria Write the SOL code that will produce the same information that was shown in

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

Write the SQL code to validate the ASSIGN_CHARGE values in the ASSIGNMENT table. Your query should retrieve the assignment number, employee number, project number, the stored assignment charge...

Use Figure p7.1 for the following questions 1. Write the SQL code required to Output Employee number Last name first name middle intial Requirement Only return the above for users whose Last Name...

Problem: 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. The structure...

FIGURE P7.1 THE CH07 CONSTRUCTCO DATABASE Database name: Ch07_ConstructCo Relational diagram Table name: EMPLOYEE EMP YEARS -Nov-00 50 102 21 22-An-08 00 00-93 600 1-Dec-95 50 23-00-99 50 rood Debert...

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. The structure and...

Answer 15,16,17,18,19,20,21,22,23 15. Write the SQL code required to list all employees whose last names start with Smith. In other words, the rows for both Smith and Smithfield should be included in...

The link lengths, coupler point location, and the values of ? 2 , ? 2 , and ? 2 for the same fourbar linkages as used for position and velocity analysis in Chapters 4 and 6 are redefined in Table...

Use the instant center method to solve Can somebody help me? 1 Locate the instant centers for each of the four-bar mechanisms shown in Figure P7.1. (a) (b) Chapter 7 Velocity (c) FIGURE P7.1 7.2...

1. Using Figure P7.1 in the text as a guide, write the SQL/DDL to create the Job and EMPLOYEE tables Note the cardinality requirements for the relationship indicates a foreign key and values are...

Write the SQL code to generate the total hours worked and the total charges made by all employees. The results are shown in Figure P7.8 . FIGURE P7.1 THE CH07_CONSTRUCTCO DATABASE Database name:...

The XXY Corporation had 250,000 shares of common stock outstanding at the beginning of the year. XXY issued 80,000 shares of common stock as at July 1. On September 1, the company issued a 30% stock...

Beginning with a differential control volume, derive the diffusion equation, on a molar basis, for species A in a one-dimensional, spherical, stationary medium, considering species generation....

At the conclusion of the accounting period, the amounts for cost of goods sold and ending inventory under LIFO are Blank______. Multiple choice question. are always the same and thus no adjustment to...

atch the compensation objectives with their meanings. Efficiency Efficiency drop zone empty. Fairness Fairness drop zone empty. Compliance Compliance drop zone empty. Improving performance and...