hello everyone how r u doin?
so some teacher ask me to do a project ,when i start drawing the er diagram for my project i got confused in something.
it says in the project that 'a course can be taught by many doctors, if it has more sections '
so i came up with two solutions and iam not sure about them
the first one is :
that i draw two entity the doctor and course and an entity realtion between them (section)

or my secound solution is i just draw two entity doctor and course and a one to many relationship
so which one is right or if they are wrong can u help me ?

--------------------------------------------------------------------------------

Sounds more like:
COURSE has one or more SECTION. SECTION belongs to a COURSE. SECTION is taught by a DOCTOR. DOCTOR can teach more than one SECTION.


-A

You could make two entities, teacher and course. The relationship could be:
Each course is taught by one or many teachers. Each teacher teaches one course (you need to make sure that a teacher teaches only one course). Alternatively I think you could also make subclasses.

You could make two entities, teacher and course. The relationship could be:
Each course is taught by one or many teachers. Each teacher teaches one course (you need to make sure each teacher teaches only once course). Alternatively I think you could also make subclasses.

Check the attached image...that's sorta what I had in mind based on your requirements

architect, two comments:

1. don't just hand him the homework assignment, make him do it

2. you left out the doctor entity

I'll be more careful in the future when helping newbies

I'm assuming by Doctor, he meant teacher/professor, so the Teacher entity covers that requirement

-A

hey thanx guys and r937 he didnt hand me my homework its like what i had in mind and the the drawing is the easy part