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

Explain data accuracy, Data accuracy Don't collect redundant data  T...

Data accuracy Don't collect redundant data  The questions to be answered should be decided in advance and the needed data identified. Tell people why the data is being co

Software Metircs, I have a comprehensive question for Software Metrics ...i...

I have a comprehensive question for Software Metrics ...it is 16 question

Outsourcing software, discuss how your organization can take advantage of o...

discuss how your organization can take advantage of outsourcing its IT systems/functions

Define coupling and discuss various types of coupling, Define coupling and ...

Define coupling and Discuss various types of coupling? Define coupling. Discuss various types of coupling. Ans: A Coupling is the measure of the degree of interdepende

Define debugging, Define debugging. Debugging is defined as the process...

Define debugging. Debugging is defined as the process of removal of defect. It occurs as a consequence of successful testing.

Operation of the clue-less system, A player with an active turn must make a...

A player with an active turn must make a valid move with their character or pass their turn. As a first move in the game, the player can move to the hallway that is adjacent to the

What is continuous cmmi model, What is continuous CMMI MODEL? This is a...

What is continuous CMMI MODEL? This is a finer-grain model that considers individual or groups of practices and assesses their use. The maturity assessment is not a one valu

Explain respiratory quotient, Explain Respiratory quotient? Ans) Respira...

Explain Respiratory quotient? Ans) Respiratory quotient is the ratio among the carbon-dioxide used in photosynthesis to the quantity of oxygen liberated in respiration.

State the term- code coverage, State the term- Code Coverage This is a...

State the term- Code Coverage This is an analysis method that determines which parts of software have already been covered by test case suite and which are remaining.

Define about the erroneous data - Test data, Define about the erroneous dat...

Define about the erroneous data - Test data Abnormal/erroneous data  -  This is data outside the limits of validity/acceptability and must cause an error message to be g

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