Read and study the ERD of the STUDENT schema (diagrams available in the ERD dire
ID: 3907252 • Letter: R
Question
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.
InstructionsRead 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 No1Explanation / Answer
Please let me know in case of any clarifications required. Thanks!
Relationship Business rules 1:N between ZIPCODE and INSTRUCTOR Many Instructors can have the same zipcode in their address 1:N between ZIPCODE and STUDENT Many Students can have the same zipcode in their address N:1 between ENROLLMENT and STUDENT One particular Student can be enrolled in multiple sections in which courses are taught that he/she likes 1:N between Section and ENROLLMENT 1 Section can have multiple students being enrolled in it 1:N between INSTRUCTOR and SECTION 1 Instructor can teach in multiple section 1:N between SECTION and COURSE 1 Section can have multiple courses being taught by InstructorsRelated Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.