Tag Info

New answers tagged

0

Rather than stick with that table, would creating a question table work for your application? That is, instead of having a separate table for each question, have a question table as CREATE TABLE question (question_id numeric, question text) and instead of the AFE table linking to a bunch of other tables, create a separate answers table as CREATE TABLE ...


1

Storing a commma separated list of values clearly violates the "atomic" requirement of 1NF. What you want is a (at least) a 1-to-many relationship. One table to store the product attributes and one table to store the ingredients per product. product (code[PK], manufacturer, name, total_weight) product_ingredient (product_code, name) However this means ...


0

There are some great data cleansing products out there, one in particular that is actually top notch and affordable. I've come across DataMatch by Data Ladder, which is an excellent fuzzy matching and address standardization/address parsing tool used across business and would work really well for this situation. They offer a complimentary trial for new ...



Top 50 recent answers are included