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

Important issues related to srs, Q. Important issues related to SRS? (a...

Q. Important issues related to SRS? (a) System goals as well as requirements are different- Goal is a more general characteristics. For example Whole system must be designed in

Advantages and disadvantages of size measure, What are the advantages and d...

What are the advantages and disadvantages of size measure? Advantages: Artifact of software development which is simply counted. Many existing methods use LOC as a key input. A

Explain data accuracy, Data accuracy Don't collect redundant data  T...

Data accuracy Don't collect redundant data  The questions to be answered should be decided in advance and the needed data identified. Tell people why the data is being co

Describe basic steps in software cost estimation, Question: (a) Describ...

Question: (a) Describe fully the first five basic steps in software cost estimation. (b) What are the main differences between COCOMO1 and COCOMO2 cost estimation models?

Explain automated testing, Automated testing is a formally specified and co...

Automated testing is a formally specified and controlled method of formal testing approach. or That part of software testing that is assisted with software tool(s) that does

Different phases of the rational unified process, Problem: (a) Briefly...

Problem: (a) Briefly explain the different phases and workflows of the Rational Unified Process. (b) What are the two benefits that might be gained when using such a life-c

Explain the essential api concepts associated with j2me, Question: (a) ...

Question: (a) State and explain the essential API concepts associated with J2ME. (b) Connected Limited Device Configuration provides two types of application security; stat

State entity and relationship diagram, State Entity /Relationship diagram. ...

State Entity /Relationship diagram. ERD depicts relationships among data objects. The ERD is the notation that is used to conduct the data modeling activity. The primary

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