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)