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 big-bang testing, Big-Bang Testing : In this all the modules after ...

Big-Bang Testing : In this all the modules after unit testing are joint and tested in one go. The problem with this type of testing is debugging of errors.

#, Write the algorithm to print at list of numbers from 1 to 5 and there s...

Write the algorithm to print at list of numbers from 1 to 5 and there square

Artificial intellegence, can yo do a project on Artificial Intelligence.The...

can yo do a project on Artificial Intelligence.The topic is L-system of flowers

Explain the iterative model, Explain the Iterative Model Every release ...

Explain the Iterative Model Every release of Iterative Model is developed in a specific, fixed time period known as iteration. Each iteration focuses on a certain set of requir

Expert Systems, Explain model-based expert systems and frame-based expert s...

Explain model-based expert systems and frame-based expert systems

Explain validation, Validation (Product Oriented) Validation is worried...

Validation (Product Oriented) Validation is worried with whether the right functions of the program have been properly executed, and that this function will properly make the c

Define query language, Define query language? A query is a statement re...

Define query language? A query is a statement requesting the retrieval of information. The portion of DML that includes information retrieval is known as a query language.

Testing, What is software testing?

What is software testing?

Define data dictionary, Define Data Dictionary. The data dictionary can...

Define Data Dictionary. The data dictionary can be explained as an organized collection of all the data elements of the system with precise and rigorous explanations so that us

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