J
Joshua Powell
Hello,
I am working on a project that tracks contact info for music groups,
and the agencies that book them. There's three big components to this
and I'm having a hell of a time wrapping my head around what may be
the best way to go about the initial table design and relations. Any
suggestions?
I need to fulfill these obligations: (what I have assumed needs to be
in a table of its own I have capitalized)
INDIVIDUALS will be considered either booking agents or performers and
can be both!
INDIVIDUALS can belong to multiple GROUPS
INDIVIDUALS can belong to a BOOKING AGENCY
GROUPS must be made up of at least one but can be made up of many
INDIVIDUALS who will be considered performers. One performer will be
considered the 'Lead' who's contact information will be the groups
contact information
GROUPS can be made up of no more than one INDIVIDUALS who will be
considered booking agents
GROUPS can belong to a BOOKING AGENCY
BOOKING AGENCIES will be made up of multiple INDIVIDUALS who will be
considered booking agents
BOOKING AGENCIES will have many GROUPS as well
After building tables that follow this I will also need to hold more
information about Groups history, but that will be a whole 'nother
train of thought, likely only using the GroupID.
Any help is tremendously appreciated!
Joshua
I am working on a project that tracks contact info for music groups,
and the agencies that book them. There's three big components to this
and I'm having a hell of a time wrapping my head around what may be
the best way to go about the initial table design and relations. Any
suggestions?
I need to fulfill these obligations: (what I have assumed needs to be
in a table of its own I have capitalized)
INDIVIDUALS will be considered either booking agents or performers and
can be both!
INDIVIDUALS can belong to multiple GROUPS
INDIVIDUALS can belong to a BOOKING AGENCY
GROUPS must be made up of at least one but can be made up of many
INDIVIDUALS who will be considered performers. One performer will be
considered the 'Lead' who's contact information will be the groups
contact information
GROUPS can be made up of no more than one INDIVIDUALS who will be
considered booking agents
GROUPS can belong to a BOOKING AGENCY
BOOKING AGENCIES will be made up of multiple INDIVIDUALS who will be
considered booking agents
BOOKING AGENCIES will have many GROUPS as well
After building tables that follow this I will also need to hold more
information about Groups history, but that will be a whole 'nother
train of thought, likely only using the GroupID.
Any help is tremendously appreciated!
Joshua