You are a database developer of a Microsoft SQL Server database.
The database contains a table named Instructor that has the following definition:
You are designing a new table named Course that has the following definition:
You need to ensure that the InstructorId column in the Course table contains only values that exist in the InstructorID column of the Instructor table.
Which Transact-SQL statement should you use?
A.
B.
C.
D.
E.