Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2010
    Posts
    4

    E-R and relational model help needed

    Hi,

    I'm new here so I'm sorry if this is the wrong place to post this.

    I'm not too sure on how to represent a model as a client-server system.

    The model I'm designing requires a user to select optional modules from a given list.
    Any help or guidance would be really appreciated. Thank you for your time.
    Last edited by vdgirl; 01-31-10 at 07:10.

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    Quote Originally Posted by vdgirl View Post
    I am unsure whether 'Module' should be an entity
    try creating the ERD both with this as an entity and without it


    Quote Originally Posted by vdgirl View Post
    or if there should by separate 'FirstYear,' 'SecondYear,' 'ThirdYear' entities.
    hint: no


    Quote Originally Posted by vdgirl View Post
    The other entities that I have identified are 'Degree' and 'Student'.
    sounds okay


    Quote Originally Posted by vdgirl View Post
    Also, I'm not too sure on how to represent this model as a client-server system.
    leave this bit to the very end after you have completed the ERD
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  3. #3
    Join Date
    Jan 2010
    Posts
    4
    Hi,

    Thank you for your help
    Last edited by vdgirl; 02-03-10 at 20:27.

Posting Permissions

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