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