Hi Gops, If we do have most of the information, then please share the same in any format. A scalable design is possible, but i am afraid it can be bit complicated for us to start enetering the data with it. We can come up with a ER diagram for the same, but it can be diffcult for us enter the data to it. IMO, as a first step if we have the details of songs as a excel sheet prepared by murugan, then we can easily import the same into a scalable DB design ( I can help on that ). Importing the data from the basic excel to a complicated database design cn be performed easily thro ETL tools and bit of querying and data massaging.
Regards, S.V.Nagaraj --- In arrahmanfans@yahoogroups.com, Gopal Srinivasan <catchg...@...> 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...@...> 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 > > > > > > >
