Question

1 Approved Answer

Posted on Sep 20, 2024

P PS1.COURSE COURSE_NO NUMBER (8) DESCRIPTION VARCHAR2 (50 BYTE) COST NUMBER (9.2) PREREQUISITE NUMBER (8) - CREATED_BY VARCHAR2 (30 BYTE) - CREATED_DATE DATE * MODIFIED_BY

image text in transcribed

P PS1.COURSE COURSE_NO NUMBER (8) DESCRIPTION VARCHAR2 (50 BYTE) COST NUMBER (9.2) PREREQUISITE NUMBER (8) - CREATED_BY VARCHAR2 (30 BYTE) - CREATED_DATE DATE * MODIFIED_BY VARCHAR2 (30 BYTE) * MODIFIED_DATE DATE CRSE_PK (COURSE_NO) CRSE_CRSE_FK (PREREQUISITE) CRSE_CRSE_FK_I (PREREQUISITE) CRSE_PK (COURSE_NO) - - - - - - - - - - - PS1.SECTION P SECTION_ID UF* COURSE_NO U SECTION_NO START_DATE_TIME LOCATION * INSTRUCTOR_ID CAPACITY * CREATED_BY * CREATED_DATE * MODIFIED_BY * MODIFIED DATE NUMBER (8) NUMBER (8) NUMBER (3) DATE VARCHAR2 (50 BYTE) NUMBER (8) NUMBER (3) VARCHAR2 (30 BYTE) DATE VARCHAR2 (30 BYTE) DATE PS1.ENROLLMENT PF STUDENT_ID NUMBER (8) PF* SECTION_ID NUMBER (8) * ENROLL_DATE DATE FINAL_GRADE NUMBER (3) * CREATED_BY VARCHAR2 (30 BYTE) * CREATED_DATE DATE * MODIFIED_BY VARCHAR2 (30 BYTE) * MODIFIED_DATE DATE ENR_PK (STUDENT_ID. SECTION_ID) ENR_SECT_FK (SECTION_ID) ENR_STU_FK (STUDENT_ID) ENR_PK (STUDENT_ID. SECTION_ID) ENR_SECT_FK_I(SECTION_ID) PS1.STUDENT STUDENT_ID NUMBER (8) SALUTATION VARCHAR2 (5 BYTE) FIRST_NAME VARCHAR2 (25 BYTE) LAST_NAME VARCHAR2 (25 BYTE) STREET_ADDRESS VARCHAR2 (50 BYTE) ZIP VARCHAR2 (5 BYTE) PHONE VARCHAR2 (15 BYTE) EMPLOYER VARCHAR2 (50 BYTE) * REGISTRATION_DATE DATE CREATED_BY VARCHAR2 (30 BYTE) * CREATED_DATE DATE * MODIFIED_BY VARCHAR2 (30 BYTE) * MODIFIED_DATE DATE STU_PK (STUDENT_ID) STU_PK (STUDENT_ID) STU_ZIP_FK_I (ZIP) SECT_PK (SECTION_ID) SECT_SECT2_UK (SECTION_NO, COURSE_NO) 3 SECT_CRSE_FK (COURSE_NO) SECT_CRSE_FK_I(COURSE_NO) SECT_INST_FK_I (INSTRUCTOR_ID) SECT_PK (SECTION_ID) SECT_SECT2_UK (SECTION_NO, COURSE_NO) P PS1.COURSE COURSE_NO NUMBER (8) DESCRIPTION VARCHAR2 (50 BYTE) COST NUMBER (9.2) PREREQUISITE NUMBER (8) - CREATED_BY VARCHAR2 (30 BYTE) - CREATED_DATE DATE * MODIFIED_BY VARCHAR2 (30 BYTE) * MODIFIED_DATE DATE CRSE_PK (COURSE_NO) CRSE_CRSE_FK (PREREQUISITE) CRSE_CRSE_FK_I (PREREQUISITE) CRSE_PK (COURSE_NO) - - - - - - - - - - - PS1.SECTION P SECTION_ID UF* COURSE_NO U SECTION_NO START_DATE_TIME LOCATION * INSTRUCTOR_ID CAPACITY * CREATED_BY * CREATED_DATE * MODIFIED_BY * MODIFIED DATE NUMBER (8) NUMBER (8) NUMBER (3) DATE VARCHAR2 (50 BYTE) NUMBER (8) NUMBER (3) VARCHAR2 (30 BYTE) DATE VARCHAR2 (30 BYTE) DATE PS1.ENROLLMENT PF STUDENT_ID NUMBER (8) PF* SECTION_ID NUMBER (8) * ENROLL_DATE DATE FINAL_GRADE NUMBER (3) * CREATED_BY VARCHAR2 (30 BYTE) * CREATED_DATE DATE * MODIFIED_BY VARCHAR2 (30 BYTE) * MODIFIED_DATE DATE ENR_PK (STUDENT_ID. SECTION_ID) ENR_SECT_FK (SECTION_ID) ENR_STU_FK (STUDENT_ID) ENR_PK (STUDENT_ID. SECTION_ID) ENR_SECT_FK_I(SECTION_ID) PS1.STUDENT STUDENT_ID NUMBER (8) SALUTATION VARCHAR2 (5 BYTE) FIRST_NAME VARCHAR2 (25 BYTE) LAST_NAME VARCHAR2 (25 BYTE) STREET_ADDRESS VARCHAR2 (50 BYTE) ZIP VARCHAR2 (5 BYTE) PHONE VARCHAR2 (15 BYTE) EMPLOYER VARCHAR2 (50 BYTE) * REGISTRATION_DATE DATE CREATED_BY VARCHAR2 (30 BYTE) * CREATED_DATE DATE * MODIFIED_BY VARCHAR2 (30 BYTE) * MODIFIED_DATE DATE STU_PK (STUDENT_ID) STU_PK (STUDENT_ID) STU_ZIP_FK_I (ZIP) SECT_PK (SECTION_ID) SECT_SECT2_UK (SECTION_NO, COURSE_NO) 3 SECT_CRSE_FK (COURSE_NO) SECT_CRSE_FK_I(COURSE_NO) SECT_INST_FK_I (INSTRUCTOR_ID) SECT_PK (SECTION_ID) SECT_SECT2_UK (SECTION_NO, COURSE_NO)