Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2011

    Question Unanswered: Relational database design(first time)

    im making a website so that our school students can post notes from their classes and share them with their friends that are in their classes but im not sure what the table structures would be like to get all this working.

    i have a uml class diagram of what i have come up with for the design tables but im not sure how to make it.

    if someone could please design this for me and post back or pm me the sql code please that would be very helpful indeed

  2. #2
    Join Date
    Apr 2008
    Iasi, Romania
    Provided Answers: 3
    Those class1...class7 fields in the User table are not a very smart idea, as they might impose some undesired future constraints.
    You might want to create another table, named UserClasses (userID, ClassID)
    Also, you may add a noteDateTime field in the Notes table
    Florin Aparaschivei
    DB2 9.7, 10.5 on Windows
    Iasi, Romania

Tags for this Thread

Posting Permissions

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