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 productivity and difficulty, Productivity and difficulty Produ...

Productivity and difficulty Productivity refers to metrics and measures of output from production processes, per unit of input. Productivity P may be conceived of as a metric

Illustrate about web-testing, Illustrate about web-testing - Web testin...

Illustrate about web-testing - Web testing is software testing concentrating on web applications. - It assists in addressing issues before making the application live to pub

What are the advantages of horizontal partitioning, What are the advantages...

What are the advantages of horizontal partitioning? i. Software is must be easy to check. ii. Software is handy to maintain. iii. Create fewer side effects. iv. Softwa

Explain the term in brief-test script and test specification, Explain the t...

Explain the term in brief- Test Script and Test Specification: Test Script: - It is generally used to refer to instructions for a particular test which will be carried out

What is test case generator, A software tool that accepts as input source c...

A software tool that accepts as input source code, specifications, test criteria, or data structure definitions; uses these inputs to make test input data; and, sometimes, verifies

Define graph matrix and connection matrix, Q. Define graph matrix and conne...

Q. Define graph matrix and connection matrix. Ans: Graph matrix: A graph matrix is a square matrix whose size that is a number of rows and columns is equal to the number of n

Illustrate about the managed level of maturity model, Level 4 (Managed) ...

Level 4 (Managed) Organisation satisfies all the requirements of level-3. At this level quantitative standards are set for software processes andproducts. Project analysis is

No , Hard drive has space, but it keeps telling me that its full and asks m...

Hard drive has space, but it keeps telling me that its full and asks me to delete files. I checked. There is nearly full C drives (8GB) but when i am open c drive and check than ne

Structured analysis model, Structured Analysis Model Structured  analy...

Structured Analysis Model Structured  analysis is the  most  broadly  used  of  requirements  modeling  techniques  relies  on flow modeling and data modeling to established t

How many types of metrics, What are the types of metrics? Direct metric...

What are the types of metrics? Direct metrics - It refers to immediately measurable attributes. Example -Execution speed, Lines of code. Indirect metrics - It refers to the

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