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

Constructor, what is constructor overloading

what is constructor overloading

What are the various elements of data design, What are the various elements...

What are the various elements of data design? i. Data object - The data objects are identified and relationship between various data objects can be shown using ERD or data di

What is prototyping approaches in software process, What is prototyping app...

What is prototyping approaches in software process? i. Evolutionary prototyping - In this approach of system development, the initial prototype is prepared and it is then refin

Determine the steps of structured requirements definition, Determine the di...

Determine the different steps of Structured Requirements Definition Step 1: Make a user level data flow diagram. This step is meant for gathering requirements with intera

What is the work product of software design process, What is the work produ...

What is the work product of software design process and who does this? A design model that encompasses architectural, interface, component level and their representations is th

What is relationship, What is Relationship Entities are associated t...

What is Relationship Entities are associated to each other by relationships. It denotes how two entities are associated. A diamond notation with name of relationship signifi

What are the tools mainly used for information gathering, What are the tool...

What are the tools are mainly used for information gathering 1.  Record review: A review of recorded documents of organisation is performed.Manuals procedures, forms and book

Structural partitioning, compare and contrast the advantages of verticle an...

compare and contrast the advantages of verticle and horizontal structural partitioning?

What is the test case, Test Case A test case is a unit level document d...

Test Case A test case is a unit level document describing the inputs, steps of implementation and the expected result of each test condition for each requirement from the BRD.

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