Firstly, excuse me for my english, I'll try to do the best.
I need to do a data base (is said data base, I suppose) to organize a classical music collection, and I don't have any idea how to do it. This database must contain these:
- Compositor
- Piece
- Director
- Orchestra
- Soloists
(These items must be a dropdown with the most common ones and with a final box to write "the less common")
- Choir
- Record Label
- Year
- Supporting (isn't it? if it's CD, DVD...)
- Duration
(Current boxes, if it is possible, classificated to search something in the future)
- Comments
I hope to have been explicit