Primary key: Its used to ensure the data in the specific Column is unique.the column value cannot have NULL. eg: STU_PHONE NUMBER REG_NUMBER Foreign key: A foreign key column or group of columns in a relation data table that provide a link between data in two tables. Eg; Student _no in student_course.