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 what is meant by the term encapsulation, Question: (a)  Explain...

Question: (a)  Explain the difference between a link and an association. Use a simple example to illustrate your answer. (b)  Briefly describe the importance of CRC cards in

What is volume testing, Testing designed to challenge a system's capability...

Testing designed to challenge a system's capability to handle the maximum amount of data over a period of time. This type of testing also classify a system's ability to handle over

Test plan including test cases, This assignment aims to provide the opportu...

This assignment aims to provide the opportunity to integrate and develop your analytical and written communication skills, and speci?cally to:develop your skills at developing test

What is the use of knowledge of risk acceptance to engineers, What is the u...

What is the use of knowledge of risk acceptance to engineers?  The past experience and historical data give better information about safety of products designing there are stil

Srs, why srs is also called black box specificaton

why srs is also called black box specificaton

Different server platforms for erp systems, Question: a. Assume that yo...

Question: a. Assume that you have three similar projects, and, in each, the ratios of problems found during system test versus first year in the field have been 1.5, 1.2, and

Define product metrics, Normal 0 false false false EN-I...

Normal 0 false false false EN-IN X-NONE X-NONE MicrosoftInternetExplorer4

Com 101p, Peripheral devices are irrelevant to the computer

Peripheral devices are irrelevant to the computer

Write the process classification, Write the Process classification. In...

Write the Process classification. Informal No detailed process model. Development team chose their own way of working. Managed Explained process model wh

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