Please suggest me the best way to design my database.
- by Raymond Ho
I have a table named "Pages" and a table named "Categories". Each entry of the table "Pages" is linked to the table "Categories". The "Categories" table have 5 entries, they are: "Car", "Websites", "Technology", "Mobile Phones", and "Interest".
So each time I put an entry to the "Pages" table, I need to map it to the "Categories" table so are arranged properly.
Here's my table:
Pages
______
id [PK]
name
url
Categories
______
id [PK]
Categoryname
Pages2Categories
______
Pages.id
Categories.id
So my question is, is this the most efficient way to create this kind of relationships between tables? It seems very amateur