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 the alpha testing and beta testing, Alpha testing and Beta testing ...

Alpha testing and Beta testing Alpha testing is conducting acceptance testing in the environment where the application was formed. It is done by the customer. Beta testing is c

Draw a use case diagram, QUESTION (a) Draw a use case diagram (UCD) for...

QUESTION (a) Draw a use case diagram (UCD) for the given case study. For any one use case give a detail use case specification (b) Describe the different phases and workflow

Mca, encoded micro instruction vs unecoded micro instruction

encoded micro instruction vs unecoded micro instruction

Perform risk analysis during software testing, Describe how to perform Risk...

Describe how to perform Risk Analysis during software testing. While a test plan is being formed, risks involved in testing the product are to be taken into consideration with

What is quality, What is quality? Quality, simplistically, means that a...

What is quality? Quality, simplistically, means that a product should meet its requirement. This is problematical for software systems. There is a tension among custom

How will you view gui maps in winrunner, How will you view GUI maps in Winr...

How will you view GUI maps in Winrunner? - GUI maps are viewed by using GUI Map Editor - It's located in Tools menu within WinRunner. - It displays all of the GUI Map fil

Software for searching online retrieval systems, Software for Searching Onl...

Software for Searching Online Retrieval Systems : Each of the major online systems has its own software which supports its activities oil a host computer. Many of these hosts h

How does a countermeasure affect a project plan, Question: a) Failures ...

Question: a) Failures in software development would include excessive cost and/or schedule delays to never fielding a system. Briefly explain the risks associated with develop

Defining a prototype on the overall cost, Describe the effect of defining a...

Describe the effect of defining a prototype on the overall cost of the software project? The prototyping model: In this model, a prototype (an previous approximation of a fin

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