Results 1 to 6 of 6
  1. #1
    Join Date
    Jun 2007
    Posts
    2

    newbie design question

    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

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    i'd give you a C+ for that -- you got a lot of it right, but missed a few important facts

    good luck with your "resit"

    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  3. #3
    Join Date
    Jun 2007
    Posts
    2
    Quote Originally Posted by r937
    i'd give you a C+ for that -- you got a lot of it right, but missed a few important facts

    good luck with your "resit"

    why is resit in inverted commas?

    oh well, worth a try

  4. #4
    Join Date
    Jun 2007
    Location
    London
    Posts
    2,527
    Go through each of the sentence in your course work and check to see if your schema represents that correctly. I think you'll pass with what you have but I'd revisit the threads bit if you want a higher mark.

    Mike

    PS Anybody else nostalgic for the days when cheating was done in private rather than on public forums?

  5. #5
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    Quote Originally Posted by joeyjoejnr
    why is resit in inverted commas?
    because it looks like a homework assignment, not an exam
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  6. #6
    Join Date
    Aug 2004
    Posts
    11
    Where are you going to store organiser details?
    Can one organiser moderate several forums?

    What is the relationship between Thread and Response?

    Relationships can be 1:1, 1:M or M:M. How many tables do you need to represent each of these?

    Answer these questions and then look again at your design

    Remember to state your assumptions.

    Andy
    Last edited by andy4000; 07-02-07 at 11:26.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •