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