Homework Help is Here – Start Your Trial Now!
Engineering
Computer Engineering
1) In this activity, refer to the Construct Company schema studied in activity one of lab 3. a) Load the ConstructCompany Schema.sql script and execute it to create all the tables of the schema. Use this database to answer the following questions. b) Write the SQL code to enter the rows shown in the following Figure inside the table EMP_1. EMP NUM EMP LNAME News Senior EMP FNAME EMP INTIAL EMP HIREDATE JOB CODE 101 102 John 08-Nov-00 502 12-Jul-89 501 01-Dec-96 500 15-Nov-87 501 01-Feb-93 502 22-Jun-04 500 10-Oct-93 500 22-Aug-91 501 David H. 103 Arbough June 104 105 106 107 108 Ramoras Anne Johnson Alice Smithfield William Alonzo Maria Washington Ralph Larry B 109 Smith 18-Jul-97 501 c) Write the SQL code that will list all attributes for a job code of 502.

1) In this activity, refer to the Construct Company schema studied in activity one of lab 3. a) Load the ConstructCompany Schema.sql script and execute it to create all the tables of the schema. Use this database to answer the following questions. b) Write the SQL code to enter the rows shown in the following Figure inside the table EMP_1. EMP NUM EMP LNAME News Senior EMP FNAME EMP INTIAL EMP HIREDATE JOB CODE 101 102 John 08-Nov-00 502 12-Jul-89 501 01-Dec-96 500 15-Nov-87 501 01-Feb-93 502 22-Jun-04 500 10-Oct-93 500 22-Aug-91 501 David H. 103 Arbough June 104 105 106 107 108 Ramoras Anne Johnson Alice Smithfield William Alonzo Maria Washington Ralph Larry B 109 Smith 18-Jul-97 501 c) Write the SQL code that will list all attributes for a job code of 502.

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
a SELECT DISTINCT on the results set. III. Activities 1) In this activity, refer to the Construct Company schema studied in activity one of lab 3. a) Load the ConstructCompany Schema.sql script and execute it to create all the tables of the schema. Use this database to answer the following questions. b) Write the SQL code to enter the rows shown in the following Figure inside the table EMP 1. EMP NUM EMP LNAME EMP FNAME News Senior EMP INTIAL EMP HIREDATE JOB CODE 08-Nov-00 502 12-Jul-89 501 01-Dec-96 500 101 John David G 102 H 103 Arbough June E 104 Ramoras Anne 15-Nov-87 501 Johnson Smithfield Alonzo Washington 105 Alice 01-Feb-93 502 106 William 22-Jun-04 500 10-Oct-93 500 22-Aug-91 501 18-Jul-97 501 c) Write the SQL code that will list all attributes for a job code of 502. 107 108 109 Maria D Ralph Smith Larry d) Write the SQL code that will save the changes made to the EMP_1 table. e) Write the SQL code to change the job code to 501 for the person whose employee number (EMP_NUM) is 107. After you have completed the task, examine the results, and then reset the job code to its original value. f) Write the SQL code to delete the row for the person named William Smithfield, who was hired on June 22, 2004, and whose job code classification is 500 g) Write the SQL code required to list all employees whose last names start with Smith. h) Using the EMPLOYEE, JOB, and PROJECT tables in ConstructCompany Schema, write the SQL code that will produce the result shown in the following Figure. الولايات المتحدة الأمريكية( TOSHIBA F6 F7 FB F9 F10 F11 F12 INS SCROLL LOCK DE 7. V. 8 A 9. BAC SP 0. 11
Transcribed Image Text:a SELECT DISTINCT on the results set. III. Activities 1) In this activity, refer to the Construct Company schema studied in activity one of lab 3. a) Load the ConstructCompany Schema.sql script and execute it to create all the tables of the schema. Use this database to answer the following questions. b) Write the SQL code to enter the rows shown in the following Figure inside the table EMP 1. EMP NUM EMP LNAME EMP FNAME News Senior EMP INTIAL EMP HIREDATE JOB CODE 08-Nov-00 502 12-Jul-89 501 01-Dec-96 500 101 John David G 102 H 103 Arbough June E 104 Ramoras Anne 15-Nov-87 501 Johnson Smithfield Alonzo Washington 105 Alice 01-Feb-93 502 106 William 22-Jun-04 500 10-Oct-93 500 22-Aug-91 501 18-Jul-97 501 c) Write the SQL code that will list all attributes for a job code of 502. 107 108 109 Maria D Ralph Smith Larry d) Write the SQL code that will save the changes made to the EMP_1 table. e) Write the SQL code to change the job code to 501 for the person whose employee number (EMP_NUM) is 107. After you have completed the task, examine the results, and then reset the job code to its original value. f) Write the SQL code to delete the row for the person named William Smithfield, who was hired on June 22, 2004, and whose job code classification is 500 g) Write the SQL code required to list all employees whose last names start with Smith. h) Using the EMPLOYEE, JOB, and PROJECT tables in ConstructCompany Schema, write the SQL code that will produce the result shown in the following Figure. الولايات المتحدة الأمريكية( TOSHIBA F6 F7 FB F9 F10 F11 F12 INS SCROLL LOCK DE 7. V. 8 A 9. BAC SP 0. 11
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