Page 1 of 1
PART II. APPLICATION. (10 Marks) 1. Sketch out an entity relationship diagram showing the cardinality for the following.
Posted: Sat Feb 19, 2022 3:23 pm
by answerhappygod
- Part Ii Application 10 Marks 1 Sketch Out An Entity Relationship Diagram Showing The Cardinality For The Following 1 (209.72 KiB) Viewed 31 times
PART II. APPLICATION. (10 Marks) 1. Sketch out an entity relationship diagram showing the cardinality for the following. A student with STUDENT-ID, ADDRESS, and SURNAME takes any number of subjects which have a unique SUBJECT-NAME and a SUBJECT-DESCRIPTION. The student is enrolled in a major that has a unique MAJOR-NAME and LENGTH.A subject is taught by one teacher, who is identified by a TEACHER-ID and has a TEACHER-ADDRESS a) Analyze the above scenario and derive the Entity relationship diagram (10 marks) (Marking Scheme: 4 Marks for identifying 4 entities+2 marks for the attributes+2 marks for cardinality+2 marks for relationship)