Advertisement DB Structure

[sagsy001]

Hi All,

I am working on a website, and I wan to include advertisement module to it. I am not really able to design good database structure for advertiser, advertisements and payments. Any 1 done this before, Please Help me in this. Thanks.

[Alan22]

I did ad banners management system a while ago. Can you please specify your requirements, so I might be able to provide more detailed help...

[sagsy001]

I did ad banners management system a while ago. Can you please specify your requirements, so I might be able to provide more detailed help...

Hey Allen, Thanks For reply,

What I want to do is advertise management on a site.

Advertiser will give an advertise and will have have to pay for it.

Amount he has to pay will be decided on duration and frequency of Ads.

Admin part will play important role in this.

I Want To Design DB To maintain This Scenario.

Thanks.

[Alan22]

I would recommend using one of the GUI DB design tools for the job.

My favorite is DB Designer - please see screen-shot attached.

Good luck with your project!