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

Software Metircs, I have a comprehensive question for Software Metrics ...i...

I have a comprehensive question for Software Metrics ...it is 16 question

Calculates function point value for a project, Q Calculates function point ...

Q Calculates function point value for a project with the following domain characteristics: No. of I/P = 30 No. of O/P = 62 No. of user Inquiries = 24 No. of fil

What are the types of software system requirements, What are the types of S...

What are the types of Software system requirements? Functional requirements: Services the system should give. Non-functional requirements: Constraints on the services.

State the categories of software maintenance, Categories of software mainte...

Categories of software maintenance There are three categories of maintenance:  i) Corrective Maintenance ii) Adaptive Maintenance iii) Perfective Maintenance

Give explanation about the incremental model, Give explanation about the in...

Give explanation about the incremental model. - Have same phases as the waterfall model. - Phases are as follows: Analysis. Code. Design. Test. Incre

Hello, What is Queue management sysyem? literature review of Queue managem...

What is Queue management sysyem? literature review of Queue management system

Determine the levels of capability maturity model, Determine the levels of ...

Determine the levels of Capability Maturity Model(CMM). Capability Maturity Model(CMM) Level 1:Initial - Few processes are explained  and individual efforts are taken. Le

What is error seeding, Define Error seeding? Ans) The process of intenti...

Define Error seeding? Ans) The process of intentionally adding called as faults to those already in a computer program for the purpose of monitoring the rate of recognition and

Script file, how to make script file volume of pyramid

how to make script file volume of pyramid

Determine the advantages of spiral model, Determine the advantages of spira...

Determine the advantages of spiral model In this model Software development starts with lesser requirements specification, lesser risk analysisetc. Radical dimension this model

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