Thanks to everyone that agreed to participate. The enthusiasm to get things rolling is encouraging. However, I would caution against adhoc development. Between ourselves, we have 90%-95% of the data we need. So, that need not be the focus. In my view, the focus needs to be on designing a database that is robust and extensible in design. It should allow for backend storage and front end ingestion and retrieval of data. Extensibility is particularly important because there may be views of data that we don't conceive now but will be come apparent in future. A relational database schema seems like the best approach to take. Let me illustrate that with an example - in some cases you have credits for musicians for a song and in many cases only for an entire album. This is true for awards too. The only way this can be handled is through relational databases with well thought-through entity-relationships. I would therefore request that let our initial focus be on defining what kind of information are we seeking to archive and then design the database before getting down to implementation. Populating it with data is a relatively trivial task. Suggestions welcome.
On Mon, Aug 23, 2010 at 19:48, Roshan <c.pix...@gmail.com> wrote: > > > Thank you everyone who took the time to compile the list for the db. > > > i have just created a form to collect the data directly to MySQL. so that > exporting it to any db would be easier. > > http://sandbox.roshanravi.com/arrdb/use/ARRahmanDatabase/form1.html > > i will be adding in teh album names from the excel file we have when i get > a chance, but if you want to add something by yourself, please feel free.. > > > it is just using a form generator. the only goal is to collect the data. > > > these are the updated fields for Album. yet to do the songs db section. > > *Film Or Album* *Language**Dubbed**Year of Movie Release* *Year of Audio > Release**Genre**Audio Company* *Actors**director **Movie Genre**Awards Won > for music* *Awards Nominated for music**AWards won for movie**awards > nominated for movie* *Other notes* > > > -- > ----------------------------------- > http://roshanravi.com > http://ramblingsoul.com > http://cssheaven.org > > >
