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)