test
Tables (5)
Untitled (Student)
- Key (std_id) — int — Primary key — NOT NULL
- Key (dept_id) — int — Foreign key → Untitled4.Key — NOT NULL
- Field (std_name) — varchar(100)
- Field2 (height) — int
Untitled (Professor)
- Key (prof_id) — Primary key — NOT NULL
- Key (dept_id) — int — Foreign key → Untitled4.Key — NOT NULL
- Field (prof_name)
Untitled2 (Course)
- Key (course_id) — Primary key — NOT NULL
- Key (prof_id) — Foreign key → Untitled.Key — NOT NULL
- Field (course_name)
- Field3 (start_date)
- Field4 (end_date)
Untitled3 (Std_Course)
- Key (std_id) — int — Foreign key → Untitled.Key — NOT NULL
- Key (course_id) — Foreign key → Untitled2.Key — NOT NULL
Untitled4 (Department)
- Key (dept_id) — int — Primary key — NOT NULL
- Field (dept_name) — varchar(255)