Domain VI: Leadership
SubdomainVI.K.1: Enterprise Information Management
Competency: Apply knowledge of database architecture and design (BL3)
Curricular Consideration: Data dictionary and interoperability
Explain the concept of data dictionary and interoperability in the process of database implementation and design (VI.K.1- BL3)
You have been working with a vendor in the implementation of a new database to track all release of information requests received by your facility. Since you are part of the core team involved in the implementation process, the vendor has requested that you review the data dictionary that will be used as part of the implementation and training for the new database.
Review the table below and validate the information being presented to determine if the data elements selected conform to acceptable “good database design principles.” You must identify any interoperability issues you may anticipate as this database will interphase with other systems used in the organization.
|Data Field||Name||Definition||Data Type|
|Requested name||REQ-NAME||Name of person/entity requesting records||Alphanumeric|
|Patient Name||PT-NAME||Name patient in health record||Alphanumeric|
|Date Received||DATE-RCD||Date Request was received||Date|
|Date Completed||DATE-COMP.||Date Request was completed||Date|
- Using Microsoft Word, detailif any issues you are able to identify within the table presented and discuss any problems you believe could result if this data dictionary is used for training purposes. You report should also indicate how the database will be used to interact with other systems in the organization. If you believe the table presented does not comply with good database design principles, indicate which other fields, if any, you would propose to include in the data dictionary. Explain the reason why you propose these fields.
Standards: Students must achieve a minimum of 70%.
Analysisof proposed table _______/15
Identify issues with the proposed table _______/30
Recommend ways to improve the proposed table _______/30
Demonstrate understanding of interoperability concepts _______/20
Correct spelling, punctuation, grammar and formatting ________/5
Total Points: _______/100