preview

Integrity : Integrity And Integrity

Good Essays

Integrity constrains provide a way of ensuring that data are entered or updated in a database by authorized users do not result in a loss of data quality. Integrity constrains could either be a specification of uniqueness for values of column (for example, only allowing the input of “M” for male or “F” for female in the gender field) or validation for values of a column (for example, allowing only a specified range of values for a field that records a patient’s temperature. Integrity Constrains Referential integrity is another strategy that is used to ensure data quality in relational databases. Referential integrity ensures that there is consistency between tables that are linked in the relational database. HIM professionals are frequently involved in helping to develop integrity constraints in a database. Database Management Systems Database management systems (DBMSs) fail into two categories: a personal DBMS, which runs on a client; and a server-based DBMS, which runs on a server. Personal DBMS A personal DBMS is used for small projects such as storing contact information (for example, in a personal address book). It should not be used for systems that require large amounts of storage and 24/7 access. Database Management Systems Most healthcare systems would not use a personal DBMS. Personal DBMSs are tempting to use because (1) they are inexpensive and (2) most people already have access to one with an office software package such as Microsoft Office. Microsoft Access

Get Access