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 about the software testing strategies, Explain about the software t...

Explain about the software testing strategies. A method approach to software testing. Verification and Validation. Verification refers to the set of activities tha

What is peer reviews, What is Peer Reviews? Ans) A methodical examinatio...

What is Peer Reviews? Ans) A methodical examination of software work products by the producer's peers to recognize defects and areas where changes are required.

Explain applicability, Applicability: It is another significant characteri...

Applicability: It is another significant characteristic of a model. The model should be judged by its degree of applicability across software products that change in size, structu

Test a system though there is no documentation available, You need to test ...

You need to test a system though there is no documentation available and developers who developed it don't work there anymore. What would you do? - We will perform exploratory

What is a user guide, The "user guide" is the similar as the user manual. T...

The "user guide" is the similar as the user manual. The user guide is a document that shows information essential to employ a system or component to get the desired results. Typica

#title.decision table, You are to create a decision table to help you decid...

You are to create a decision table to help you decide what to do for the day. If it is a weekday and it is not a holiday, then you go to work. However, if it is a weekday and it

Calculates function point value for a project, Q Calculates function point ...

Q Calculates function point value for a project with the following domain characteristics: No. of I/P = 30 No. of O/P = 62 No. of user Inquiries = 24 No. of fil

Explain cocomo model with its applicable equations, Q. Explain COCOMO model...

Q. Explain COCOMO model with its applicable equations. Describe various attributes of cost drivers used in COCOMO model. Ans. COCOMO denotes for constructive cost model -

Draw dfd for the given requirement, A store is in the business of selling p...

A store is in the business of selling paints as well as hardware items. A numeral of reputed companies supplies items to the store. New suppliers are able to also register with 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