Advice on database design/structure

[eva2000]

I'm working on a php/mysql lcd monitor database for a new site and the database structure is getting complicated and i'm not sure about the lookup tables and fields...

i outlined what i what to do and the current 'on paper' table structure and fields and output i want at http://lcdmonitorinfo.com/templates/dbtemplate2.html

anyone would like to go over the database structure and provide suggestions or advice as to better do this ?

thanks 😃

[barand]

The main question to ask regarding table relationships is

Is it a one-to-many or a many-to-many relationship?

For example

A manufacturer has many products
A product has one manufacturer

Therefore not a many-many-many so you do not need an intermediate link table, you can just link directly from product to manufacturer using product.mid.

On the other hand you may have a review article which refers to many products and a product with many reviews. This would be a many-to-many and would need a link table.

hth