Dudes, can someone bang this out for me real quick. If you know Access, I'm sure it'll be very easy:
I don't want you to build a database, but instead only list the tables, fields, primary key, and foreign keys I would need to build one...
Design a database for a medical research project that will track specific volunteers and/or specific studies. A study will require several subjects, but a specific person may participate in only one study. The system should also be able to track physicians. Many physicians can work on the same study. A given physician may also work on multiple studies. The system should be able to display all facts about a particular volunteer (subject) such as name, birth date, sex, height, weight, blood pressure, cholesterol level, and so on. It should be able to display all characteristics associated with a particular study; for example, the title, beginning date, ending date, as well as the names of all physicians who work on that study. It should also show whether the physician is a primary or secondary investigator in each study. Show the required tables in the database, being sure to indicate the primary and foreign keys in each table. Indicate one or two other fields in each table as appropriate. (You do not need to list them all).
