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 the modularity concept mean, What does Modularity concept mean? ...

What does Modularity concept mean? Software architecture embodies modularity; i.e. Software is named in to addressable components called modules, which are integrated finally.

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

What is rad approach, What is RAD Approach As the term suggests, this ...

What is RAD Approach As the term suggests, this model gives a quick approach for software development and is based on a linear sequential flow of numerous development processe

Explain basic information flow model, Q. Explain basic information flow mod...

Q. Explain basic information flow model & it's more sophisticated versions? Ans. A Information flow metrics are useful to the components of a system design. For any compone

Data dictionary , data dictionary of online banking system

data dictionary of online banking system

Some important steps while doing testing, Some Important Steps while doing ...

Some Important Steps while doing performing testing The below objectives are to be kept in mind when performing testing: i)  It should be done with the intention of finding

State procedural abstraction, State Procedural abstraction. A Procedur...

State Procedural abstraction. A Procedural abstraction is a named sequence of instructions that has a specific and limited function. Eg: Open Walk to the door, reach out &

Preventive and protective strategies in Cyber Secur, After users are authe...

After users are authenticated, what measures can be employed in order to maintain security when users are away from their computers? 2. Discuss ways in which the use of strong au

Explain the concept of bottom-up design, Q. Explain the concept of bottom-u...

Q. Explain the concept of bottom-up design? Bottom up design: This approach make possible a style of design where we decide how to combine these modules to provide larger ones

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