Question: create primary key constraints for eID and dID on Employee and Departmetn table -create constraint that ensures salary is not less than 2500 -add constraints

create primary key constraints for eID and dID on Employee and Departmetn table

-create constraint that ensures salary is not less than 2500

-add constraints to table Employee to ensure that attribute dID refers to attribute Departmnt.dID

-add constraints to table Deparment to ensure that attribute chairID refers to attribute Employee.eID

add the above integrity constrains to table schema:

Employe( eID, ename, salary, mangerID, dID)

Departnemtn ( dID, dname, address, chairID)

Step by Step Solution

★★★★★

3.40 Rating (147 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

To create the primary key constraints ensure the minimum salary constraint and foreig... View full answer

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!

Q:

Do some amendment and enhance the given research paper: Table of Content Abstract..3 Action Research.4 Research Methodology and Design...5 Literature Review: NoSQL Database7 Proposal.7 Iteration 1..8...

Q:

For the conceptual schemata of the database, establish an environment for the execution of simple and advanced queries in Oracle. The global schemata is as below EMP (ENUM, NAME, SAL, TAX, MGR, DNUM)...

Q:

For your survey project, develop an introductory statement (ethics statement) that you would include on a letter of introduction or as part of a survey questionnaire. There should be a minimum of...

Q:

Tables_bookstore_database: USE bookstore; /* drop the tables */ DROP TABLE IF EXISTS orderitems; DROP TABLE IF EXISTS orders; DROP TABLE IF EXISTS address; DROP TABLE IF EXISTS customer; DROP TABLE...

Q:

SESSION: SUMMER 2017 LAB 1B SQL * Plus - CREATING TABLES and CONSTRAINTS Successful people did not attain their success without first overcoming challenges.------- Catherine Pulsifer FOLLOW...

Q:

SESSION: SUMMER 2017 LAB 1B SQL * Plus - CREATING TABLES and CONSTRAINTS FOLLOW INSTRUCTIONS: DO NOT SKIP A SINGLE STEP SECTION I: NOTE: Do not specify any constraints with the create statement...

Q:

Create a new database and execute the code below in SQL Server's query window to create the database tables, CREATE TABLE Physician Specialties (Specialty.In integer, SpesialtyName varchar(5e),...

Q:

a. Lab 4 Creating Constraints Save screen captures of all SQL statements used to accomplish the following tasks. Save your screen captures in a word document or PDF which must be named in the format...

Q:

I have the following instructions: Table # 1 Name: Employee Columns and Data Types: empNumber (char(8)), firstName (varchar(25)), lastName varchar(25)), ssn (char(9)), address (varchar(50)), state...

Q:

Tables_bookstore_database: USE bookstore; /* drop the tables */ DROP TABLE IF EXISTS orderitems; DROP TABLE IF EXISTS orders; DROP TABLE IF EXISTS address; DROP TABLE IF EXISTS customer; DROP TABLE...

Q:

At 6 percent interest, how long would it take to quadruple (i.e.to increase fourfold) your money? You can assume any amount ofinitial investment. Group of answer choices 20.01 years 26.55 years 16.64...

Q:

Ben Williams Company reported these ratios at December 31, 2010 (dollar amounts in millions): Ben Williams Company completed these transactions during 2011: a. Purchased equipment on account, $8 b....

Q:

Do you think that the new tax act helped or further complicated the tax code? Have we become more competitive with other countries? Why is international tax so important to the U . S . tax code?

Q:

What are the different systems for fixing the exchange rate? Describe how each works.

Q:

Let Show that MODEXP P. (Note that the most obvious algorithm doesnt run in polynomial time. Try it first where b is a power of 2. MODEXP = {(a, b, c, p)| a, b, c, and p are positive binary integers...

Q:

Digital versatile disc (DVD) players incorporate several control systems for their operations. The control tasks include (1) keeping the laser beam focused on the disc surface, (2) fast track...

Q:

How much force is needed to support a 100-kg iron anchor when it is submerged in seawater? (First find the anchors volume.)

Q:

Use Kirchhoffs voltage and current laws to determine the voltage drop and current in each of the following three resistors if R 1 = 10. ohms, R 2 = 20. ohms, and R 3 = 30. ohms. + R2 R3 + R1 6.0 V +

Q:

What is the implication of an audit report being considered meaningless for audits of publicly traded companies? For the auditing profession in general?

Q:

In the following exercises, you will use the data in the Solmaris Condominium Group database shown in Figures 1-21 through 1-25. (If you use a computer to complete these exercises, use a copy of the...

Q:

What does it mean when a data warehouse is nonvolatile?

Q:

Describe the purpose of the UNION command in relational algebra.

Q:

Use your own computers regression software and the weight (Y) and height (X) data from Table 1.1 to see if you can reproduce the estimates in Equation 1.19. There are two ways to load the data: You...

Q:

Not all regression coefficients have positive expected signs. For example, a Sports Illustrated article by Jaime Diaz reported on a study of golfing putts of various lengths on the Professional...

Q:

Lets return to the height-weight example on page 53 and recall what happened when we added a nonsensical variable that measured the students campus post office box number (MAIL) to the equation. The...