Draw e-r diagram when doctor prescribe drugs for patients

Assignment Help Software Engineering

Reference no: EM1368867

Design an E/R diagram for the following situation: Doctors prescribe drugs for patients. A given doctor can prescribe many drugs for a certain patient. Sometimes a doctor may not prescribe any drug to a patient. Many doctors can treat a patient. Many doctors can prescribe the same drug to the same patient. A prescription can involve more than one patient (e.g., a mother and her baby) and more than one drug, but is associated with a unique doctor.

This problem may be trickier than it appears. Carefully consider what the instances of each entity set and relationship in your E/R diagram will look like.

Reference no: EM1368867

Questions Cloud

Explain which statistical analysis appropriate : Explain and distinguish which statistical analysis you would conduct and which appropriate test or test statistic should be used.

How far away is the milky way from our nearest neighbour : How far away is the Milky Way from our nearest neighbour, Andromeda Galaxy, if Andromeda contains roughly the similar number of stars and attracts the Milky Way with a gravitational force of 2.4 x 10^30 N.

Minimizing unemployment rate : Discuss should the government minimize unemployment rate? What will happen if the unemployment rate is too low?

Compute the density of the fluid : A cube of ice is taken from the freezer at -8.4 and placed in a 104 aluminium calorimeter filled with 322 of water at room temperature of 20. The final situation is observed to be all water at 17.

Draw e-r diagram when doctor prescribe drugs for patients : Draw the E/R diagram for following situation: Doctors prescribe drugs for patients. A given doctor can prescribe many drugs for a certain patient.

Question about supply and demand : Assume you are the manager of a California winery. How would you expect the following events to affect the demand or quantity demanded for your product?

What is the purpose of a survey : What is the purpose of survey and Check out this answer to get the full answer for the purpose of a survey

Explain what should the new organizational structure : Explain What should the new organizational structure look like and Where should the systems manager put each manager

Calculate the speed of toy car after the collision : A toy car X of mass .200 kg moves along a frictionless surface with a velocity of .180 m/s. It collides with another toy car Y, with the mass .250 kg and a speed of .130 in the same direction.

User Account

All Pages