Discussion Forum
Student’s Name
Institution Affiliation

Discussion Forum
Question One
The responsibility to design the ER model and ensure that it is regularly updated lies with the database administrator. Rather than focusing on a single department or user, the database administrator assesses overall requirements and maintains the database in a manner that benefits the entire organization (Scott, & Rosenblatt, 2017). The ER model is a systems analyst function and not a clinical analyst function since it entails both development and maintenance and focuses on the entire organization. Decision support models such as the clinical information system strategic planning model can be created and maintained by the clinical team rather than the system team. Clinical teams are teams that provide clinical care (Mosser, & Begun, 2013). Decision support systems are critical to the accomplishment of this objective and so clinical teams should be heavily involved.
Question Two …show more content…
Key fields are an essential part of system design since they facilitate effective organization, access, and maintenance of data structures within the system (Scott, and Rosenblatt, 2017). Primary and foreign keys are examples of the various key fields that can be utilized when designing the system. The primary keys that will be used for the patient data set include patient identification number, name, and date of birth while the secondary keys will be the provider ID number. Provider ID no will be the primary key for the primary physician data set while the patient ID, name, and date of birth will be the secondary keys. The recommended approach is advantageous over the others since it provides the patients with the flexibility to choose various