# Structuring the database in this case

**URL:** <https://forum.bubble.io/t/structuring-the-database-in-this-case/177500>\
**Category:** Database\
**Created:** [November 9, 2021, 7:00pm UTC](https://forum.bubble.io/t/structuring-the-database-in-this-case/177500 "2021-11-09T19:00:04Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![cheskiefisch](https://avatars.discourse-cdn.com/v4/letter/c/848f3c/32.png) [@cheskiefisch](https://forum.bubble.io/u/cheskiefisch)\
**Post date:** [November 9, 2021, 7:00pm UTC](https://forum.bubble.io/t/structuring-the-database-in-this-case/177500/1 "2021-11-09T19:00:04Z")

</div>

**A client fills out a form** for a job request to a music production house.

The client chooses **items needed for the project** from the following 5 lists:

**Elements** (Example: Melody, Rhythem, Etc.)  
**Instruments** (Vocals, Violin, Etc.)  
**Services** (Performing, Recording, Editing, Etc.)  
**Artist** (John Jhonson, Joey, Etc.)  
**Song Section** (Intro, Verse, Chorus, Etc.)

Now we know that **the client wants those selected item in** Elements, Instruments, Services, Artists, Song Sections.

**In terms of database it means** that we add those selected items (each list having their own “type”) to the current project “thing” in the “Project” type.

**But how does the client specify the relations** , for example:

“ **John Jhonson** ” (Artist), will “ **Perform** ” (Service) the “ **Violin** ” (Instrument) for the “ **Melody** ” (Element) on the “ **Intro** ” (Song Section).

**How is this presented to the database?**

---

<div class="post-metadata">

**Author:** ![lindsay\_knowcode](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/lindsay_knowcode/32/92967_2.png) [@lindsay\_knowcode](https://forum.bubble.io/u/lindsay_knowcode)\
**Post date:** [November 9, 2021, 7:17pm UTC](https://forum.bubble.io/t/structuring-the-database-in-this-case/177500/2 "2021-11-09T19:17:17Z")

</div>

I think you’ve kind of got most of it - I’d add another Thing like “project performance components” (which is represents the verb service, is how I think about it)  
and that would hold entries of these performance component Things for the project (and thus create the relationships)

**Project Performance Components**  
Project  
Artist  
Instrument  
Element  
Song Section

So the Client (well the application does all the inserts) basically inserts rows into “project performance components” that looks like  
Project, " “ **John Jhonson** ” (Artist), the “ **Violin** ” (Instrument) for the “ **Melody** ” (Element) on the “ **Intro** ” (Song Section)."

And I imagine a Project has a few rows of these in “Project Performance Components” to create all the components of the song/project

At least that is what makes sense to me 🙂
