Patient Record System

Jocelyn Garcia, Keri Hawkins, Rolando Javier, Mary McClain

University of Phoenix

Professor Charles Shubert

DBM/381

September 29, 2014

Introduction

• A discussion of health care data collection standards  • Privacy and security risks  

• Other management considerations

• Data management controls   

• Data ownership  

• Protection controls  

• Retention and destruction requirements  

• Disaster recovery and business continuity plans   

Team B will cover the principles of database design and management as follows:

Data Collection Standards

Privacy and Security Risks

• Database Administrator is responsible for preventing risk by

• Limiting access

• Formulating polices

• Enforcing security

• Monitoring data usage for security violations

• Disaster planning

• Archiving

Other management considerations

Data Management Control

Data Ownership

• governance of data - is responsible for and controls specific data sets in the database.

Protection Controls

• Rules and limitations- are implemented to protect unauthorized access or distribution of data.

Retention and Destruction

• Creating and utilizing data is easy; maintaining is more difficult.

• Information is prioritized according to usage.

• Active vs. Inactive data

• Data is eventually destroyed, via methods which make it irretrievable.

• Records of the destruction are required.

Disaster recovery and business continuity plans

Conclusion

In conclusion the proper structure of a database is vital when gathering information and implementing regulations. Regulations set the security and privacy of the information being stored. Database Administrators are responsible for preventing any kind of risks that may corrupt or violate security policies. By enforcing policies, determining access privileges, security planning, disaster planning, and archiving reduces risk factors. Additional functions such as evaluation and selecting of a DBMS, maintenance, training, data dictionary management, database design, testing and performance tuning are all responsibilities a DBA has to control.

Questions?

References9781133691297, Philip J.Pratt(2012) Concepts of Database Management, seventh edition, Cengage Learning. Retrieved on September 8- 29, 2014

American Health Information Management Association. (2011). Retention and Destruction of Health Information. Retrieved from http://library.ahima.org/xpedio/groups/public/documents/ahima/bok1_049252.hcsp?dDocName=bok1_049252

Hock-Chuan, C. (2010). Relational Database Design. Retrieved from http://www.ntu.edu.sg/home/ehchua/programming/sql/Relational_Database_Design.html

Image of data life cycle. Retrieved September 29, 2014from http://libguides.gwumc.edu/c.php?g=27779&p=170351

Introduction to the SQL Procedure, lecture one, MA379Advanced SAS, CIS Courseware. Knowledge System Institute(no date). Retrieved on September 19,2014 from http://green.cs.ksi.edu/dl/ma379x/MA379_L1_1.htm

 Shiflet, A.B. (2002). Entity-Relationship Model. Retrieved from http://wofford-ecs.org/dataandvisualization/ermodel/material.htm