您在這裡

Foreign key

19 十月, 2015 - 15:52
  • An attribute in one table that references the primary key of another table OR it can be null.
  • Both foreign and primary keys must be of the same data type
  • For example: Employee(EID, First Name, Last Name, SIN, Address, Phone, BirthDate, Salary, DepartmentID) -DepartmentID is the Foreign key.