Basic DB Logic Question

[Kineard]

I am trying to write what I think is a pretty basic script.
The coding would be a bit like hot scripts; basically a review system.
I am having problems from the get go with designing the database.
It would look something like this

Genre Table
PK_Genre
FK_URL_ID

URL_Info Table
PK_URL_ID
Site_Name
Site_Address

Site_Description Table
PK_Site_Description_ID
FK_URL_ID
Site_Description
Tag_Line

Site_Review Table
PK_Site_Review_ID
FK_URL_ID
Reviews
Number_Of_Votes
Total_Of_Votes
Rating

Now my question is how does MySQL or any other database know how to relate
thinks together.
Example: I want a Genre to be assigned to a Site_Name.

I am also thinking I have my Rating logic messed up.
Thanks for any help.

[Dan Bracuk]

The answer to:
"how does MySQL or any other database know how to relate thinks together."

is, "you tell it".

If you are going to design databases, learn the fundamentals of data
modelling. Understand the concept of primary and foreign keys.

[Kronin555]

Here's a good tutorial to get you started. Once you work through it, if you have questions, feel free to post back.

[url]http://www.geekgirls.com/menu_databases.htm[/url]