Question: Make ER diagram (using UML notation) needs to show: the entity types, the binary relationship types, the complex relationship type, the multiplicity of relationship types,

Make ER diagram (using UML notation) needs to show: the entity types, the binary relationship types, the complex relationship type, the multiplicity of relationship types, the attributes (and if applicable their domains) of entity types, the attributes (and if applicable their domains) of relationship types, and the primary key of each entity type.
My course doesn't teach us Chen's notation or Crows Feet so please avoid using that.
Scenario thatcontains all the given conditions: School: The school has teachers, students, departments, progress card and clubs, each can be recognized as an entity. A student can enroll in only one club, it can be recognized as a one-to- many relationship A teacher can be in any number of clubs, also the club can contain many numbers of teachers, it can be recognized as many to many relationships A student will have only one progress card, thus one-to-one relationship can be recognized from this. A handled by relationship can be of multiple degree, a teacher can handle departments, clubs and even courses. Managed by relationship can be defined in the scenario as a recursive relationship since a teacher can manage herself. The age need not give explicitly it can be derived from date of birth The age can be a derived attribute. The address can be a composite attribute
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
