Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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 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
Step: 1
Certainly Heres the SQL code to achieve your objectives 1 Copy the HREmployees table into the Sectio...Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started