Complete the sql querry. Do asp The Ch07_ConstructCo database stores data for a consulting company that tracks all charges to projects. The charges arebased on the hours each employee works on each project. Given the structure and contents of the Ch07_ConstructCo databaseshown in Figure 2.Figure 2. Ch07_ConstructCo databaseRelational DiagramDatabase name: Ch07_ConstructCoASSIGNMENTV ASSIGN NUMASSIGN_DATETable name: EMPLOYEEEMP NUM EMP LNAME EMP FNAME EMP INITIAL EMP HIREDATE JOB_CODE EMP YEARSJOBV JOB.CODEJOB,DESCRIPIONJOB CHG HOURJOB_LAST UPDATE101NewsJohnG08-Nov-00 5028.PROJ NUM102SeniorDavidH12Jul-89 50119EMP NUMASSIGNJOB12103ArboughRamorasJuneE01-Dec-96 503ASSIGN_CHG HRASSIGN_HOURSASSIGN CHARGE15-Nov-87 50101-Feb-93 502104AnneAliceWilliamK21164105JohnsonKEMPLOVEEPROECTV PROLNUMPROJ NAMEPROI VALUEPROI BALANCEEMP NUM106Smithfield22-Jun-04 50010-Oct-93 5009 EMP NUMEMP LNAMEEMP FAMEEMP INTALEMP HOREDATEJOB CODEEMP VEARS107AlonzoMaria1517108109WashingtonSmithRalphB22-Aug-91 50118-Jul-97 501LarryGeraldW11110OlenkoA11-Dec-95 5051317141215171212404-Apr-91 50623-Oct-94 507111WabashGeoffB112SmithsonDarlene113JoenbroodDelbertK15-Nov-96 508Table name: JOBJOB CODE JOB DESCRIPTION JOB CHG HOUR JOB LAST UPDATE500501502114JonesAnnelise11511620-Aug-93 50825-Jan-92 501BawangiTravisBProgrammerSystems AnalystDatabase DesignerElectrical EngineerMechanical EngineerCivil EngineerClerical SupportDSS AnalystApplications DesignerBio TechnicianGeneral Support20-Nov-0920-Nov-0924-Mar-1020-Nov-0920-Nov-0920-Nov-09 Table name: ASSIGNMENT20-Nov-09 ASSIGN_NUM ASSIGN_DATE PROJ NUM EMP NUM ASSIGN JOB ASSIGN_CHG HR ASSIGN HOURS ASSIGN_CHARGE20-Nov-0924-Mar-1020-Nov-0920-Nov-0935.75PrattGerald05-Mar-97 51096.75125.0084.50117WilliamsonAngie19-Jun-96 50904-Jan-05 510118FrommerJamesJ50350467.9050555.7850626.87103295.75145.1169. 10498.5545.951001100222-Mar-10 1850384.503.54250722-Mar-10 2211750934. 5550850951048. 1034.55100322-Mar-10 1811750934.5520100422-Mar-10 1810350384.5096.7596.755.918.36100522-Mar-10 2510850122212.85100622-Mar-10 2210450142406 35Table name: PROJECT192 8576.05541.8082 92451.50328.95193.50270.90515 45493 50100722-Mar-10 2511310311511710550850.753.822-Mar-10 1823-Mar-10 15100850384.500.9PROJ_NUM PROJ_NAME PROJ_VALUE PROJ_BALANCE EMP_NUM1453500.003500500.00805000.002650500.00100950196.755.6244.315Evergreen1002350.00 103101023-Mar-10 1550934. 55105.0096.7518Amber Wave2110346.00 108101123-Mar-10 2523-Mar-10 18502500345 20 1022309880.00 10722Rolling TideStarfight10121085013.425101323-Mar-10 2511550196.7520101423-Mar-10 2210410350196.7528101523-Mar-10 1550384.506.123-Mar-10 2223-Mar-10 1823-Mar-10 2524-Mar-10 251016105502105 004.7101711750950950134.5538131.29101811734.552276.01541.45387.50298.35541.451019104110 504.9102024-Mar-10 15101502501125.003.124-Mar-10 2224-Mar-10 221021110.50110 501082.710221155014.9102324-Mar-10 22105502125.003.5437.50278.85145.11102424-Mar-10 1524-Mar-10 1810350350984.503.342102511734.55Submission 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 andnecessary foreign keys, and inserting at least two records into each table.

Answered: omplete the sql querry. Do asp

Engineering

Computer Engineering

omplete the sql querry. Do asp

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

Related questions

Q: list of clauses in sql. Give examples of very clauses.

A: sql clause facilitates us to retrieve a hard and fast or bundles of information from the table. sql…

Q: eans that: Question 4 options: Not only SQL is us

A: Accessing Data with NoSQL Means that: Question 4 options: Not only SQL is used Only SQL is used No…

Q: How can I calcuate min, max, and average of a dataset in SQL?

A: SQL is a standardised programming language used to extract, organise, manage, and alter data…

Q: How do I view tables in SQL?

A: In the given question SQL stand for structured query language.

Q: Explain the null functions in Oracle Sql

A: Software programs known as database management systems make it easier to create, organize, retrieve,…

Q: How does SQL differ from other programming languages?

A: For the purpose of interacting with and commanding technology that swiftly and effectively completes…

Q: Could you explain SQL in more detail?

A: Explanation:This topic covers how to increase the size of a SQL Server database using Transact-SQL…

Q: Explain the null functions in Oracle Sql

A: Null functions in Oracle SQL are essential for controlling and modifying null values in database…

Q: Explain how to work pl/sql block.

A: Procedural Language/Structured Query Language, or PL/SQL, is a potent SQL extension meant for…

Q: What is the purpose of SQL?

A: SQL (Structured Query Language) is a standard programming language that used to manage relational…

Q: Explain the importance of SQL-92.

A: Importance of SQL-92 User has option to set New SQL-92 instead of original SQL-89 in Access 2010,…

Q: Write single-table queries using SQL commands.

A: Steps to write single query: SELECT col1, col2, ... FROM table_name; SELECT * FROM table_name;

Q: List at least 3 differences between Oracle PL/SQL programming functions and procedures (Differences…

A: Differences between Oracle PL/SQL programming functions and procedures S.N. function…

Q: a- Find the names of persons who own at least one house in at least country that has a border with…

A: The question is to write SQL queries for the given problem. As this is a multipart-type question,…

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.

Expert Solution

This question has been solved!

Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.

SEE SOLUTION Check out a sample Q&A here

Step 1

VIEW

Step 2

VIEW

Step by step

Solved in 2 steps

SEE SOLUTION Check out a sample Q&A here

Similar questions

PL/SQL please use oracle sql developer. I know it would be hard to slove without the data but please help Given a start and end date, print out names, phone number, status, and flight ID of people who were on the same flight with someone whose status is 1 (tested positive) and the flight date is between the start and end date.
Write an SQL query that will show all data from the Customers table andOrder By State.
order db orderid int custid int itemcode int orderquantity int deliverydate date modeofpayment char(1) date_of_order date
How the SQL queries work and what are their types?
What is the use or correlated subquery in oralce sql
How can we insert data in SQL?
Using php and sql: create a query that will output only the user_id and message for user_id 8
Define NULL,BLANK AND zero in sql.
Explain replace and translate functions in Oracle sql
SQL homework Please help me with this homework