nice looking site, doug. ----- Original Message ----- From: Douglas Brown To: SQL Sent: Tuesday, January 15, 2002 6:27 PM Subject: Re: Database configuration ?
The site will be countrymusicgroups, and you can see the beginning of it here if you like. I am working on like three different ones currently and have them all molded into one IP for now to do testing. It is in it's infancy and nothing really works at this point. http://www.carnivorepc.com/countrymusicgroup There are two major products that come out of Berkeley: LSD and [Unix] BSD. We don't believe this to be a coincidence. Doug Brown ----- Original Message ----- From: "Jeffry Houser" <[EMAIL PROTECTED]> To: "SQL" <[EMAIL PROTECTED]> Sent: Tuesday, January 15, 2002 4:04 PM Subject: Re: Database configuration ? > : hmm: > > Well, there are way too many variations to tell you specifically what to > do, but... > > I would do something like this: > > Artist (ArtistID, Artistinfo) > Song (SongID, SongInfo) > Disc (DiscID, DiscInfo) > > DiscSongArtist (DiscID, SongID, ArtistID) ( This is an intersection > table and will give you the songs on a disc and the relevant artist.... for > example, both Madonna and Don McClean do a version of American Pie.. you > will want your system to be able to handle that without problems. Also it > is not uncommon for a single song to be on multiple CDs, for example > anything that was released as a single is usually on a full length album > and the single ) > > > As far as ordering stuff, yes I would separate price into it's own > table. Are the prices going to change on a routine basis? If so, then > when an order is created, I would also store the current price of the item > in the order tables, as every time a price changes you aren't changing past > orders in the process. > > I am wondering what site you are working on. > > > > At 02:28 PM 01/15/2002 -0800, you wrote: > >I am trying to figure out how I should set up a database for an ecommerce > >site. I will be selling music CD's. > > > >Each artist can have several albums, and each album can have several > >tracks. I am pretty sure I will need 3 tables for that info. What I am > >wondering , is where should I keep pricing info and such? Should it be in > >the album table or should there be a seperate table for pricing etc. Any > >insight would be helpful. > > > > > > > >There are two major products that come out of Berkeley: LSD and [Unix] > >BSD. We don't believe this to be a coincidence. > > > > > > > >Doug Brown > > > >Archives: http://www.mail-archive.com/[email protected]/ > >Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebarsts > > -- > Jeffry Houser | mailto:[EMAIL PROTECTED] > AIM: Reboog711 | ICQ: 5246969 | Fax / Phone: 860-223-7946 > -- > DotComIt: Database Driven Web Data > My Book: Instant ColdFusion 5 | http://www.instantcoldfusion.com > My New Book: ColdFusion: A Beginner's Guide February 2002 > -- > Far Cry Fly, Alternative Folk Rock > http://www.farcryfly.com | http://www.mp3.com/FarCryFly > ______________________________________________________________________ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
