university

Tables (6)

course (Untitled4)

  • s_id (Key) — Foreign key → student.s_id — NOT NULL
  • c_id (Key2) — Foreign key → student.c_id — NOT NULL
  • p_id (Key3) — Foreign key → student.p_id — NOT NULL
  • p_id (Key4) — Foreign key → professor.p_id — NOT NULL
  • p_id (Key22) — Foreign key → professor.p_id — NOT NULL
  • Key2 (Key222) — Foreign key → professor.Key2 — NOT NULL
  • Key3 (Key32) — Foreign key → professor.Key3 — NOT NULL
  • c_name (Field)

employee (Untitled2)

  • e_id (Key2) — Primary key — NOT NULL
  • p_id (Key) — Foreign key → university.p_id — NOT NULL
  • Key2 (Key22) — Foreign key → university.s_id — NOT NULL
  • Key3 — Foreign key → university.e_id — NOT NULL
  • e_name (Field)

major (Untitled6)

  • m_id (Key) — Primary key — NOT NULL
  • m_name (Key2) — Primary key — NOT NULL
  • s_id (Key3) — Foreign key → student.s_id — NOT NULL
  • c_id (Key22) — Foreign key → student.c_id — NOT NULL
  • p_id (Key32) — Foreign key → student.p_id — NOT NULL
  • Key2 (Key222) — Foreign key → student.Key2 — NOT NULL
  • Key3 (Key322) — Foreign key → student.Key3 — NOT NULL
  • s_id (Field)

professor (Untitled)

  • p_id (Key) — Primary key — NOT NULL
  • p_id (Key2) — Foreign key → university.p_id — NOT NULL
  • Key2 (Key22) — Foreign key → university.s_id — NOT NULL
  • Key3 — Foreign key → university.e_id — NOT NULL
  • p_name (Field)

student (Untitled5)

  • s_id (Key) — Primary key — NOT NULL
  • c_id (Key2) — Primary key — NOT NULL
  • p_id (Key3) — Foreign key → university.p_id — NOT NULL
  • Key2 (Key22) — Foreign key → university.s_id — NOT NULL
  • Key3 (Key32) — Foreign key → university.e_id — NOT NULL
  • s_name (Field)

university (Untitled3)

  • p_id (Key) — Primary key — NOT NULL
  • s_id (Key2) — Primary key — NOT NULL
  • e_id (Key3) — Primary key — NOT NULL