ss
Tables (5)
Course
- course_id — VARCHAR(255) — Primary key — NOT NULL
- prof_id — VARCHAR(255) — NOT NULL
- course_name — VARCHAR(255)
- start_date — VARCHAR(255)
- end_date — VARCHAR(255)
Department
- dept_id — int — Primary key — NOT NULL
- dept_name — varchar(255)
Professor
- prof_id — VARCHAR(255) — Primary key — NOT NULL
- prof_name — VARCHAR(255)
- dept_id — int — Foreign key → Department.dept_id — NOT NULL
Std_Course
- std_id — int — Foreign key → Student.std_id — NOT NULL
- course_id — VARCHAR(255) — Foreign key → Course.course_id — NOT NULL
Student
- std_id — int — Primary key — NOT NULL
- dept_id — int — NOT NULL
- std_name — varchar(100)
- height — int