Reference no: EM132122327

You work for a pharmaceutical research consortium that operates clinical trials for a variety of new medications. Each trial has a name, a date started, and a completion date. Each trial has a large number of patients, for each of whom you would like to store first name, middle name/initial, last name, phone number, address information, birth date, gender, and date of admission to the trial, along with the patient's height, weight, blood pressure, and cholesterol level at the date of admission. Each patient is allowed to serve in only one trial. For each trial, you wish to store a name, a date started, a completion date, and the identities of all physicians administering the trial. More than one physician can work on a trial, and a physician can work on more than one trial. For each physician, you want to store first name, middle name/initial, last name, employing institution, the institution from which they obtained their degree, phone number, e-mail, and address information.

Draw ER diagram and write a database design outline for a database appropriate for this information.