Database Records and Relational Data Worksheet

1 Sofia Yakaria Pallares live in California. Her patient number is 10259.

2 Sofia’s provider that’s Ruth Ann Raymond, her credentials given as MD

3 John Peters was seen on 11/05/2010. His date of birth is given as 5/25/1965

4 Lucy Ann Johnson born on 06/12/1975. Seen by the Doctor on 06/04/2011

5john Peters live on 1704N on Atlantic Avenue in Ontario, AZ. His encounter number is 111218

Part B: Database records

1. The database is used to store and retrieve data, it’s housed in a database server and is majorly controlled by a database management system. It contains several components that include; Tables that are used to store data within the database, Indexes make data retrieval faster; Triggers are special instructions that are executed when important events such as updating records in table occur. Views are relationships between the database tables becomes complicated they allow the database administrator to create pre-built queries while stored procedures are programs stored in the database to process logic, loop through records and perform conditional comparisons.

2. Regional database is a digital database whose organization is based on the relational model of data. Several software systems are used to maintain the databases are known as a relational database management system, while structured query language maintains and queries the database. The model organizes data into several tables of columns and rows. The rows represent the type of entity while columns the values attributed to instances provided by the rows. Each row has a unique key; this is done by linking rows by adding columns of unique keys to every linked row.

3. The digitization of healthcare industry has added an advantage; the most commonly used system is the online transaction processing database. It serves to replace documents, files in that it’s more convenient and immediate. It allows for quick and real-time transactional processing. The database structure accommodates the creation of wide range applications that include: lab systems, financial systems, education, patient identification, billing and payment, EHRs and ADT tracking. It has led to prevention of data loss in that it can either be stored externally or backed up. Huge data stored provides for better and cost-effective health care.

References

Paton, N. W. (Ed.). (2012). Active rules in database systems. Springer Science & Business Media.

Shortliffe, E. H., & Cimino, J. J. (2013). Biomedical informatics: computer applications in health care and biomedicine. Springer Science & Business Media.

Koh, H. C., & Tan, G. (2011). Data mining applications in healthcare. Journal of healthcare information management, 19(2), 65.