Expand data model

[codaich]

Expand your data model outline at https://github.com/ELVIS-Project/SIMSSA-Database/wiki/Entity-Attributes to include all entities and relationships in the original DLfM 2017 ERD. Continue adding entity attributes as you think of them. Make use of the content at https://ddmal.teamwork.com/#notebooks/179803. Don't feel you need to do everything yet, but start thinking about what should be prioritized, and keep track of what is done and what is not done yet.

Come up with a proposed update to the data model originally proposed at DLfM 2017 that we can use in our first implementation of the database, and discuss it with me for finalization. This update should include new entities and an outline of all relationships between all entities (including cardinality in both directions), and all attributes of all entities. Don't worry about making a graph for now; the approach you've already started on the Wiki is perfect at this preliminary stage.

[blueNoteb5]

Musicologically and text-search important metadata:

• [x] Title
• [x] Composer
• [x] Instrument/voices
• [x] Geographical locations
• [x] Periods of time
• [x] Genre
• [x] Religiosity
• [ ] Vocalization
• [x] Bibliographic identifiers
• [X] Ordering of sections

[blueNoteb5]

Entities, relationships and attributes associated with the musical notation used in Source entities:

• [x] Chant (various types)
• [x] Modal
• [x] Black mensural
• [x] White mensural
• [x] Modern notation
• [x] Original note values
• [x] Diminished note values

[blueNoteb5]

Entities, relationships and attributes associated with making sure are correctly understanding the amount of detail available in a symbolic encoding:

• [x] Accidentals encoded
• [x] Real octave
• [x] Tuning system specified
• [x] Written for transposing instrument
• [x] Instrument/voice specified
• [x] Tempo specified
• [x] Precise rhythmic information specified
• [x] Mensural notation
• [x] Quantized
• [x] Steady tempo
• [x] Dynamic markings present
• [x] Performance markings present

[blueNoteb5]

Entities, relationships and attributes associated with text found on Source entities (and associated languages):

• [x] Lyrics
• [x] Title
• [x] Editorial notes

[blueNoteb5]

@codaich please take a look at the update Wiki page, I've added attributes and promoted a few attributes to entities.

[codaich]

This is looking good @blueNoteb5, thanks! We can discuss details tomorrow, and then get it ready to show to the musicologists on our team to see if it includes everything they need.

[blueNoteb5]

Cool, thanks. However, please note that I didn't include any of the attributes, entities or relationships that deal with chains of provenance and transformations, because I'm not quite sure how to implement those, even on a conceptual level.

[blueNoteb5]

Also, @codaich, what exactly do you mean by vocalization?

[codaich]

Good question, I'm not sure. Maybe ask Claire or Nat if they're around, or Julie if they're not. That list is from a brainstorming session a year ago, so much of it did not come from me, and I don't remember exactly what everything was.