The goal of this project is to design a database to support a web based discussion board.
The board is to allow threaded discussions. Users can register, or not register. Registered users can rank threads. The users can have a signature file and a link to their own web site. Users are grouped into three categories; regular, advanced and admin’s. Admins can delete threads, advanced can only delete responses. Deleted threads and responses are only hidden, they are never actually deleted. The IP, date, time and user, for each response must be stored in the database. Each thread can be marked with a category, and each user can set up a default listing of categories they want to view.
Design the database. Give a list of the tables and a data dictionary of rules and field specifications. You must also set up needed views of the data. Theses views must include the following:
A users view, that shows the user info, and their settings.
A multi-thread view, that shows threads that a person is interested in.
A single thread view, which shows a thread and the responses to it.
An admin view of each that shows the hidden threads and responses.
You must insert enough data to show the workings of the views.
A listing of the tables and their data is also to be included. This is to be turned in on paper, but to make sure it works you should create the database in electronic form.
A discussion forum will be created in Blackboard for any questions.