DIAGRAMMING A DATABASE DESIGN
Ajiri123
DatabaseDiagramTemplate.docx|
Demographics Table (name of table) |
|
|
Field Name |
Data Type |
|
MR Number |
Number |
|
First Name |
Text |
|
Last Name |
Text |
|
Date of Birth |
Date & Time |
|
Active |
Yes/No |
One to many relationships. One person (demographic table) may have many allergies (allergy table)
|
Allergy Table |
|
|
Field Name |
Data Type |
|
MR Number |
Number |
|
Generic Medicine Name |
Text |
|
Reaction Type |
Text |
|
Date of Reaction |
Date & Time |
|
Reaction Level |
Text |
Show the relationship between the tables.
