Database and IT project managment

ENROLLMENT *PF STUDENT_ID NUMBER (8 \f *PF SECTION_ID NUMBER (8 \f *ENROLL_DATE DATE FINAL_GRADE NUMBER (3 \f *CREATED_BY VARCHAR2 (30 BYTE \f *CREATED_DATE DATE *MODIFIED_BY VARCHAR2 (30 BYTE \f *MODIFIED_DATE DATE ENR_PK (STUDENT_ID, SECTION_ID \fENR_SECT_FK (SECTION_ID \fENR_STU_FK (STUDENT_ID \fENR_SECT_FK_I (SECTION_ID \fENR_PK (STUDENT_ID, SECTION_ID \f

STUDENT *P STUDENT_ID NUMBER (8 \f SALUTATION VARCHAR2 (5 BYTE \f FIRST_NAME VARCHAR2 (25 BYTE \f *LAST_NAME VARCHAR2 (25 BYTE \f STREET_ADDRESS VARCHAR2 (50 BYTE \f *F ZIP VARCHAR2 (5 BYTE \f PHONE VARCHAR2 (15 BYTE \f EMPLOYER VARCHAR2 (50 BYTE \f *REGISTRATION_DATE DATE *CREATED_BY VARCHAR2 (30 BYTE \f *CREATED_DATE DATE *MODIFIED_BY VARCHAR2 (30 BYTE \f *MODIFIED_DATE DATE STU_PK (STUDENT_ID \fSTU_ZIP_FK (ZIP \fSTU_ZIP_FK_I (ZIP \fSTU_PK (STUDENT_ID \f

SECTION *P SECTION_ID NUMBER (8 \f *UF COURSE_NO NUMBER (8 \f *U SECTION_NO NUMBER (3 \f START_DATE_TIME DATE LOCATION VARCHAR2 (50 BYTE \f *F INSTRUCTOR_ID NUMBER (8 \f CAPACITY NUMBER (3 \f *CREATED_BY VARCHAR2 (30 BYTE \f *CREATED_DATE DATE *MODIFIED_BY VARCHAR2 (30 BYTE \f *MODIFIED_DATE DATE SECT_PK (SECTION_ID \fSECT_SECT2_UK (SECTION_NO, COURSE_NO \fSECT_CRSE_FK (COURSE_NO \fSECT_INST_FK (INSTRUCTOR_ID \fSECT_CRSE_FK_I (COURSE_NO \fSECT_INST_FK_I (INSTRUCTOR_ID \fSECT_PK (SECTION_ID \fSECT_SECT2_UK (SECTION_NO, COURSE_NO \f

INSTRUCTOR *P INSTRUCTOR_ID NUMBER (8 \f SALUTATION VARCHAR2 (5 BYTE \f FIRST_NAME VARCHAR2 (25 BYTE \f LAST_NAME VARCHAR2 (25 BYTE \f STREET_ADDRESS VARCHAR2 (50 BYTE \f F ZIP VARCHAR2 (5 BYTE \f PHONE VARCHAR2 (15 BYTE \f *CREATED_BY VARCHAR2 (30 BYTE \f *CREATED_DATE DATE *MODIFIED_BY VARCHAR2 (30 BYTE \f *MODIFIED_DATE DATE INST_PK (INSTRUCTOR_ID \fINST_ZIP_FK (ZIP \fINST_ZIP_FK_I (ZIP \fINST_PK (INSTRUCTOR_ID \f

COURSE *P COURSE_NO NUMBER (8 \f *DESCRIPTION VARCHAR2 (50 BYTE \f COST NUMBER (9,2 \f F PREREQUISITE NUMBER (8 \f *CREATED_BY VARCHAR2 (30 BYTE \f *CREATED_DATE DATE *MODIFIED_BY VARCHAR2 (30 BYTE \f *MODIFIED_DATE DATE CRSE_PK (COURSE_NO \fCRSE_CRSE_FK (PREREQUISITE \fCRSE_CRSE_FK_I (PREREQUISITE \fCRSE_PK (COURSE_NO \f

ZIPCODE *P ZIP VARCHAR2 (5 BYTE \f CITY VARCHAR2 (25 BYTE \f STATE VARCHAR2 (2 BYTE \f *CREATED_BY VARCHAR2 (30 BYTE \f *CREATED_DATE DATE *MODIFIED_BY VARCHAR2 (30 BYTE \f *MODIFIED_DATE DATE ZIP_PK (ZIP \fZIP_PK (ZIP \f

GRADE *PF STUDENT_ID NUMBER (8 \f *PF SECTION_ID NUMBER (8 \f *PF GRADE_TYPE_CODE CHAR (2 BYTE \f *P GRADE_CODE_OCCURRENCE NUMBER (38 \f *NUMERIC_GRADE NUMBER (3 \f COMMENTS VARCHAR2 (2000 BYTE \f *CREATED_BY VARCHAR2 (30 BYTE \f *CREATED_DATE DATE *MODIFIED_BY VARCHAR2 (30 BYTE \f *MODIFIED_DATE DATE GR_PK (STUDENT_ID, SECTION_ID, GRADE_TYPE_CODE, GRADE_CODE_OCCURRENCE \fGR_ENR_FK (STUDENT_ID, SECTION_ID \fGR_GRTW_FK (SECTION_ID, GRADE_TYPE_CODE \fGR_GRTW_FK_I (SECTION_ID, GRADE_TYPE_CODE \fGR_PK (STUDENT_ID, SECTION_ID, GRADE_TYPE_CODE, GRADE_CODE_OCCURRENCE \f

GRADE_TYPE_WEIGHT *PF SECTION_ID NUMBER (8 \f *PF GRADE_TYPE_CODE CHAR (2 BYTE \f *NUMBER_PER_SECTION NUMBER (3 \f *PERCENT_OF_FINAL_GRADE NUMBER (3 \f *DROP_LOWEST CHAR (1 BYTE \f *CREATED_BY VARCHAR2 (30 BYTE \f *CREATED_DATE DATE *MODIFIED_BY VARCHAR2 (30 BYTE \f *MODIFIED_DATE DATE GRTW_PK (SECTION_ID, GRADE_TYPE_CODE \fGRTW_GRTYP_FK (GRADE_TYPE_CODE \fGRTW_SECT_FK (SECTION_ID \fGRTW_GRTYP_FK_I (GRADE_TYPE_CODE \fGRTW_PK (SECTION_ID, GRADE_TYPE_CODE \f

GRADE_TYPE *P GRADE_TYPE_CODE CHAR (2 BYTE \f *DESCRIPTION VARCHAR2 (50 BYTE \f *CREATED_BY VARCHAR2 (30 BYTE \f *CREATED_DATE DATE *MODIFIED_BY VARCHAR2 (30 BYTE \f *MODIFIED_DATE DATE GRTYP_PK (GRADE_TYPE_CODE \fGRTYP_PK (GRADE_TYPE_CODE \f

GRADE_CONVERSION *P LETTER_GRADE VARCHAR2 (2 BYTE \f *GRADE_POINT NUMBER (3,2 \f *MAX_GRADE NUMBER (3 \f *MIN_GRADE NUMBER (3 \f *CREATED_BY VARCHAR2 (30 BYTE \f *CREATED_DATE DATE *MODIFIED_BY VARCHAR2 (30 BYTE \f *MODIFIED_DATE DATE GRCON_PK (LETTER_GRADE \fGRCON_PK (LETTER_GRADE \f