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

 

Transcribed Image Text:

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. 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.

Answer rating: 100% (QA)

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