Question: Write the SQL code to create a copy of EMP_1, naming the copy EMP_2. Then write the SQL code that will add the attributes EMP_PCT

Write the SQL code to create a copy of EMP_1, naming the copy EMP_2. Then write the SQL code that will add the attributes EMP_PCT and PROJ_NUM to its structure. The EMP_PCT is the bonus percentage to be paid to each employee. The new attribute characteristics are:
EMP_PCTNUMBER (4,2)
PROJ_NUMCHAR (3)

Step by Step Solution

★★★★★

3.55 Rating (166 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

There are two way to get this job done The two poss... View full answer

Question Has Been Solved by an Expert!

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

Step: 2 Unlock

Step: 3 Unlock

Document Format (1 attachment)

358-CS-DB (671).docx

120 KBs Word File

Students Have Also Explored These Related Databases Questions!

Write the SQL code to create the table structures for the entities shown in Figure P7.65. The structures should contain the attributes specified in the ERD. Use data types that would be appropriate...

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

Write the SQL code to change the EMP_PCT value to 3.85 for the person whose employee number (EMP_NUM) is 103. Next, write the SQL command sequences to change the EMP_PCT values as shown in...

We will use a simple database composed of the following tables: CUSTOMER, INVOICE, LINE, PRODUCT, and VENDOR. This database model is shown in Figure 1. The database model in Figure 1 reflects 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...

Question 1: BookList (30 marks) While writing your answer to question 1 make use of BookMain to test your solutions to the various parts of the question. This class won't be marked. You will also use...

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

Problem 2 Having created the table structure in Problem 1 , write the SQL code to enter the first two rows for the table shown in Figure P8.2 . Each row should be inserted individually, without using...

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

What types of television commercials can an advertiser choose among when considering a media buy?

If grinding machines are placed among other machine tools,what precautions must be taken?

1 3 . 6 8 ) Which of the following is true regarding the 1 2 3 1 look - back rule? A ) It only applies when a 1 2 3 1 loss occurs. B ) It only applies when a 1 2 3 1 gain occurs. C ) It only applies...

What is the role of insurance in managing the risks that a firm faces?

What Oracle function should you use to calculate the number of days between your birthday and the current date?

In a construction company, a new system has been in place for a few months and now there is a list of possible changes/updates that need to be done. For each of the changes/updates, specify what type...

En respuesta a una solicitud de una oficina nacional, la gerente de un banco local afirm que el tiempo de servicio promedio en su banco para un cliente es de 9 segundos. Un estudiante que trabaja en...

SCENARIO 4-5 Below are the 2004 and 2005 year-end balance sheets for Kewell Boomerangs: 2005 2004 Cash $ 100,000 $ 85,000 Accounts receivable 432,000 350,000 Inventories 1,000,000 700,000 Total...

Write a program in java or python that decrypts an message using cesar cipher without keys, only using dictionary read from a file containing large english words.