Chapter 14. Creating a Simple Discussion Forum

Although the ultimate goal of this hour is to create a simple discussion forum, a majority of the hour is devoted to understanding the thought processes behind designing an application using a relational database.

In this hour, you will learn

  • Three types of table relationships

  • How to normalize your database

  • How to implement a good database design process

  • How to create the tables, input forms, and display of a simple discussion forum

Types of Table Relationships

Table relationships come in several forms:

  • One-to-one relationships

  • One-to-many relationships

  • Many-to-many relationships

Types of Table Relationships

Figure 14.1. The employees and ...

Get Sams Teach Yourself PHP, MySQL™ and Apache in 24 Hours now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.