title: Naming PK and FK
body: <p>I have login form for my student app, since that I create tbl_user (for login) , tbl_teacher (for biodata) and tbl_student (for biodata). tbl_user have columns (username (PK), password, role, status). tbl_teacher have columns (bio_teacher_id (PK), teacher_id (FK), name, address, etc). tbl_student have columns (bio_student_id (PK), student_number (FK), name, address, etc). Explanation :
  To login, teacher use "teacher_id" as username, student use "student_number" as username.
  My question : Can anyone suggest me ebook/ journal/ supporting document that explain we can use different naming for FK from the PK of parent table ?
  Thanks a lot</p>