(Solved) : Write The Sql Code To Create A Copy Of Emp1 . . .

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)

Expert Answer

Attached

Posted in Uncategorized