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, the identities of all physicians administering the trial, and whether each physician is working on the trial in a paid or unpaid capacity. Regardless of whether they are paid or unpaid, more than one physician can work on a trial, and a physician can work on more than one trial. A physician working for pay on one trial might work unpaid on a different 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.
For both patients and physicians, address information consists of an address, city, state, and zip. Assume that you do have access to a zip code table.
Draw an entity-relationship diagram and write a design outline of the database.