Domain 4: Relational Database

Page 1

Database Purpose and Activities

The purpose of a database is to store and retrieve data. A popular common language called structured query language (SQL) is used to store and retrieve data in relational databases. SQL gives information systems the ability to query and report on data and to insert, update, and delete data from the database.

Relational Database

Is one of the most popular database architectures used in healthcare. Relational databases perform the following activities:

Store data in tables consisting of rows and columns

Reduce redundancy in tables

Retrieve and store data in tables using SQL to insert, update, delete, and query data from tables

Provide a level of security, usually by user and by table and column that each user is allowed to access.