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 bottom-up testing, Bottom-up testing is a method of integration tes...

Bottom-up testing is a method of integration testing. A test engineer makes and uses test drivers for components that have not yet been developed, because, with bottom-up testing,

Explain the purpose of checkpoints in winrunner, Explain the purpose of che...

Explain the purpose of checkpoints in Winrunner? Checkpoints help to compare behavior of current application to its previous version. There are total of four types of checkpoin

Define data flow diagram, Define Data Flow Diagram. A Data flow diagram...

Define Data Flow Diagram. A Data flow diagram is a graphical representation that depicts information flow & the transforms that are applied as data move from input to output.

Determine the aspects of prototyping model., Determine the aspects of proto...

Determine the aspects of prototyping model. Figure below portrays prototyping model. Prototype model has the below aspects: (i)  It helps in determining user requirements

Illustrate the relationship between time and cost, Q. Illustrate the relati...

Q. Illustrate the relationship between Time and cost? In software projects, time cannot be freely exchanged against cost. Such a trade off is limited by the nature of the softw

Static testing tools and dynamic testing tools, Static testing tools: 1...

Static testing tools: 1. Static analysers   2. Code inspectors  3. Standard Dynamic testing tools   1. Coverage analyzers (execution verifiers)    2. Output co

Describe about the environmental model, Describe about the Environmental mo...

Describe about the Environmental model It indicates environment in which system exists. Any small or big system is a sub-system of a larger system. For illustration, if softw

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.

Explain abstraction, Abstraction :- Abstraction allows one to concentrate o...

Abstraction :- Abstraction allows one to concentrate on a problem at some level of generalization without regard to irrelevant low level details; use of abstraction also allows one

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

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