ABC is a pharmaceutical company that recruits volunteers for clinical trials on drugs currently under development at the company. The company conducts multiple clinical trials concurrently. Each clinical trial is assigned a trial code together with description of the clinical trial, start date, end date, and the lead scientist. Each clinical trial involves at least one treatment, and each treatment belongs to only one trial. Treatment has its conduct date. When volunteers sign up for a treatment of a clinical trial, their contact details including full name, address, contact number, email address, as well as their unique volunteer number are recorded. Each volunteer is involved in at least one treatment, while each treatment is tested on at least 30 volunteers. In addition, medical details for each volunteer including weight, height, blood type, race, gender, and medical condition are also recorded separately. At each treatment each volunteer involves a specific drug of certain type, for which drug dosage and effects (positive or negative) are recorded. Drug information recorded separately includes drugCode, drugName, type and productionDate. Draw an entity relationship diagram using UML notation (textbook version) for the scenario, specifying all attributes, relationships, multiplicity, and primary key for each entity. Label primary key as {PK} and part of primary key as {PPK} if any.
ABC is a pharmaceutical company that recruits volunteers for clinical trials on drugs
currently under development at the company. The company conducts multiple
clinical trials concurrently.
Each clinical trial is assigned a trial code together with description of the
clinical trial, start date, end date, and the lead scientist. Each clinical trial
involves at least one treatment, and each treatment belongs to only one trial.
Treatment has its conduct date.
When volunteers sign up for a treatment of a clinical trial, their contact details
including full name, address, contact number, email address, as well as their
unique volunteer number are recorded. Each volunteer is involved in at least
one treatment, while each treatment is tested on at least 30 volunteers.
In addition, medical details for each volunteer including weight, height, blood
type, race, gender, and medical condition are also recorded separately.
At each treatment each volunteer involves a specific drug of certain type, for
which drug dosage and effects (positive or negative) are recorded.
Drug information recorded separately includes drugCode, drugName, type
and productionDate.
Draw an entity relationship diagram using UML notation (textbook version) for the
scenario, specifying all attributes, relationships, multiplicity, and primary key for each
entity. Label primary key as {PK} and part of primary key as {PPK} if any.
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 1 images