Sam, Great - that def. looks v comprehensive. Must've been a lot of effort I'm sure. Any chance you can convert the VSD into a standard image format like JPG and send it across?
Thanks! --- In arrahmanfans@yahoogroups.com, "samsujith_k" <samsujit...@...> wrote: > > http://www.4shared.com/file/3_BIOAIK/MusicDB.html > > > I work as a Database Developer and I am hobby musician. Combining those two > interests I once put some effort into creating a database around ARR's music. > My goal was to capture all the information that is usually associated with a > typical ARR's album (Track Lists, Singers, Musicians, Engineers involved, > Studios involved etc). But besides this, I also wanted something along the > lines of Music Genome Project, wherein some musical attributes are identified > in each ARR's song/album. And the third goal (though, I assume it would be a > bit hard to reach) is to identify the gear used in ARR's songs. This would > include the software used, the different kinds of Mics used, Effect Boxes > (Equalizers, Compressors etc) used and so forth. > > The first goal of getting various credits involved is the one that can be > easily done. This is usually available in different formats and that could be > massaged per the DB design. > > The second goal of associating some musical attributes can be a bit hard and > involves some work from musically knowledgeable people. I did some as sample > data and we could proceed along those lines (please look into the > attachment). > > The third goal of getting all the gear used might be the toughest one (and to > an extent could be ARR's trademark secrets, so cannot be let known to general > public), but if any data/information is be available through ARR's associates > or other knowledgeable people, it would add a great deal of knowledge. In the > west we see a great deal of information being shared on the gear being used > and how. I would love to see that kind of information coming out of our > Indian musicians and studios. ARR himself mentions some of the > gear/production techniques he uses in his interviews with Music vendors (for > example, on Apple website, ARR mentioned he processed drums in Ringa Ringa > through Native Instruments Guitar Rig and so on). > > Anyways, I came up with a scratch design some time back. Attached in this > email are the various files regarding this (will explain what each file is > shortly). The third goal which I mention above is not yet included in this > design. But the other two are in there, atleast in a first draft format. > > The attachment in the link (http://www.4shared.com/file/3_BIOAIK/MusicDB.html > ) has the following: > 1. ARRMusic.bak - This is the backup file of the database I built in SQL > Server 2000. > 2. MusicDB ERD.vsd - This is the ERD (MS Visio format) of the above database. > This should give you an idea of what I tried then. > 3. Object Script.sql - A Simple script used to create the tables and some > sample views > 4. Sample Data Entry.sql - A script I used to enter some sample data (most of > this data is accurate, some changes might be required here and there). > 5. Sample Queries.sql - Some typical queries > 6. Export - Sample Data.xls - An export of the sample data entered above in > excel format > 7. Export - Sample Queries.xls - Some sample data queried based on the data > entered. > > Please let me know if I can be of any assistance in this matter. Or if this > design would be of any use (we can change as needed). > > Regards, > Sam >