hi

Tables (6)

class (Untitled5)

  • class_id (Key) — number — Primary key — NOT NULL
  • Field
  • teacher_id (p_key) — number — Foreign key → teacher.teacher_id — NOT NULL
  • room_no (Key2) — number — Foreign key → class_room.room_no — NOT NULL
  • subject_id (Key3) — number — Foreign key → subject.subject_id — NOT NULL

class_room (Untitled4)

  • room_no (Key) — number — Primary key — NOT NULL
  • size (Field) — number
  • location (Field2) — varchar2(10)
  • equipment (Field3) — varchar2(50)
  • broken (Field4) — varchar2(50)

enrollment (Untitled6)

  • enrollment_id (Key) — Primary key — NOT NULL
  • class_id (Key2) — number — Foreign key → class.class_id — NOT NULL
  • student_id (p_key) — number — Foreign key → student.student_id — NOT NULL

student (Untitled)

  • student_id (p_key) — number — Primary key — NOT NULL
  • student_name (Field2) — varchar2(20)
  • student_phone (Field3) — number
  • student_email (Field4) — varchar2(30)
  • class_room_id (Field) — varchar2(50)

subject (Untitled3)

  • subject_id (Key) — number — Primary key — NOT NULL
  • subject_name (Field) — varchar2(50)
  • lesson_time (Field2) — date
  • lesson_period (Field3) — date

teacher (Untitled2)

  • teacher_id (p_key) — number — Primary key — NOT NULL
  • teacher_name (Field) — varchar2(20)
  • teacher_phone (Field2) — number
  • teacher_email (Field3) — varchar2(30)
  • subject_id (Field4) — varchar2(50)