Thread: plz i need help ((ER diagram))

1. Member
Join Date
Jul 2008
Posts
22
Rep Power
0

plz i need help ((ER diagram))

hi every ine i would like some one to help me with my following ERD problem:

first i want to give you a brief explanation of my database......
every instructor teaches many courses...and each course may contain many sections....besides each instructor has his own question for the course assigned to him...
here is my ER:
instrucor--->teaches>----course---->contains>-----section----->has>----Question

is my ERD correct???if it's not p;z help me!!!:confused:
Last edited by sweet angle; 02-01-2009 at 08:03 PM.

2. Member
Join Date
Jan 2009
Posts
16
Rep Power
0
From where you have learned to make ER diagram like that?

3. Member
Join Date
Jul 2008
Posts
22
Rep Power
0
forgive me that was just a plain text of my real ER...

4. Member
Join Date
Jan 2009
Posts
16
Rep Power
0
It looks right but if you can put the real ER here, it will be more easy to see, and if you can put cardinality here it will make more sense.

instrucor-1-->teaches>-N---course--1-->contains>---N--section---1-->has>--N--Question

There is one thing confusing and that is can we say that teacher teaches many courses and teacher teaches many sections?

because by this diagram it will become difficult to find which teacher teach which section.

5. Member
Join Date
Jul 2008
Posts
22
Rep Power
0
you're right ....i suppose to link each instructor to a spesific section ...
just like the following>>
instrucor-1-->teaches>-N---section--M-->assigned-to>---1--course
also section--1---->contains>----M--Question
is it ok now?
Last edited by sweet angle; 02-01-2009 at 09:54 PM.

6. Member
Join Date
Jan 2009
Posts
16
Rep Power
0
I am 100% sure that your entities are right but cannnot say about the relationships unless you put/copy-paste the real question here if possible.

7. Member
Join Date
Jul 2008
Posts
22
Rep Power
0
thank you very much...i really appreciate your help...i have attached my ER>>thaaankx in advance New WinRAR ZIP archive.zip

8. Member
Join Date
Jan 2009
Posts
16
Rep Power
0
I have check it and find it correct. Good luck.

9. Member
Join Date
Jul 2008
Posts
22
Rep Power
0
W0OoOw ....i don't know what to say:)....thaaaaaanx alot....

10. Member
Join Date
Jan 2009
Posts
16
Rep Power
0

Posting Permissions

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