Question 2 Write the SQL query to create the given Employee Table with the given constraints....

 

Transcribed Image Text:

Question 2 Write the SQL query to create the given Employee Table with the given constraints. Seneca Column SCHOOL OF INFORMATION TECHNOLOGY ADMINISTRATION & SECURITY Type Emp_num int Emp_fname varchar 30 Emp Iname varchar 30 Job code varchar 30 Date Hire code Length PK FK ✓ Assume Job_Code refers another table "Job_Dertails" Not Null ✓ ✓ Unique Check > currentdate Question 2 Write the SQL query to create the given Employee Table with the given constraints. Seneca Column SCHOOL OF INFORMATION TECHNOLOGY ADMINISTRATION & SECURITY Type Emp_num int Emp_fname varchar 30 Emp Iname varchar 30 Job code varchar 30 Date Hire code Length PK FK ✓ Assume Job_Code refers another table "Job_Dertails" Not Null ✓ ✓ Unique Check > currentdate

Answer rating: 100% (QA)

Answer SQL query to create Employee Table CREATE TABLE Employee ... View the full answer