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 kpas level associated with maturity model, Define KPAs level associa...

Define KPAs level associated with maturity model KPAs are defined by SEI and associated with different maturity levels.  These are described below: Level 1 KPAs : There is

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 schedule an

Software engineering, Software Engineering A  high technology system e...

Software Engineering A  high technology system encompasses a  number of  elements like   people, hardware, software, database, documentation, and process.  System engineering

What is evolutionary prototype, Evolutionary Prototype In this, prot...

Evolutionary Prototype In this, prototype is constructed to learn about software problems and their solutions in successive steps. Prototype is initially developed to satisf

What is quality assurance and standards, What is Quality assurance and stan...

What is Quality assurance and standards? Standards are the key to efficient quality management. They may be international, national, and organizational or project standards.

What is security testing, What is security testing? Security testing at...

What is security testing? Security testing attempts to determine that protection mechanism built into a system will protect it from improper penetration.

What is a state transition diagram, What is a state transition diagram? ...

What is a state transition diagram? State transition diagram is mainly a collection of states and events. The events cause the system to change its state. It also shows what ac

Define the equivalence class, Q. Define the Equivalence class? Equivale...

Q. Define the Equivalence class? Equivalence class:-It represents a set of valid or else invalid states for input conditions. An input condition is a specific numeric a set of

What are the principles of testing, What are the principles of testing ...

What are the principles of testing Below are some of the principles of testing:  i)  All tests must be performed according to user requirements.  ii)  Planning of tests m

Explain code inspection, A manual [formal] testing [error detection] method...

A manual [formal] testing [error detection] method where the programmer reads source code, statement by statement, to a group who ask questions determined the program logic, determ

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