Question: Q 1 . Given the database described by the following tables: STORE ( STNO , Address, Surface ) PRODUCT ( PNO , DesStod, color, Weight,
Q Given the database described by the following tables:
STORE STNO Address, Surface
PRODUCT PNO DesStod, color, Weight, Qtv Stk QtvacoMin, Price, STNO#
Write a PLSQL block that uses an implicit cursor to check that Store exists and then inserts the new product 'TABLE', 'WHITE',
Q Given the following table
EMP EmpnoEname, SAL, Comm, Deptno#
Develop a trigger that records any change of salaries done during the working days assumed as days and into the table:
AUDITEMPSALUname ActionDate, OldSal. NewSal. DayNo
Please I want clear answer for each question one clear code for each
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
