Posted: July 17th, 2017

You report should also indicate how the database will be used to interact with other systems in the organization.

Domain VI:                                         Leadership

Subdomain VI.K.1:                           Enterprise Information Management

Competency:                                     Apply knowledge of database architecture and design (BL3)

Curricular Consideration:                Data dictionary and interoperability

Objectives:

Explain the concept of data dictionary and interoperability in the process of database implementation and design (VI.K.1- BL3)

TASKS:

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.

• Using Microsoft Word, detail if 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.