December 7, 2006 at 4:46 am
Hi guys, I am generating new scripts for novice users of SQL to use and was wondering if anybody had an opinion on the best way of producing the tables for my team to work on.
Steps:
- Create table with Raw Supplier and address info
- Clean Data
- Add clean data to Raw Supplier Table with additional fields, i.e. Clean_add_1, Clean_add_2
OR
- Create Clean_Supplier Table with only clean data & should they need the original Supplier table they can match back on Supplier_ID
Any suggestions on which method to use and why? Also, when running queries would it be better to have all the data in one master table or in various tables and do joins.
Thanks in advance.
December 7, 2006 at 4:59 am
If I read your question correctly, what you're really asking is a modeling question.
There are tons and tons of material written on datamodeling, and there is no simple answer that fits all.
It's one huge 'it depends' all over the place.
I suggest you try googling some, to get some overview on datamodeling, tables, entitys, joins etc...
/Kenneth
December 7, 2006 at 5:31 am
Read this. They platform they are using is mysql but the theory is identical for all RDBMS and it has a nice worked example
http://dev.mysql.com/tech-resources/articles/intro-to-normalization.html
This is a bit more advanced
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply