thanks gops I agree. we need to decide on types of information and fields before even putting them in a db.
and we will start using the fields from Vinayak's format as a start. and we can add the columns later. On Tue, Aug 24, 2010 at 7:55 PM, Gopal Srinivasan <catchg...@gmail.com>wrote: > > > 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 >> >> > > -- ----------------------------------- http://roshanravi.com http://ramblingsoul.com http://cssheaven.org
