hsu-ERD
Tables (6)
Copy Of Untitled (COURSE)
- Key (course_id) — INT — Primary key — NOT NULL
- Field (title) — VARCHAR(100)
- Field2 (credit) — INT
Copy Of Untitled2 (CLASS)
- Key (class_id) — INT — Primary key — NOT NULL
- Field (year) — INT
- Field (semester) — INT
- Field (division) — VARCHAR(10)
- Field (classroom) — VARCHAR(20)
- Field (enroll) — INT
- Key (prof_id) — INT — Foreign key → Untitled.Key — NOT NULL
- Key (course_id) — INT — Foreign key → Copy Of Untitled.Key — NOT NULL
Untitled (STUDENT)
- Key (stu_id) — INT — Primary key — NOT NULL
- Field (name) — VARCHAR(50)
- Field3 (address) — VARCHAR(50)
- Field4 (year) — INT
- (dept_id) — INT — Foreign key → hi.dept_id — NOT NULL
Untitled (PROFESSOR)
- Key (prof_id) — INT — Primary key — NOT NULL
- Field (name) — VARCHAR(50)
- Field2 (year_emp) — INT
- Field3 (position) — VARCHAR(30)
- Field (resident_id) — CHAR(13)
- (dept_id) — INT — Foreign key → hi.dept_id — NOT NULL
Untitled (TAKES)
- Key (class_id) — INT — Foreign key → Copy Of Untitled2.Key — NOT NULL
- Key (stu_id) — INT — Foreign key → Untitled.Key — NOT NULL
- Field (grade) — CHAR(10)
hi (DEPARTMENT)
- (dept_id) — INT — Primary key — NOT NULL
- Field (dept_name) — VARCHAR(50)
- Field2 (office) — VARCHAR(50)