Create a row-level trigger to prevent an insert of a record

Assignment Help Operation Management

Reference no: EM1382396

Given the EMPLOYEE able defined below, create a row-level trigger to prevent an insert of a record for an new employee in the MIS department with a salary > $10,000 and display the message "MIS Employee Salary must not be greater than $10000".

Create table Employee

(emp_no varchar(3),

emp_name varchar (15) CONSTRAINT nn_emp_name not null CONSTRAINT unq_emp_name UNIQUE,

Dep_no varchar (5) CONSTRAINT nn_dep_no not null,

Salary number CONSTRAINT nn_sal not null,

Bonus number,

CONSTRAINT emp_pk PRIMARY KEY (emp_no):

Reference no: EM1382396

Questions Cloud

Determine the proportion of various phenotypes : Estimate the proportion of various phenotypes in matings between individuals that are blood type AB and type O, both of whom are Se/se.

Discuss the social structure stated by durkheim : Critically discuss the social structure stated by Durkheim,Tonnies, and Lenski? How does it which comes closest to matching certain social setting of to day?

Elucidate how much money would randy save using method : Elucidate how much money would Randy save using each selection method. If the number of applicants increases to 200 more applicants are coming in everyday, elucidate how will your answers to questions 1 & 2 change.

Dry unit weight of material : A soil borrow material in its natural state in the ground has a unit weight of 118pcf. Its natural water content is 7%. What is the dry unit weight of this material?

Create a row-level trigger to prevent an insert of a record : Given the EMPLOYEE able defined below, create a row-level trigger to prevent an insert of a record for an new employee in the MIS department with a salary

What is the minimum length of the string : Two unequal point charges q1 and q2 are held in place unconnected from each other. A point charge Q is placed somewhere between them at a point where it remains stationary when free. From this observation, we can conclude that q1 and q2 must eithe..

Describing human services for elderly in us : The focal point is on the Elderly or Disabled population, please respond to the context below in 4-5 paragraphs or more. Please mention citations or resources.

Increase temperature on a non enzyme catalyzed reaction : Discuss the economic/health impact of any one species of harmful water molds. What is the effect of increase temperature on a non enzyme catalyzed reaction?

Illustrate what workers would be classified as direct labour : Illustrate what workers would be classified as direct labour. Illustrate what workers would be classified as indirect labour.

User Account

All Pages