education
Tables (12)
BOOK_LOAN
- loan_id — CHAR(8)
- student_id — CHAR(8) — NOT NULL
- lib_id — CHAR(5) — NOT NULL
- book_name — VARCHAR(100) — NOT NULL
- loan_date — DATE — NOT NULL
- return_date — DATE
BUILDING
- building_id — CHAR(5)
- name — VARCHAR(50) — NOT NULL
- floors — INT
- type — VARCHAR(20)
CLASSROOM
- room_id — CHAR(6)
- building_id — CHAR(5) — NOT NULL
- capacity — INT
COLLEGE
- college_id — CHAR(5)
- name — VARCHAR(50) — NOT NULL
- dean — VARCHAR(30)
DEPARTMENT
- dept_id — CHAR(5)
- name — VARCHAR(50) — NOT NULL
- college_id — CHAR(5) — NOT NULL
- office — VARCHAR(30)
ENROLLMENT
- year — YEAR — Primary key — NOT NULL
- semester — INT — Primary key — NOT NULL
- student_id — CHAR(8)
- subject_id — CHAR(6)
- grade — CHAR(2)
EQUIPMENT
- equip_id — CHAR(6)
- name — VARCHAR(50) — NOT NULL
- status — VARCHAR(10)
- room_id — CHAR(6)
LIBRARY
- lib_id — CHAR(5)
- name — VARCHAR(50) — NOT NULL
- location — VARCHAR(50)
- seat_count — INT
PROFESSOR
- prof_id — CHAR(8)
- name — VARCHAR(30) — NOT NULL
- dept_id — CHAR(5) — NOT NULL
- lab — VARCHAR(30)
STAFF
- staff_id — CHAR(8)
- name — VARCHAR(30) — NOT NULL
- dept — VARCHAR(30)
- building_id — CHAR(5)
STUDENT
- student_id — CHAR(8)
- name — VARCHAR(30) — NOT NULL
- dept_id — CHAR(5) — NOT NULL
- phone — VARCHAR(15)
- entrance_year — YEAR — NOT NULL
SUBJECT
- subject_id — CHAR(6)
- name — VARCHAR(50) — NOT NULL
- credit — INT — NOT NULL
- prof_id — CHAR(8) — NOT NULL