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

What is stochastic testing, Stochastic testing is the similar as "monkey te...

Stochastic testing is the similar as "monkey testing", but stochastic testing is a lot more technical sounding name for the similar testing process.

Data dictionary , data dictionary of online banking system

data dictionary of online banking system

Use case realization, Develop a domain model for the Case Study. Express yo...

Develop a domain model for the Case Study. Express your model with a class diagram, showing any inheritance and compositional relationships. For each of the two selected most es

Software metrices, 1. Take a look at the code and try to understand the lo...

1. Take a look at the code and try to understand the logic, particularly, the way scrambled words are disambiguated, i.e.., whether they are matched successfully against a correct

Define black box testing, Define Black box testing Black box testing ...

Define Black box testing Black box testing Black-box test design care for the system as a "black-box", so it doesn't explicitly use knowledge of the internal structure. It ta

Enhance the effectiveness of visual support, Question: a) Discuss which...

Question: a) Discuss which communication method/s you would use in the following situations. Justify your answer. i. Congratulating an employee on obtaining a promotion.

Name the design phase of SDLC, Name the design phase of SDLC Generally,...

Name the design phase of SDLC Generally, design is performed in the below two steps: i)  Primary Design Phase: In this phase, system is designed at block level. Blocks are

Draw dfd for the given requirement, A store is in the business of selling p...

A store is in the business of selling paints as well as hardware items. A numeral of reputed companies supplies items to the store. New suppliers are able to also register with the

Question, why are older data models are being replaced by new data models

why are older data models are being replaced by new data models

What is transform mapping, What is Transform mapping? The transform map...

What is Transform mapping? The transform mapping is a set of design steps applied on the DFD in order to map the transformed flow characteristics into exact architectural style

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