Many to many relationships
Posted by: Betty Calagoure
Date: October 17, 2024 12:27PM

I'm setting up a database for a local organization. The organization puts on weekend retreats, the retreats are run by teams which are pulled from a list of previous participants. The people who attend the weekends are then added to the list from which they may be pulled to work on one or more weekends on different jobs. This information needed is 2-fold:
1) list of all participants who worked on a weekend sorted by which jobs each participant did
2) find a weekend with a list of who was doing what job

I've worked with databases before but nothing this complicated. My structure is this:

WEEKENDS
Weekend_ID Weekend_Date Location Job_ID

JOBS
Job_ID Job_NAME

PARTICIPANTS
Participant_ID First_Name Last_Name Email Weekend_ID

PARTICIPANTS_JOBS
PJ_ID Job_ID Participant_ID Weekend_ID

WEEKENDS_JOBS
Weekend_ID PJ_ID Job_ID

Does this make sense? Am I missing something? Is it normalized properly?

Thanks for your help

Options: ReplyQuote


Subject
Written By
Posted
Many to many relationships
October 17, 2024 12:27PM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.