homework
Tables (9)
DEPARTMENT
- DEPT_ID — NUMBER(5)
- DEPT_NAME — VARCHAR2(30)
- DEPT_TEL — VARCHAR2(30)
ENROLLMENT
- OC_ID — VARCHAR2(5)
- STUD_ID — VARCHAR2(13)
- FINAL_SCORE — NUMBER(3)
EVALUATION
- OC_ID — VARCHAR2(5)
- STUD_ID — VARCHAR2(13)
- T_TYPE — NUMBER(2)
- E_SCORE — NUMBER(3)
LECTURE
- LEC_ID — VARCHAR2(5)
- LEC_NAME — VARCHAR2(50)
- CREDIT — VARCHAR2(1)
OPEN_COURSE
- OC_ID — VARCHAR2(5)
- OC_TOTAL_TIME — NUMBER(1)
- LEC_ID — VARCHAR2(5)
- P_ID — NUMBER(3)
OPEN_COURSE_INFO
- OC_SEQ — NUMBER(1)
- OC_ID — VARCHAR2(5)
- OC_WEEK — VARCHAR2(10)
- OC_TIME — NUMBER(1)
- OC_ROOM — VARCHAR2(5)
- OC_PERIOD — VARCHAR2(2)
PROFESSOR
- P_ID — NUMBER(3)
- P_NAME — VARCHAR2(30)
- P_MAJOR — VARCHAR2(50)
- P_TEL — VARCHAR2(30)
- DEPT_ID — NUMBER(5)
- CONSTRAINTS — fk_de_pro2
STUDENTS
- STUD_ID — VARCHAR2(13)
- STUD_NAME — VARCHAR2(30)
- STUD_TEL — VARCHAR2(30)
- STUD_EMAIL — VARCHAR2(50)
- STUD_ZIPCODE — VARCHAR2(10)
- STUD_ADD1 — VARCHAR2(255)
- STUD_ADD2 — VARCHAR2(100)
- DEPT_ID — NUMBER(5)
TEST_TYPE
- T_TYPE — NUMBER(2)
- TYPE_NAME — VARCHAR2(30)