• I will also add that doing your conceptual design, logical design and physical design and actually drawing it out can and will help you a ton. When you do the conceptual model, you can just put stuff down as it is logical in your head and not necessarily in a "database" architecture. This helps you to understand how the eventual database will look and how every object will relate to each other. It lets you get all of your data elements out there and its just visually easier to see a way ahead when you do the modeling. Ultimately, this will also help you determine your one to one joins and one to many etc... as the other posters have already given you a great head start you could now take that and do your modeling.

    If this is unfamiliar then there is a lot of great information on google if you type "conceptual database design"