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