I just don't get databases

I understand simple databases, when there's a 1:1 mapping of information. But if there's a 1:M setup, I'm not sure the best way to implement my tables. Can someone please point me to a good source? Thanks in advance.

Database Design for Mere Mortals
(A hands on guide to Database design)
isbn 0-201-69471-9

A book would be a great start. You might also get "SAMS Teach Yourself SQL in 10 Minutes." It's a tiny book with just the basics of SQL language and db design.

The key for me has been to sketch the data and see where the tables should be defined. For example, I have a phone book directory of people and companies. One company would likely have multiple people there, so I keep all the company info in table_company, and the personal info in table_person. Then, I add one field to table_person called companyID to link the two.

I hope this helps more than adding to the confusion. Get that book though -- it's saved me a number of times.