So basically I should have say an inventory table.Then create a relationship with the album table
IE [inventory] ID album_ID album_name cost saleprice retail taxable etc etc etc 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: "Janine Jakim" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, January 15, 2002 2:00 PM Subject: RE: SQL? > The problem with keeping the price with the album. What if the album > goes on > sale? You'd change the price in the album table then suddenly anyone > who > bought the album previously shows that they paid the sale price. > You would at least need to add a history table or make sure that the > sales > table shows the actual price and isn't just hooked to the album table. > It's been a long day- hope this is coherent enough. > > -----Original Message----- > From: Douglas Brown [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, January 15, 2002 5:01 PM > To: CF-Talk > Subject: SQL? > > > 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 > > ______________________________________________________________________ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists