Tutorbook

Tables (6)

Bus (Untitled4)

  • Key — Primary key — NOT NULL
  • Field — VARCHAR(100)

Class (Untitled3)

  • Key (Student_ID) — INT — Foreign key → Student.Key — NOT NULL
  • Key (Tutor_ID) — INT — Foreign key → Tutor.Key — NOT NULL
  • Key (Classroom_ID) — INT — Foreign key → Classroom.Key — NOT NULL
  • Field (SUBJECT) — VARCHAR(10)
  • Field (TIME_START) — TIME
  • Field (TIME_FINISH) — TIME

Classroom (Untitled5)

  • Key (ID) — INT — Primary key — NOT NULL
  • Field (LOCATION) — VARCHAR(100)
  • Field (Rooms) — INT

Schedule (Untitled6)

  • Key (TIME) — TIME — Primary key — NOT NULL
  • Key (Classroom_ID) — INT — Foreign key → Classroom.Key — NOT NULL
  • Field (Tutor_ID) — INT

Student (Untitled2)

  • Key (ID) — INT — Primary key — NOT NULL
  • Field (NAME) — VARCHAR(10)
  • Field (SUBJECT) — VARCHAR(10)
  • Field (PAY) — INT

Tutor (Untitled)

  • Key (ID) — INT — Primary key — NOT NULL
  • Field (NAME) — VARCHAR(10)
  • Field2 (SUBJECT) — VARCHAR(10)
  • Field3 (LOCATION) — VARCHAR(100)