What should you apply to the Employee table?

You have a Department table and an Employee table in your database.
You need to ensure that an employee can be assigned to only an existing department.
What should you apply to the Employee table?

You have a Department table and an Employee table in your database.
You need to ensure that an employee can be assigned to only an existing department.
What should you apply to the Employee table?

A.
A primary key

B.
An index

C.
A foreign key

D.
A unique constraint

E.
A data type



Leave a Reply 1

Your email address will not be published. Required fields are marked *