Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Q 1 . Given the database described by the following tables: STORE ( STNO , Address, Surface ) PRODUCT ( PNO , DesProd, color, Weight,
Q Given the database described by the following tables:
STORE STNO Address, Surface
PRODUCT PNO DesProd, color, Weight, QtyStk QtyMin, 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 Empno Ename, 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
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started