SchoolDB

Tables (4)

CLASS (Class Table)

  • C_id (Class_ID) — int — Primary key — NOT NULL
  • name (Class_name) — varchar(256)
  • Field

ENROLLMENT (Enrollment Table)

    PROFESSOR (Professor Table)

    • P_ID (Professor_ID) — int — Primary key — NOT NULL
    • P_name (Professor_name) — varcahr(256)
    • Field

    STUDENT (Student Table)

    • S_id (Student_ID) — int — Primary key — NOT NULL
    • name (Student_name) — varchar(50)
    • phone (Student_phoneNumber) — varchar(100)
    • dept (Depertment) — varchar(255)