i've to do an ER diagram and a normalised relational database schema for this:
Quote:
Five volunteers have organised a community website for discussion of topical
issues. They wish to build a relational database to support approximately
twenty discussion forums. Each forum will be moderated by one organiser
who will ensure that all messages posted to the forum are appropriate. The
database must store the name and web address of each forum and the name
and e-mail address of its moderator.
Community members will provide their name, address and e-mail address
and choose a username and password which is stored in the database. The
website will ensure that each username is unique. Members will be asked to
register separately for each forum they wish to participate in. The database
must store the date on which a member joined the website and the date on
which he/she registered for a forum.
Members will be able to start new threads of discussion or post responses
to messages in the forums for which they have registered. Each thread will
be given a title by the member who starts it. The date and time when the
thread is started will also be stored in the database. Each message which
does not start a thread will be posted in response to a previous message.
Apart from the date, time and text of the message, the database must record
the username of the member who posted the message and the identifier of
the previous message.
|
it is for a coursework resit and unfortuately i am crap at databases. i was thinking of creating four tables:
Members - Name, Street, City, E-mail,
username, password, date joined
Forum -
ForumID, ForumName, moderator
Forum Memberships -
ForumID*, Username*, DateRegistered
Threads -
ThreadTitle*, Username*, Time, Date, Text
anyone know if this is any use?
thanks
dBforums
>
newbie design question
06-26-07, 07:28
Linear Mode
