Ü2

Tables (3)

Dozent (Untitled)

  • DozentID — INT — Primary key — NOT NULL
  • Vorlesung (Field) — NOT NULL

Raum (Untitled3)

  • RaumNummer — Primary key — NOT NULL
  • Anzahl von Studenten — INT — NOT NULL
  • DozentID (DozentID2) — INT — Foreign key → Vorlesung.DozentID — NOT NULL

Vorlesung (Untitled2)

  • DozentID (DozentID2) — INT — Foreign key → Dozent.DozentID — NOT NULL
  • Name — NOT NULL
  • Ort