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

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

Question:

 

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.

Expert Answer:

Answer rating: 100% (QA)

Certainly Here s the SQL code to achieve your objectives 1 Copy the HR Employees table into the Sect
View the full answer