Why do you need a database for a forum?
So the database needs to support information about people or users, conversations or threads and messages or posts. For the online forum, users will need to be created – it might be necessary to allow users to edit their details after they have been created, but there is probably no need to allow deletion of users.
What should I consider when designing a database?
Understanding the purpose of your database will inform your choices throughout the design process. Make sure you consider the database from every perspective. For instance, if you were making a database for a public library, you’d want to consider the ways in which both patrons and librarians would need to access the data.
How to gather information before creating a database?
Here are some ways to gather information before creating the database: Start by gathering any existing data that will be included in the database. Then list the types of data you want to store and the entities, or people, things, locations, and events, that those data describe, like this:
Do you have to register for a forum?
Most forums require users to register and subsequently log in to post messages. However, on most forums, users do not have to log in to read existing messages. These are common requirements for a website forum, so let’s work to make a database model starting with a basic forum setup which we can extend later.
Is there a relationship between posts and threads?
The answer to both is probably yes. Posts are linked to threads and posts are created by users, so there will be a defined relationship between users and posts.
What do you mean by online discussion forum?
His experience spans various disciplines ranging from architecture and design to product management and sales. An online discussion forum is a site where people can hold conversations in the form of posted messages. Discussion forums allow conversations to take place when people are not on-line, and messages may be temporarily archived.