So now our table will have this information:

- newsid (our primary key)
- title
- content
- author
- approved
- category

Going through the same process for categories we end up with:

- categoryid (our primary key)
- categoryname
- parentcategory

Our authors table structure looks like:

- authorid (our primary key)
- author's name
- author's email address
- author's website url

Our comments table structure looks like:

- commentid (our primary key)
- newsitem
- subject
- comment
- author


So we can see how everything links together (this is called a "relational database" since there are relationships between each of the tables).

As you can see, there is quite a lot to properly designing a database, and we haven't even started creating any tables yet!


Written for Interspire