Question: Problem 8 Using the EMP_2 table, write the SQL code that will add the attributes EMP_PCT and PROJ_NUM to EMP_2. The EMP_PCT is the bonus

Problem 8

Using the EMP_2 table, write the SQL code that will add the attributes EMP_PCT and PROJ_NUM to EMP_2. The EMP_PCT is the bonus percentage to be paid to each employee. The new attribute characteristics are:

EMP_PCT NUMBER(4,2) PROJ_NUM CHAR(3)

Note: If your SQL implementation requires it, you may use DECIMAL(4,2) or NUMERIC(4,2) rather than NUMBER(4,2).

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 Databases Questions!

1. Write the SQL code that will create only the table structure for a table named EMP_1. This table will be a subset of the EMPLOYEE table. The basic EMP_1 table structure is summarized in the...

(10) Using the EMP_2 table, write a single SQL command to change the EMP_PCT values to 5.00 for the people with employee numbers 101, 105, and 107. 11. Using the EMP_2 table, write a single SQL...

This is as clear as the pictures can be. I HAVE COPY & PASTED THE QUESTIONS. Please help with as many as you can and correct answers please! The Ch08_ConstructCo database stores data for a consulting...

These pictures are as clear as can be. Please answer correctly! The Ch08_ConstructCo database stores data for a consulting company that tracks all charges to projects. The charges are based on the...

P 1 . Write the SQL code that will create only the table structure for a table named EMP _ 1 . This table P 7 . Using the EMP _ 2 table, write the SQL code that will add the attributes EMP _ PCT and...

Hands on Exercises The questions below are based on the database that you have created in tutorial 6 (employee.sql). (a) Undate FMP PCT accordino to the fioure helow: (b) Using a single command...

Create and submit a sql script to answer all the questions. Make sure to add comments in the document to add title for each question. Use Chapter 8 database script to create your database that you...

4. The 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...

The 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 contents...

Task 1 ( 1 0 pts ) : Executing all SQL scripts in " hw 4 db . sql " to create four tables and have the corresponding data inserted. What to submit: - Four screenshots of executing the following SQL...

After studying and extracting information from all the relevant work done previously, how does the researcher know which references, articles, and information should be given prominence in the...

Air is expanded from 2000 kPa and 500C to 100 kPa and 50C. Assuming constant specific heats, determine the change in the specific entropy of air.

Question 5 - Investment risk is the uncertainty that the investment yield will deviate from what is expected.True False

i need correct answrrs 5 2 .

Holding national saving constant, does an increase in net capital outflow increase, decrease, or have no effect on a countrys accumulation of domestic capital?

An article in USA Today (December 16, 2004) began President Bush said Wednesday that the White House will shore up the sliding dollar by working to cut record budget and trade deficits. a. According...

International trade in each of the following products has increased over time. Suggest some reasons this might be so. a. wheat b. banking services c. computer software d. automobiles