Conversion of statements to E-R Diagram Examples

statements are

Example 1 :

"A teacher can teach many courses. A student can enroll in many courses. A course may be a part of one or many programs  A teacher can be mentor of many students, however a student can have only one mentor."

The solution to above Question can be found Here

Example 2 :

Patients are treated in a single ward by the doctors assigned to them. Usually each patient will be assigned a single doctor, but in rare cases they will have two.

Heath care assistants also attend to the patients, a number of these are associated with each ward. 

Initially the system will be concerned solely with drug treatment. Each patient is required to take a variety of drugs a certain number of times per day and for varying lengths of time.

The system must record details concerning patient treatment and staff payment. Some staff are paid part time and doctors and care assistants work varying amounts of overtime at varying rates (subject to grade).

The system will also need to track what treatments are required for which patients and when and it should be capable of calculating the cost of treatment per week for each patient (though it is currently unclear to what use this information will be put).

The solution to above Question can be found Here

A Good Tutorial on E-R Diagrams can be found Here

Best Tool to Draw E-R Diagrams Online with Shared Support( Multiple users on different computer or screen can work on same diagram ) Visit Here