Question: Using SQL, for a table EMPLOYEES with attributes(ID, name, salary, deptName) set a constraint so that people who work in the HR department should earn

Using SQL, for a table EMPLOYEES with attributes(ID, name, salary, deptName) set a constraint so that people who work in the HR department should earn at least 20,000 dollars.

Please respond, I cannot find anything online anywhere which helps with this.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

1. (7 pts) Use Oracle SQL to create a script file that declares table schema based on the following assumptions, and then inserts data records into the tables (a) Different departments have different...

Strategic Plan Introduction The strategic plan is established by analyzing alternative solutions through tools and matrices designed to develop a strategic direction. The stacked EFE/IFE matrix is...

Sample Final Mat 117 Prof. Kazlow All questions are worth 3 points each. You may use a scientific, graphing or statistical calculator. You may not use a cell phone, pda, or computer on this exam....

First visit HYPERLINK "http://www.tdan.com/view-articles/5174/" http://www.tdan.com/view-articles/5174/ and learn what data related business rules are. Business rules are precisely written and...

Hello, below is my Oracle SQL statements for my assignment. When I try to run I get a few errors, "Missing Comma" "Unique Constraint" and so forth. I have also attached a list from the assignment on...

Hello below are my Oracle SQL statements for my assignment (Which I also attached below) If someone could look over it to ensure that it runs properly I would appreciate it. --Drop Table if it...

Hello, below is my Oracle SQL statements for my assignment. When I try to run I get a few errors.. I have also attached a list from the assignment on what the statements should do. If someone could...

Hello, below is my segment of Oracle SQL statements (Highlighted in BOLD). I am trying to create statements that abide by the description in the prompt for the assignment (Which is also included...

1. Your company uses 2 tables to store product information named LocalProducs and InternationalProducts. You also use a table named Orders that stores open order information. You must retrieve the ID...

- 30. Holding all other things constant, a higher price for ski lift tickets would a. increase the number of skiers. b. increase the price of skis. c. decrease the number of skis sold. d. decrease...

What are the challenges and opportunities for managers in using OB concepts?

The companys constitution forms a contract between a company and its members. This contract is, however, an unusual one, limited both in its scope and permanence despite the best efforts of the...

AbnerCorporation's bonds mature in22 years and pay11 percent interest annually. If you purchase the bonds for$1,200, what is your yield tomaturity? Your yield to maturity on the Abner bonds...

Discuss the steps in the development planning process. page 399

Identify the cause of a performance problem. page 380

Distinguish types of rating errors, and explain how to minimize each in a performance evaluation. page 374