Description Instructions These two tables are for Question 1 - 14: Branch branchNo street city postCode B005 B007 B003 B

Business, Finance, Economics, Accounting, Operations Management, Computer Science, Electrical Engineering, Mechanical Engineering, Civil Engineering, Chemical Engineering, Algebra, Precalculus, Statistics and Probabilty, Advanced Math, Physics, Chemistry, Biology, Nursing, Psychology, Certifications, Tests, Prep, and more.
Post Reply
answerhappygod
Site Admin
Posts: 899604
Joined: Mon Aug 02, 2021 8:13 am

Description Instructions These two tables are for Question 1 - 14: Branch branchNo street city postCode B005 B007 B003 B

Post by answerhappygod »

Description Instructions These Two Tables Are For Question 1 14 Branch Branchno Street City Postcode B005 B007 B003 B 1
Description Instructions These Two Tables Are For Question 1 14 Branch Branchno Street City Postcode B005 B007 B003 B 1 (705.47 KiB) Viewed 32 times
Q1. Define a BEFORE trigger "AssistantEarningTooLittle" on Staff
table. If an user tries to add a new assistant whose salary is
below 7500, the trigger should be invoked and print an error
message "Salary too low"
Description Instructions These two tables are for Question 1 - 14: Branch branchNo street city postCode B005 B007 B003 B004 BOO2 22 Deer Rd London SWI 4EH 16 Argyll St Aberdeen AB2 3SU 163 Main St Glasgow G11 9QX 32 Manse Rd Bristol BS99 INZ 56 Clover Dr London NW10 6EU Staff staffNo Name IName position sex DOB salary branch No White Beech Ford SL21 SG37 SG14 SA9 SG5 SL41 John Ann David Mary Susan Julie Manager M Assistant F Supervisor M Assistant F Manager F Assistant F. 1-Oct-45 10-Nov-60 24-Mar-58 19-Feb-70 3-Jun-40 13-Jun-65 30000 B005 12000 B003 18000 B003 9000 B007 24000 B003 9000 B005 Howe Brand Lee
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!
Post Reply