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

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

Post-production design feedback for future designs, Q. Post-production desi...

Q. Post-production design feedback for future designs ? Post-production design feedback for future designs Implementation it is introducing the designed solution into

Explain rad model, RAD Model Rapid Application Development Model is...

RAD Model Rapid Application Development Model is the part of incremental model. Achieves the high speed development using component based construction. Phases

Illustrate the symbols of a data flow diagram, Symbols of a data flow diagr...

Symbols of a data flow diagram  1. Data Flow Signifies the connectivity between various processes 2. Process   Performs some processing of input data 3. Ex

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

State the level 3 of kpas, State the level 3 of KPAs Level 3 KPAs: ...

State the level 3 of KPAs Level 3 KPAs: 1)   Organisation Process Focus (OPF): Organisations responsibility is fixed for software process activities which improve the ul

Database mapping, database mapping from class to database

database mapping from class to database

Explain storage testing, This is a explanation of whether or not certain pr...

This is a explanation of whether or not certain processing conditions use many storage [memory] than estimated.

Define evolutionary prototyping, Q. Define Evolutionary prototyping? Ev...

Q. Define Evolutionary prototyping? Evolutionary Prototyping is also known as breadboard prototyping is quite different from Throwaway Prototyping. The major goal when using Ev

List the process maturity levels in seis cmm, List the process maturity lev...

List the process maturity levels in SEIs CMM. Level 1: Initial - Few processes are explained and individual efforts are taken. Level 2: Repeatable - To track cost schedul

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