Daelim

Tables (6)

Advisor (student-professor)

  • PROFNO (profno) — NUMBER(5) — Foreign key → Professor.PROFNO — NOT NULL
  • STUDNO (studno) — NUMBER(5) — Foreign key → Student.STUDNO — NOT NULL
  • GRADE (grade) — NUMBER(5)
  • SEMESTER (semester) — NUMBER(5)

Course (수강)

  • STUDNO (studno) — NUMBER(5) — Foreign key → Student.STUDNO — NOT NULL
  • PROFNO (profno) — NUMBER(5) — Foreign key → Professor.PROFNO — NOT NULL
  • CLASSNO (classno) — NUMBER(5) — Foreign key → LECTURE.CLASSNO
  • ATTENDANCE (attendance) — NUMBER(5)
  • MIDTERM (midterm) — NUMBER(5)
  • FINAL (final) — NUMBER(5)
  • EXTRA (extra) — NUMBER(5)
  • TOTAL (total) — NUMBER(5)
  • GRADE (grade) — VARCHAR2(20)

Department (department)

  • DEPTNO (deptno) — NUMBER(5) — Primary key
  • NAME (name) — VARCHAR2(20)
  • TEL (tel) — VARCHAR2(13)

LECTURE (lecture)

  • CLASSNO (classno) — NUMBER(5) — Primary key
  • DEPTNO (deptno) — NUMBER(5) — Foreign key → Department.DEPTNO
  • NAME (name) — VARCHAR2(20)
  • CREDIT (credit) — NUMBER(5)
  • TIME (time) — VARCHAR2(20)
  • LOC (loc) — VARCHAR2(20)
  • PROFNO (profno) — NUMBER(5) — Foreign key → Professor.PROFNO — NOT NULL

Professor (professor)

  • PROFNO (profno) — NUMBER(5) — Primary key — NOT NULL
  • NAME (name) — VARCHAR2(20)
  • IDNUM (idnum) — VARCHAR2(13)
  • ADDRESS (address) — VARCHAR2(20)
  • TEL (tel) — VARCHAR2(13)
  • EMAIL (email) — VARCHAR2(20)
  • PROFILE (profile) — VARCHAR2(255)
  • DEPTNO (deptno) — NUMBER(5) — Foreign key → Department.DEPTNO

Student (student)

  • STUDNO (studno) — NUMBER(5) — Primary key — NOT NULL
  • NAME (name) — VARCHAR2(20)
  • IDNUM (idnum) — VARCHAR2(13)
  • ADDRESS (address) — VARCHAR2(20)
  • TEL (tel) — VARCHAR2(13)
  • EMAIL (email) — VARCHAR2(20)
  • PROFILE (profile) — VARCHAR2(255)
  • DEPTNO (deptno) — NUMBER(5) — Foreign key → Department.DEPTNO
  • PROFNO (profno) — NUMBER(5) — Foreign key → Professor.PROFNO — NOT NULL