troubleshooting Question

How do I normalize an mysql database?

Avatar of slavenweb
slavenweb asked on
MySQL Server
18 Comments2 Solutions403 ViewsLast Modified:
Hi,

I need a database table with about 10 fields that would represent products characteristics. Now, there can be products of the same name but with different codes, i.e. article Shoes under code A2345H and G1232E. What method should I use to somehow connect the products in the MySQL database? Also, considering the 10 fields, is it better to somehow divide the data into multiple tables and use foreign keys to connect them?
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 2 Answers and 18 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 2 Answers and 18 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros