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

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.

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?

okay, we promise to be unbiased

please post your solution

My pleasure. I guess we're all waiting to see your solution with baited breath.

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.

pootle flump ur codings are working excelent.