study_attend_erd

Tables (4)

ATTENDANCE

  • ATD_ID_PK — VARCHAR(20) — Primary key
  • DEPT_ID_FK — VARCHAR(20) — Foreign key → DEPARTMENT.DEPT_ID_PK
  • ATD_TYPE_FK — VARCHAR(20) — Foreign key → ATTENDTYPE.ATD_TYPE_PK
  • EMP_ID_FK — VARCHAR(20) — Foreign key → EMPLOYEE.EMP_ID
  • DATE — VARCHAR(20)

ATTENDTYPE

  • ATD_TYPE_PK — VARCHAR(20) — Primary key
  • ATD_TYPE — VARCHAR(20)

DEPARTMENT

  • DEPT_ID_PK — VARCHAR(20) — Primary key
  • DEPT_NAME — VARCHAR(50)

EMPLOYEE

  • EMP_ID — VARCHAR(20) — Primary key
  • DEPT_ID_FK — VARCHAR(20) — Foreign key → DEPARTMENT.DEPT_ID_PK
  • EMP_NAME — VARCHAR(50)