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

Give detail discussion about black box testing, Give detail discussion abou...

Give detail discussion about Black box testing. Black box or behavioural testing emphasis on the functional needs of the software. It is used during the last stage of tes

What is oo integration testing, This strategy includes testing the classes ...

This strategy includes testing the classes as they are integrated into the system. The traditional approach would test every operation separately as they are executed into a class.

What are the different rapid prototyping techniques, What are the different...

What are the different Rapid prototyping techniques? i. Dynamic high level language development. ii. Database programming. iii. Component and application assembly.

Define process specification, Define Process Specification. Process Sp...

Define Process Specification. Process Specification is used to explain all flow model processes that appear at the final level of refinement. Check & Convert pressure Ch

Calculate capacity of a cluster for this disc, A multiplattered HDD is for...

A multiplattered HDD is formatted into twenty sectors and 16 hundred cylinders. There are eight platters and 16 R/W heads. The total capacity of the disc is 1GB. A cluster of data

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.

Developing conventional, a) Describe refactoring in XP practices. Why refac...

a) Describe refactoring in XP practices. Why refactoring is important for making high quality software systems using agile approach?   b) Can agile approach being used in dev

What is code coverage and code inspection, What is Code Coverage and Code I...

What is Code Coverage and Code Inspection - This is an analysis method which verifies which parts of the software have already been covered by the test case suite and which are

What are the benefits of modular design, What are the benefits of modular d...

What are the benefits of modular design? Changes made during testing and maintenance becomes manageable and they do not affect other modules.

Explain the reuse maintenance model, Q. Explain the reuse maintenance model...

Q. Explain the reuse maintenance model with the help of a diagram. Ans: Recycle maintenance model this model is based on the principal that maintenance could be viewed as an

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