Question: Create a copy of HR.. Employees table inside Section 24 database using Select Into statement. Modify the table to add the following constraints --

Create a copy of HR.. Employees table inside Section 24 database using "Select Into" statement. Modify the 

Create a copy of HR.. Employees table inside Section 24 database using "Select Into" statement. Modify the table to add the following constraints -- - A) Primary Key Constraint on Employee Id -- B) Unique Constraints on eMail Address -- C) A computed column to show Years of Service Q2) Copy Departments table from HR database using "Select Into" statement. Link Employees with Departments using a foreign key relationship. Which table will have the primary key and which will carry the foreign key. Write an Alter Table statement to add the foreign key constraint.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

Certainly Heres the SQL code to achieve your objectives 1 Copy the HREmployees table into the Sectio... View full answer

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!