- Part Ii Application 10 Marks 1 Sketch Out An Entity Relationship Diagram Showing The Cardinality For The Following 1 (209.72 KiB) Viewed 29 times
PART II. APPLICATION. (10 Marks) 1. Sketch out an entity relationship diagram showing the cardinality for the following.
-
- Site Admin
- Posts: 899603
- Joined: Mon Aug 02, 2021 8:13 am
PART II. APPLICATION. (10 Marks) 1. Sketch out an entity relationship diagram showing the cardinality for the following.
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)