Write sql code to make the changes, Software Engineering

Assignment Help:

Assuming that all the tables have been created as given in the relational schema, write SQL code to make the following changes in the structure of the tables:

(i) Make the employee_id the Primary Key of the EMPLOYEES table

(ii) Make the department_id and the manager_id the foreign key of the Employee table assuming that the department_id has been declared as the primary key of the DEPARTMENTS.

(iii) Add a check constraint in the Job_History table so that the end_date will always be greater than the start_date.

(iv) Add a unique constraint in the Employee table so that each employee will have a unique email address.


Related Discussions:- Write sql code to make the changes

Who is a stake holder for a software project, Q. Who is a stake holder for ...

Q. Who is a stake holder for a software project? [Stake holder :- something or somebody with direct interest:  a group or person with a direct interest, investment or involvem

Dfd, explain dfd

explain dfd

What specific languages can be used in srs, What specific languages can be ...

What specific languages can be used in SRS? What are the advantages of using these specific languages of SRS? Ans. Requirement specification necessitates the utilization of s

Explain key process areas of cmm, Key process areas of CMM. 1.  Require...

Key process areas of CMM. 1.  Requirements management which establishes a common relationship among the customer and developer 2.  Software project planning where reasonable

Determine the cyclomatic complexity, Q. Consider the program given below ...

Q. Consider the program given below void main() { int i,j,k; readln (i,j,k); if( (i k) ) { writeln("then part"); if (j writeln ("j

Explain the phased waterfall model, Explain the Phased Waterfall Model ...

Explain the Phased Waterfall Model It is a type of waterfall model where the project is separated into small phases and delivered at intervals by dissimilar teams. Different Te

Difference between verification and validation, Difference between Verifica...

Difference between Verification and Validation Verification is Static whereas Validation is Dynamic. This means in Verification the s/w is inspected by looking into the code go

What do you mean by class, Q. What do you mean by class? A class is a t...

Q. What do you mean by class? A class is a template that specifies the properties of objects. Classes have an interface that consists of the operation a body which implements t

What is test incident report, A document reporting on any event that happen...

A document reporting on any event that happens during testing that needs further investigation.

What is big-bang waterfall model, What is Big-bang waterfall model? Bi...

What is Big-bang waterfall model? Big bang Model of S/w development is based on the big bang theory. A huge quantity of people, money and time are put together, lot of energy

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd