Results 1 to 6 of 6

Thread: ER Diagram

  1. #1
    Join Date
    Feb 2010
    Posts
    2

    ER Diagram

    I need to understand how to represent the following in an ER diagram
    If the relational schema is as follows:
    B(X,W,P),where P is defined as NOT NULL,
    C(P,Q)
    D(P,X,R)
    Give an ER diagram for the relational schema. Identify primary keys and constraints.
    Which relation represents an entity, and which relation represents a relationship

  2. #2
    Join Date
    Jun 2007
    Location
    London
    Posts
    2,527
    I think the general idea of coursework is for the student to actually do it rather than just post it on internet forums for others to do.

  3. #3
    Join Date
    Feb 2010
    Posts
    2
    thanks for your invaluable advice, I do have the solution to the problem, however not in complete agreement to it, therefore was looking to see if someone out there had a better way of representing it, didn't want to create a bias by providing the solution, cause given a solution you can justify anything, anyways the whole idea was to understand that if B is an entity and also a relation?

  4. #4
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    Quote Originally Posted by cshib View Post
    I do have the solution to the problem...
    didn't want to create a bias by providing the solution
    okay, we promise to be unbiased

    please post your solution
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  5. #5
    Join Date
    Jun 2007
    Location
    London
    Posts
    2,527
    Quote Originally Posted by cshib View Post
    thanks for your invaluable advice, I do have the solution to the problem
    My pleasure. I guess we're all waiting to see your solution with baited breath.

  6. #6
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    I have a little sympathy with you cshib - that question does not look properly formulated to me.
    However, I agree with the other two - please show us what you have so far and we will comment.
    Testimonial:
    pootle flump
    ur codings are working excelent.

Posting Permissions

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