Example 1
A simple table to look up a doctor's contact details by ID, first name, middle name or initial, and last name.
ID |
FirstName |
MiddleNameInitial |
LastName |
Extension |
Pager |
Mobile |
|---|---|---|---|---|---|---|
WX3647 |
Virginia |
|
Apgar |
3678 |
23536 |
0210713467 |
WX4754 |
William |
Osler |
Abbott |
6707 |
95673 |
0270685643 |
WX0637 |
Hans |
|
Asperger |
8965 |
23764 |
0218484949 |
WY6855 |
Doogie |
|
Howser |
7689 |
84556 |
0210457276 |
WY8878 |
John |
H. |
Watson |
4666 |
74252 |
0298656455 |
WX5678 |
Mason |
|
Andrews |
3452 |
45666 |
0279976652 |
WX2446 |
Christiaan |
|
Barnard |
12445 |
65256 |
0215588835 |
Example 2
A simple table to look up prescription drugs by brand name, generic name, drug group or type, and condition.
BrandName |
GenericName |
DrugGroup |
DrugType |
Condition |
|---|---|---|---|---|
Xanax |
Alprazolam |
Benzodiazepine |
|
Anxiety disorder |
Zoloft |
Sertraline |
SSRI |
Antidepressant |
Depression |
Aspirin |
Acetylsalicylic acid |
Salicylate |
Pain relief |
Pain, fever |
Prozac |
Fluoxetine |
SSRI |
Antidepressant |
Depression |
Azasan |
Azathioprine |
Antimetabolite |
Immunosuppressant |
Arthritis |
Sectral |
Acebutolol |
Beta-blocker |
Hydrophilic beta-adrenoreceptor |
Hypertension, ventricular arrhythmias |
Accupril |
Quinapril hydrochloride |
ACE inhibitor |
|
Hypertension, congestive heart failure |