Database Design

oscillate

Hello There.

I am about to create a database in mysql.

If i posted some conceptual schemas and table definition of the database design, i was wondering if you guys could have a look at it and tell me how i can make it more efficient and if im doing it the right way.

Basically its the most complex structure i have done. (probably pretty easy for most of you) and need help so that later i will not run into any issues when coding.

that would be awsome if you could help me out via msn or the forums. i really dont mind. I have good understanding of most things in mysql / php and terms etc.

my msn is nic(at)timecodestudios.com.au
TIA

Roger_Ramjet

So post it. If you get no response then that's your answer, but I'll bet you get plenty. If it's big, or easier, then make the schema an attachment.

oscillate

Ok.

Just some information. Its a magazine publisher.

A table has information about a person.
- personal details

- company details

A table has information about the magazines
- the magazine volume number.
- current 'Y' or 'N' field to determine if its current issue.
- cover image.
- brief description of magazine.
- which magazine the volume is in.

The Person can be listed in a yellow directory which can be browsed by categories and info can be found about the person/company

The Person can be listed in a classified directory which also has categories (but different from yellow pages). The classified ads directory is linked to the magazine, so that you can only see the current issue's classified ad.

subscription to newsletter with option to bring up all subscribers and email them

This is what i have done in terms of concept schema
i was hoping for some feedback on the schema taking in account the funtionality that is required. Thanks HEAPS. and see attachment to this post.

http://www.nicmorley.com/db_design1.gif