naverCloud_practice1

Tables (5)

department

  • dep_id — VARCHAR(10) — Primary key — NOT NULL
  • dep_name — VARCHAR(10)

enroll

  • sub_id — INT — Foreign key → subject.sub_id — NOT NULL
  • stu_id — INT — Foreign key → student.stu_id — NOT NULL

professor

  • prof_id — INT — Primary key — NOT NULL
  • dep_id — VARCHAR(10) — Foreign key → department.dep_id — NOT NULL
  • prof_name — VARCHAR(10)

student

  • stu_id — INT — Primary key — NOT NULL
  • dep_id — VARCHAR(10) — Foreign key → department.dep_id — NOT NULL
  • stu_name — VARCHAR(10) — NOT NULL
  • height — DECIMAL(3, 1)

subject

  • sub_id — INT — Primary key — NOT NULL
  • sub_name — VARCHAR(15)
  • start_date — DATE
  • end_date — DATE