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

Software engineering, Software Engineering A  high technology system e...

Software Engineering A  high technology system encompasses a  number of  elements like   people, hardware, software, database, documentation, and process.  System engineering

Describe component testing, Describe component testing. - Component tes...

Describe component testing. - Component testing is also called as module, unit or program testing. - It looks for defects in software and verifies its functioning. - It c

What is interface testing, Testing conducted to evaluate whether systems or...

Testing conducted to evaluate whether systems or components pass data and control correctly to one another. Contrast with testing, unit; testing, system. Normal 0

How will you view gui maps in winrunner, How will you view GUI maps in Winr...

How will you view GUI maps in Winrunner? - GUI maps are viewed by using GUI Map Editor - It's located in Tools menu within WinRunner. - It displays all of the GUI Map fil

Explain what is meant by the term encapsulation, Question: (a)  Explain...

Question: (a)  Explain the difference between a link and an association. Use a simple example to illustrate your answer. (b)  Briefly describe the importance of CRC cards in

What are the testing strategies for conventional software, What are the var...

What are the various testing strategies for conventional software? i. Unit testing ii. Integration testing. iii. Validation testing. iv. System testing.

Local data object defined in a subroutine, It is possible to assign a local...

It is possible to assign a local data object defined in a subroutine or function module to a field group. False.

What are the merits of incremental model, What are the merits of incrementa...

What are the merits of incremental model? i. The incremental model can be adopted when there is less number of people included in the project. ii. Technical risks can be man

Flow chart, desidn a complete flow chart diagram ,which ask the user to inp...

desidn a complete flow chart diagram ,which ask the user to input the rate of diesel and quantity of diesel consumed.after calculate the total amount of diesel consumed and display

What is dfd, What is DFD? Data Flow Diagram depicts the information flo...

What is DFD? Data Flow Diagram depicts the information flow and the transforms that are applied on the data as it moves from input to output.

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