relational database

an electronic data storage structure in which information about different types of entities (e.g., patients, visits, insurance providers…)  is stored in separate tables. Each row in a table is a distinct instance of that entity type and the relationship between entity types / tables is defined by specific rules ( e.g., patients can 1 or more visits; visits can only have 1 patient). Relational data ideally captures more information and keeps it better organized than “flat” data, but it can be less flexible and takes more skill to manipulate.