Composite Keys?
Composite Keys?
I have just established a ZOHO account, and am in process of familiarizing myself with ZOHO Creator.
My object is to create a database application to track my library of sheet music. I have several hundred pieces of brass quintet sheet music arrangements to track. First, I need to identify each one. But the title, by itself, is insufficient for this. I have determined that there are three data elements necessary to identify each piece. None of them are sufficient to uniquely identify a piece by itself, but, taken together, they are. The data elements I want to use are the title, the composer, and the arranger.
First Question: Will ZOHO permit me to use these three attributes, jointly, to be a unique identifier?
Second Question: I framed the initial statement of the problem too simplistically. Actually, sometimes there is more than one composer, and also more than one arranger. So, I'm thinking that I need the composer and arranger data elements each to be multivalued. That is each of those fields, I think, needs to be a List, Array, or Set. (That is, the "atomicity" needs to be a multivalued object.) Perhaps, this is more suited to a NoSQL database-- I'm not sure. Can ZOHO permit me to handle this?
Thank you for any information.
Regards,
David Grove