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

Define about the integration testing, Define about the Integration testing ...

Define about the Integration testing - This test is performed to verify interfaces between system components, interactions between application and file system, hardware and ot

Draw E-R diagram for the given situation, Draw E-R diagram for the followin...

Draw E-R diagram for the following situation An account is a relationship between customer and bank. A customer has a name. A bank has a branch. A customer may have numerous ac

Ethical issue moduel, i want to select topic to my ethical issues assignmen...

i want to select topic to my ethical issues assignment can u propose reasonable topic?

What is requirement elicitation methods, Q. What is requirement elicitation...

Q. What is requirement elicitation methods? Subsequent to receiving the problem statement from the customer the first step is to arrange a meeting with the customer. During the

What is the purpose of timeline chart, What is the purpose of timeline char...

What is the purpose of timeline chart? The purpose of the timeline chart is to emphasize the scope of the individual task. As set of tasks are given as input to the timeline ch

What is software risk, A measure of the severity and probability of undesir...

A measure of the severity and probability of undesired effects. Often taken as the easy product of probability and consequence.

Explain the length of identifiers, Explain the Length of identifiers L...

Explain the Length of identifiers Length of identifiers :-  This is a measure of the average length of separate identifiers in a program. The longer the identifiers, the more

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

List the pre-requisites for white-box testing, List the pre-requisites for ...

List the pre-requisites for white-box testing The pre-requisites for white-box testing are same to that of black-box testing with one main difference: - During white-box tes

Define test methodology and test scenario, Define Test Methodology and  Te...

Define Test Methodology and  Test Scenario Testing methodology verifies how an application will be tested and what will be tested. Example of methodologies: waterfall, agile

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