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 software reliability, Define software reliability. Software reli...

Define software reliability. Software reliability is the probability that software will give failure-free operation in a fixed environment for a fixed interval of time. Probabi

State the meaning of data dictionary, What is meant by Data dictionary? ...

What is meant by Data dictionary? The Data dictionary is an organized listing of all data constituents that are related to the system, with precise, accurate definitions so tha

What are the advantages of using testing tools, Q. What are the advantages ...

Q. What are the advantages of using testing tools? Ans: The merits of testing tools are They improve the productivity and quality of software development. Help in

Explain depth of conditional nesting, Depth of conditional nesting Thi...

Depth of conditional nesting This is a measure of the depth of nesting of if-statements in a program. Deeply nested if statements are hard to understand and are potentially er

What do you mean by software engineering, Q. What do you mean by Software E...

Q. What do you mean by Software Engineering? What is the use of Software Engineering? Ans) Software engineering is engineering for software development. A simple program can be

What does validation represent, What does Validation represent? Validat...

What does Validation represent? Validation show the set of activities that make sure that the software that has been built is satisfying the customer requirements.

What is meant by data dictionary, What is meant by Data dictionary? The...

What is meant by Data dictionary? The Data dictionary is a prepared listing of all data elements that are pertinent to the system, with precise, rigorous explanations so that b

Explain the cardinality and optionally, Cardinality & Optionally Card...

Cardinality & Optionally Cardinality represents the relationship between two entities. Consider one to many relationship between two entities -student andclass. Here cardinal

Transform maping., using a dfd and a processing narrative,describe computer...

using a dfd and a processing narrative,describe computer based system that can distinct transform flow characteristics.Define flow boundaries map the dfd into a software architectu

List the principles of a software design, List the principles of a software...

List the principles of a software design. i. The design process should not suffer from "tunnel vision". ii. The design should be traceable to the analysis model. iii. 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