How should I design my MySQL database?

Posted: asked May 19 at 4:07 - Source : stackoverflow

I recently read about relational database normalization for the first time and I was wondering how best to design my database. If each entry has a url, some text, and a list of probabilities, what is the best way to normalize my database? I was thinking one table with columns id, url, and content, and another with id, probability, and foreign_key_id (referencing the first table), but as an SQL novice I don’t know if this is the best approach, especially since the second table would end up having several times as many rows as the first.