Instructions

Read and study the ERD of the STUDENT schema (diagrams available in the ERD directory of the zip file you downloaded for Practice Lab #1). Refer to schema description if needed (in the data_dictionary directory). Submit a text document to identify all entities and their relationships. For each entity, specify entity name, primary key, and foreign key along with the name of parent entity. For each relationship, specify type of relationship (cardinality) and business rules. For example: Relationship: 1:M between Instructor and Section. Business rules: an instructor can teach zero or many sections; a section will be taught by one and only one instructor.

NUMBER B) ARCHAR2 (26 EYTE VARCHAR2 (2000 BYTE TYPE CODE. ORADE CODE OCCURRENCE GRENAK ISTUDENT ID, SECTION D INSTRUCTOR D ENROLL DATE DATE INST PK (INSTRUCTOR D FERCENT OFFINAL ORADE NUMDER ) VARCHAR2 (20 BYTE TART DATE TIME DATE VARCHAR2 (30 BYTE VARCHAR2 (E0 BNTE AACHAR2 (65 BYTE GHTYP PK (GRACE TYPE COOE? ECT CABE FK COURSE NO NSTRUCTOR ID) LETTER CRACE VARCHAR2 2 BYTE) ORADE PONT NUMBER 32 ? secT-SECT2-UK (SECTION-NO'COURse No1