Re: Newbie Database ER model question
- From: "'69 Camaro" <ForwardZERO_SPAM.To.69Camaro@xxxxxxxxxxxxxxxxxxxxxx>
- Date: Tue, 26 Jun 2007 15:15:42 GMT
Hi, Joe.
anyone know if this is any use?
It's a very good start. However, where were you planning to store each
forum's Web address and each forum's moderator's E-mail address? How do you
intend to sort on last names or group by last names when last names aren't
listed as a column name? (You've tossed multiple items into a barrel, the
database, and don't have a quick and easy way to retrieve a specific item
with a query, which is one of the goals of relational database structures.)
How will the database user know which state, postal code, and country a
member lives in? How do you plan to store posts when the same member posts
two different questions with the same thread title? Is the second one
"attached" to the thread of the first one, even if the discussion or idea it
contains is different from the first discussion on that thread title? How
do you plan to identify the previous message in a thread so that posts in
the same thread can stay together?
You don't need to post back with the answers to these questions, but your
revised ER model should provide a data structure that answers these
questions.
HTH.
Gunny
See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blogs: www.DataDevilDog.BlogSpot.com, www.DatabaseTips.BlogSpot.com
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
info.
"joeyjoejnr" <geoff.agnew@xxxxxxxxx> wrote in message
news:1182859656.683529.53420@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
i've to do an ER diagram and a normalised relational database schema
for this:
"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
.
- References:
- Newbie Database ER model question
- From: joeyjoejnr
- Newbie Database ER model question
- Prev by Date: Frustrated re Line method
- Next by Date: Re: Setting Access user level security
- Previous by thread: Newbie Database ER model question
- Next by thread: Setting Access user level security
- Index(es):
Relevant Pages
|
