how would you do this.

[Guest]

hey all,

let's take the Products table in the northwind database as an example. on my
main page i'd like to take 5 products and make them the featured products. so
i'm on a page with a list of products to choose from (say like checkboxes
next to the products i want as featured products). i'm thinking to add a
boolean field called Featured to the Products table.

Would this be a good or bad idea? Please explain.

thanks,
rodchar

 

[Guest]

That would be an easy solution, but rather limited.

An alternative would be to add a table where you store the id's of the
featured products. Then you get some benefits:

:: You can store additional information about the featured products
wihtout wasting space in the products table.

:: By adding a type field you can also handle other kinds of special
treatments for products.

 

[Guest]

say a table named FeaturedProducts maybe?

That would be an easy solution, but rather limited.

An alternative would be to add a table where you store the id's of the
featured products. Then you get some benefits:

:: You can store additional information about the featured products
wihtout wasting space in the products table.

:: By adding a type field you can also handle other kinds of special
treatments for products.

 

[Guest]

Yes, that would work.

say a table named FeaturedProducts maybe?