Company

테이블 (7)

Department(학과) (Department)

  • dno — INTEGER
  • dname — VARCHAR(50) — NOT NULL
  • office — VARCHAR(50)
  • run_prof_ssn — INTEGER

Graduate(대학원생) (Graduate)

  • ssn — INTEGER
  • name — VARCHAR(50) — NOT NULL
  • age — INTEGER
  • deg_prog — VARCHAR(20)
  • major_dno — INTEGER
  • advisor_ssn — INTEGER

Professor(교수) (Professor)

  • ssn — INTEGER
  • name — VARCHAR(50) — NOT NULL
  • age — INTEGER
  • rank — VARCHAR(20)
  • speciality — VARCHAR(50)

Project(과제) (Project)

  • pid — INTEGER
  • sponsor — VARCHAR(50)
  • start_date — DATE
  • end_date — DATE
  • budget — INTEGER
  • manage_prof_ssn — INTEGER — NOT NULL

Work_Dept

  • prof_ssn — INTEGER
  • dno — INTEGER
  • pct_time — INTEGER

Work_In

  • pid — INTEGER
  • prof_ssn — INTEGER

Work_Prog

  • pid — INTEGER
  • grad_ssn — INTEGER