5
Relational databases
Description
In relational database management systems (RDBMS), data is stored in a
tabular form of columns and rows and data is queried using the Structured
Query Language (SQL). Each column of a table represents an attribute, each
row in a table represents a record, and each field in a table represents a data
value. Relational databases are so popular because 1) SQL is easy to learn and
use without needing to know the underlying schema and 2) database entries
can be modified without specifying the entire body.
REL ATIONAL
Patient
x Patient ID
First Name
Last Name
Gender
DOB
x Doctor ID
Visit
x Visit ID
x Patient ID
x Hospital ID
Date
x Treatment ID
Medical Treatment
x Treatment ID
Procedure
How Performed
Adverse Outcome
Contraindication
Doctor
x Doctor ID
First Name
Last Name
Medical Specialty
x Hospital Affiliation
Hospital
x Hospital ID
Name
Address
Rating
Example: Relational Database Schema