Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Section 2: Using a digital tool of your choice (draw.io, Visio, PowerPoint, etc), draw an Entity Relationship diagram (using UML notation) that would describe the

image text in transcribed

Section 2: Using a digital tool of your choice (draw.io, Visio, PowerPoint, etc), draw an Entity Relationship diagram (using UML notation) that would describe the following system You are starting a new business to promote reading through organized book club events. If you are unfamiliar with a book club, it is a group of individuals that meet regularly to discuss a book that all of the members have read. Your system should allow for individuals to start new clubs or join existing clubs. Consider the following requirements when drawing your ERD. Suggested Entity names are in Bold. Choose 3 attributes per entity and identify what would make an instance Unique (what would likely be the key) . A Member can belong to any number of Clubs, and Clubs can have any number of Members A Club must have a single Organizer. Organizers are also considered Members. This Organizer can only Organiz e a single Club Each Member donates a different amount to each Club they join. This can be considered a mem bership fee, and can be seen as an attribute of the membership relationship/association. Organizers/Members also have backup Members in case they cannot host a particular meeting Each Club may choose to hold a bank Account for which to serve as a coffer. The Account is related to the Club itself, as well as the Member identified as the Organizer. You can choose to implement Organizers explicitly as a subclass of Members or simply consider Organizers as a special case of Member

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Big Data With Hadoop MapReduce A Classroom Approach

Authors: Rathinaraja Jeyaraj ,Ganeshkumar Pugalendhi ,Anand Paul

1st Edition

1774634848, 978-1774634844

More Books

Students also viewed these Databases questions

Question

5. Describe the relationship between history and identity.

Answered: 1 week ago