I'm fairly new to relational databases. I understand how fields may have
text data structures, but when it goes beyond that, I feel a bit out of my element.
I have a table called:
It is supposed to hold information on which key a classical music composition was written in. An example entry could be:
What I did is create two columns for the
name which is the name of the key, taking on values ranging from A-G, as well as
tonality which tells us whether the composition was major or minor.
It currently has this form:
Question: What is the best way to construct my
keys table (in terms of efficiency/scalability) and what data structures should the fields have?
I think it would make sense to have the
tonality field be a binary. But does binary in this case need to be 1's and 0's? Or is there an efficient way to include the whole string
major? I'm not sure if I need to create another table to relate it, or if it can be efficiently done with 1. Also is
text an appropriate field type for
key.name? It can only take on 7 values: A, B, C, D, E, F, G. (My data do not include sharps or flats).