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 capability maturity model, Overview You are a Systems Analyst w...

Overview You are a Systems Analyst working for Zeppelin Industries Inc. Many of the software projects your company attempts to deliver are failing or have already failed. The

Name certain common tools which are used for load testing, Name certain com...

Name certain common tools which are used for load testing. - Rational Performance Tester by IBM Rational - Open STA an Open Source tool - LoadRunner by HP - Silk Perfo

What is cmm and cmmi, CMM = 'Capability Maturity Model', now known as the C...

CMM = 'Capability Maturity Model', now known as the CMMI ('Capability Maturity Model Integration'), developed by the SEI. It's a model of five levels of process 'maturity' that ver

Distinguish software faults and software failures, Q  Distinguish software ...

Q  Distinguish software faults and software failures? Ans: In case of a failure a software doesn't do what the users expect, a fault is a programming bug that may or mayn't act

What are the common activities in design process, What are the common activ...

What are the common activities in design process? i. System structuring - The system is subdivided into principle subsystems components and communications among these subsystem

What are the various types of system testing, What are the various types of...

What are the various types of system testing? 1. Recovery testing - is planned to check the system's ability to recover from failures. 2. Security testing - determines t

#use case diagram, #use case diagram for car manufactures by considering bu...

#use case diagram for car manufactures by considering build and price of car as use case#

What is validation represent, What is Validation represent? Validation ...

What is Validation represent? Validation means a set of deeds that ensure that the software that has been built to satisfy the customer requirements.

Disadvantage of software package, Disadvantage of Software package: Th...

Disadvantage of Software package: There are some disadvantages which need to be looked into. They are:  i)  A commercial software package will have a number of built-in

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