Need ER Diagram( Entity relationship diagram) for this scenario A local communit

Question

Need ER Diagram( Entity relationship diagram) for this scenario

A local community center is establishing a children’s playgroup that will introduce children in the neighborhood to other parents and children. This playgroup will sponsor weekly play sessions with a structured activity and free play time each week. If this program is successful, the community center would like to offer this play session on a daily basis. The following information needs to be considered, a parent can have more than one child, the parent information, including name, phone number, and mailing address need to be tracking. Child’s name, gender and age need to be tracked. The ability to track one or more sessions, including date, time, location and session type. Eventually the community center would like to add additional special “activities” that the parents and children would be interested.

Explanation / Answer

Parent Attributes : Name, Phone Number, Email id, Mailing Address
Child Attributes : Name, Age, Gender, Parent names, Child IDno, Time slot
Session Attributes : Date, Time, Location, Type of session

Primary keys would be Parent phone number, Email ID, Mailing Address

Relationship:
1.One parent can have many children.
2.One child will have only one parent
3.Each child can choose more than a session.
4.Each session will have more than one child

Components and entity relationship diagram: Entities are parent, child and session

********please just use a cyclindical block and place the items in that single componet in single entity relation diagram i am unable to draw here**************
Parent: Name, Phone Number, Email ID, Mailing Address ------>Child: Name, Age, Gender, Parent names, Child IDno, Time slot ------>Session: Date, Time, Location, Type of Session

Business rules:

1.One parent can have more than one child.
2. Only one parent represents every child.
3. Each child can participate in multiple sessions.
4. As a couple, either of the parents would register of how many children the couple has.

Related Questions

Navigate

• Browse (All)
• Browse N
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.