Question

Question No. 5 CLO-4 PLO-3 C6 20 Marks Suppose, an application needs to insert new brands into the production.brands table. However, the new brands should be stored in another table called production.brand approvals for approval before inserting into the production.brands table. Create a trigger to do the above task. Hint: To accomplish this, you create a view called production.vw brands for the application to insert new brands. If brands are inserted into the view, an INSTEAD OF trigger will be fired to insert brands into the production.brand approvals table. You can create view using the following example syntax CREATE VIEW Employee Complete AS SELECT FROM Person JOIN Employee ON ID = Person ID

          Question No. 5
CLO-4	PLO-3	C6	20 Marks
Suppose, an application needs to insert new brands into the production.brands table.
However, the new brands should be stored in another table
called production.brand approvals for approval before inserting into
the production.brands table.
Create a trigger to do the above task.
Hint: To accomplish this, you create a view called production.vw brands for the
application to insert new brands. If brands are inserted into the view, an INSTEAD
OF trigger will be fired to insert brands into the production.brand approvals table.
You can create view using the following example syntax
CREATE VIEW Employee Complete AS SELECT FROM Person JOIN Employee ON ID = Person ID

Added by Samantha B.

Question

Please give Ace some feedback