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 infeasible path, Explain Infeasible Path? Program statement sequ...

Explain Infeasible Path? Program statement sequence that can never be implemented.

Diffrence between object and function oriented design, Q. Differentiate bet...

Q. Differentiate between object oriented and function oriented design. Ans: • Function-oriented design depend on identifying functions which transform their inputs to create

Draw a flowchart for pay no tax, A town comprise 5000 houses. Every house o...

A town comprise 5000 houses. Every house owner should pay tax based on the value of house. Houses over $200 000 pay 2% of their value in tax, houses over $100 000 pay 1.5% of their

Explain test case, Documentation verifying inputs, predicted results, and a...

Documentation verifying inputs, predicted results, and a set of implementation conditions for a test item. A test case is a document that explains an input, action, or event and

Whta is boundary value analysis, Boundary Value Analysis:    It's widely ex...

Boundary Value Analysis:    It's widely examined that input values at the extreme ends of input domain cause more errors in system. More application errors happen at the boundaries

Cohesion, Cohesion for Each Module? Compute average daily temperatures at v...

Cohesion for Each Module? Compute average daily temperatures at various sites Initialize sums and open files Create new temperature record Store temperature record Close files and

Explain steps in building the structure chart, Q. Explain Steps in Building...

Q. Explain Steps in Building the Structure Chart? Steps in Building the Structure Chart 1. Identify top level modules as well as decompose them into lower levels 2. Add

What does data object means, What does data object means? Data object i...

What does data object means? Data object is a group of attributes that behave as an aspect, quality, characteristic or descriptor of the object.

Name certain common tools which are used for load testing, Name certain com...

Name certain common tools which are used for load testing. - Rational Performance Tester by IBM Rational - Open STA an Open Source tool - LoadRunner by HP - Silk Perfo

Modules, write a main module and three other nodules. The owners of the Sup...

write a main module and three other nodules. The owners of the Super Supermarket would like to have a program that computes the monthly gross pay of their employees as well as the

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