Question: Please write the code for qu C, D in SQL language C- Add constraint on depno in employee table to reference to dep_id in department

Please write the code for qu C, D in SQL language

C- Add constraint on depno in employee table to reference to dep_id in department table (use cascade). D- Add constraint on manager_id in department table to reference to emp_id in employee table (use cascade)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

please write the code for these modifications in SQL language, we have the following SQL statements were we have previously created 3 tables: create table employee ( employee_id number(7),...

we have the following SQL statements that creates 3 tables which we are asked to modify: create table employee ( employee_id number(7), employee_fname varchar2(255) ,employee_lname varchar2(255))...

\fThis is an electronic version of the print textbook. Due to electronic rights restrictions, some third party content may be suppressed. Editorial review has deemed that any suppressed content does...

I need help with my assignment I am supposed to use command prompt and sequel for it There are three tasks in this assignment: A) create tables , B) insert data , and C) c omplete queries. For each...

oracle sql statement help. I will upvote a clear, detailed response. Thank you!! more joins (inner and outer), subqueries and other SQL issues You are suggested to adopt a user friendly prefix string...

First visit HYPERLINK "http://www.tdan.com/view-articles/5174/" http://www.tdan.com/view-articles/5174/ and learn what data related business rules are. Business rules are precisely written and...

Please i need a SQL query if possible 1) Display all employee names (last name and first name separated by a comma and a space) and salary with appropriate column aliases. Also, for yearly salary...

SQL Query Design Module Preview This guide contains a preview of the materials for all module courses in this series: Using a Relational Database Management System Single Table Query Commands...

WRITE SQL QUERIES FOR THE FOLLOWING QUESTIONS WHICH IS BASED ON EMPLOYEES TABLE Below is a sample of searched CASE statement. It finds the average salary of the employees in the Employees table,...

Assignment 4 Data Extraction Assignment 4 is to use SQL queries to obtain appropriate data from databases for betting decision making. In this assignment, you will be asked to write SQL queries to...

Lucy Jordan has been married to Leon Jordan for 25 years. They've been coming to the same office for 25 years to do their taxes. Leon is at work and cannot attend the tax prep appointment. Lucy has...

1. What goal is Gracies dad trying to set for her? Does she appear to accept the goal? 2. This chapter described ability and goal commitment as moderators of the relationship between goals and...

Question 1 For consideration to exist, there must be: a bargained - for exchange substantially equal economic benefit to both pa

The first scenario will be a Verbal Judo scenario in which your scenario follows the standard Verbal Judo interaction: You need to ask somebody to modify their behavior either to do something or to...

Evaluate a selection of HR models and appreciate their inherent contradictions.

Identify the roles and purpose of human resources in todays environment.

10-15 Evaluate Zagat using the competitive forces and value chain models. Founded by Tim and Nina Zagat, the Zagat Survey has collected and published ratings of restaurants by diners since 1979....