From the course: SQL for Healthcare Professionals

Unlock this course with a free trial

Join today to access over 25,500 courses taught by industry experts.

What are relational databases?

What are relational databases? - SQL Tutorial

From the course: SQL for Healthcare Professionals

Start my 1-month free trial Buy for my team

What are relational databases?

“

- When thinking about a table in a database, what comes to mind? Think of a table in the same format as a spreadsheet. You have your columns and rows, but most of the time the information needs is stored on different tables. To get information together, you make use of common keys. Each table has common keys that work as links, which allows you to create connections between two or more tables. For example, think about a table that contains the patient demographics, such as name and gender, and another one that contains the patient's medications. You can connect those tables by using a common key, such as patient ID. This allows you to use the database to quickly connect the patient with the respective medication. The databases I structure through normalization, which is the technique that divides the tables into smaller tables and connects them via relationships. These will prevent redundancy and increase data…

Contents