should i normalize this?

In short, if you are doing transactional work in your database, yes, you should normalize it.

If the only thing you're doing with the data is reporting, you may need to re-arrange it (star or snowflake schema) but you don't have to normalize, if you're not inserting new records/modifying old records.
 
how would i normalize this though i have around 3000 entries of these...
can i use update query?
how do i do star and snowflakes :P
Thanks george
________
MAZDA MAZDAGO SPECIFICATIONS
 
Last edited:
Star & Snowflake schemas are only valid for incredibly large enterprise data warehouses. That you had to ask tells me you don't need them and that, yes, you should normalize.

Pat's answer should get you started.
 

Users who are viewing this thread

Back
Top Bottom