FISI 3152 Bella Capelli A Paul Mitchell Partner School Physics Exam Answers I have physics exam that need to be completed. Will have mxq questions mostly..

FISI 3152 Bella Capelli A Paul Mitchell Partner School Physics Exam Answers I have physics exam that need to be completed. Will have mxq questions mostly………. Database and Data Warehousing Design
Duygu Ulker
Strayer University
CIS499: Information Systems Capstone
Professor Reddy Urimindi
Introduction
Hospital database is created to manage large amounts of data (Einstein, 2018). They also
store data in a structured and organized manner to make it easier for the user to retrieve and manage
data when needed. Quality medical treatment relies on accurate data processing. ERMS is essential
in the medical field because they collect and synthesize medical data. They offer support when
medical decisions are made. Data warehouse helps in feeding slier information to data mats to be
extracted and transformed. Data is periodically extracted and copied to the computer to support
the business process. This paper discusses the development of a data warehouse that fits hospital
operations.
The need for data warehousing within your company
There is a growing need for data warehousing in this in these times of technological error.
Running organizations that depend on data considering the quickly changing business environment
has proven data warehousing to be the surest way to prevail (Lawyer, 2014). Data warehousing
provides the most accurate and reliable method for businesses to access and store structured data.
Data warehousing enhances cross-organizational data access through dashboards, reports, and
analytics tools. Such functions are critical in improving decision making and monitor performance
because they ensure data security. Another reason why data warehousing is greatly needed is that
it ensures consistency. They are designed to apply a uniform format for the already collected data
to make it easier for organizational decision-makers to analyze and share insights other people
around the globe.
Successful organization design data driven strategies and do not depend on decisions made
without consulting about the facts (Shappell, 2017). Data warehousing has improved the efficiency
1
and speed when accessing various data sets as well as making it easier for commercial decisionmakers to stem insights that would guide the organization and ensure marketing strategies that
would make them outstand among the competitors. Data warehousing is critical in allowing
corporate leaders to quickly retrieve and access historical activities of the organization and
assessing initiatives that have been a success in the past. As a result, it is easier to see where
adjustments can be made on strategies such as maximizing efficiency, decreasing costs as well as
increasing sales. Every business would like to have data consistency and quality. Considering data
warehousing collect information from various sources and change it to a widely used format, it
helps to provide results that are inconsistent. When there is data standardization, the data
warehouse will help in improving confidence and accuracy hence enhanced decision making.
The schema that supports the company’s business and processes
The utilized data-based design will be used in managing significant bodies of data. In this
database, four tables will be available in the software used in storing all records (Shappell, 2017).
The fields used in the databases will have two data types, namely integer, which has the character
of (+ or -) and is followed by another digit (0-9). The other type of integer is the varchar used in
storing alphanumeric characters. Such character is utilized in setting maximum character number
up to 8000 rangers. Another integer that would be used is the Date/Time, which represents time or
data. The tables below show the schema that would support the business operation of the company.
2
Management system
Patient table:
Doctor table
Lab table
3
Bill Table
Entity-Relationship (E-R) Diagram relating the tables of your database schema
E-R diagrams are used in the modern database to depict database structure. It acts as a
relational schema modeling method utilized in designing a system and approach (Einstein, 2018).
The entity-relationship diagram shows various relations among entities bearing in mind each
object is an entity. The diamond shape represents the entity, while the relationship represents a
rectangle. They show the relationship between data objects. On the other hand, the E-R diagram
depicts a relationship used to conduct the activity of data modeling. The system entity is used to
store data. It acts as an elementary building block for storing data of the organization’s process.
Relationship, on the other hand, is an association that relates many entities in common attributes.
Attributes, on the other hand, refers to entity and relationship entity. Attributes act as a simple
piece of data that is attached to an entity. The table below shows the E-R Diagram.
4
Hospital management system
Data Flow Diagram (DFD)
The DFD shows the data flow through the information system, and it visualizes how the
information is handled in the system based on inputs and outputs (Lawyer, 2014). It represents the
flow of data and analyzes the processing in the architectural project. The DFD will visualize the
functions and processes, data flows, depositories, and external entities. DFD aids in assessing and
modifying organizational systems. It creates a system overview to show significant steps of inhospital processes. The DFD will have a system where data is collected during the admission. The
collections include the admission information and the data of the medical team carrying out the
admission. There will be a system responsible for diagnosis where patients complain are identified
then checked to determine the diagnosis. In the system, treatment plans will be established where
registration and operational data are entered. When the cases are not extreme, patients will be
discharged as outpatients and the information generated.
5
Illustrate the flow of data including both inputs and outputs
In the administrative module, the patient’s username and password are entered to log in to
the system (Einstein, 2018). If the login is entered successfully, the administrator could view and
update the patient’s record. The data process is different between the outpatient and inpatient. In
the input, information login is entered to provide the output, which is the patient’s data, which are
used for billing and reports. In the output, the administrator determines whether the patient would
6
be admitted or treated as an outpatient. In the lab module patient’s detail is entered, and laboratory
reports provided where payment is conducted. In the billing module, bills are calculated and
Charges are deducted where card facilities are operational.
The system would support the businesses and processes of the company. It would act as a
central data repository feeding subnets to data marts (Shappell, 2017). The data in the system will
be altered directly. In administrating data, there will be maintenance duality data exposure. The
data administrators would manage the application of data in tracking exposures. The system, on
the other hand, would access historical and aggregate data with a small amount of time. The system
will ensure the decision and operational support application helps in focusing on the best
functionality and performance. Data organization is enhanced for the column- sloping processing.
Data is collected from various sources, where it is transformed and loaded in the warehouse. The
utilized data model used is the dimensional model, and it is featured by a fact table where it is
attached to smaller dimensional tables. Every row in the fact table stands for the organizations
event in the business. The fact table represents temporal information.
Conclusion
The projected DFD’S are effective in enhancing communication between system designers
and users (Lawyer, 2014). It creates a good background in designing EMRS to manage and capture
data through interfaces developed during the patient’s visits. The system will be critical in
providing the medical practitioner with capability to interact with the system through interfaces
hence improved medical care. The system stores the medical history and prescribed medication.
7
Sources
1. Einstein, A. (2018). Hospital Management System DATABASE DESIGN. Retrieved
from
https://www.academia.edu/15098449/Hospital_Management_System_DATABASE_DES
IGN
2. Lawyer, J. (2014). Best Practices in Data Warehousing to Support Business Initiatives
and Needs Jeff Lawyer and. Retrieved from
http://citeseerx.ist.psu.edu/viewdoc/summary?doi=10.1.1.97.9923
3. Shappell, F. (2017). Data Warehouse. Retrieved from
https://www.sciencedirect.com/topics/economics-econometrics-and-finance/datawarehouse
8
Appendix
Data Flow Diagram
9
E-R Diagrams
10
The Infrastructure of the Electronic Records Management System
Duygu Ulker
Strayer University
CIS499: Information Systems Capstone
Professor Reddy Urimindi
The integration of the Electronic Records Management System in health care services is a
boost to the achievement of delivering quality services to the patients. The system will help in
the ease storage and retrieval of information in the health care services. The efficiency and
ability to have quality services are tied to the effectiveness in the research that the nurses or the
physicians may conduct regarding particular practices. Researches are conducted to establish the
most effective approach in healthcare services. Thus, there is a need to have stored data that can
be referred to when a need arises. A comparison of data makes the decisions made by the
management to be smart and effective as they are data-based. With the recommendation of using
ERMS, there is a need to consider the security measures in the development plan. The measures
will include the inclusion of the authentication features, including the error detection approaches,
and educating the users on the system’s basics.
The system will use the WAN network system to give away for any link that may be
required with the external institutions. In order to ensure the authenticity of the data in the
network, there will be installing and testing the firewalls (Rezaeibagha, Win, & Susilo, 2015).
Firstly, the firewalls will help in the monitoring of the traffic joining the network. Considering
that the institution will have to transit from the previous paper works and insignificant reliance
on a computer to extensive use of the internet-based services, the presence of Trojans can expose
sensitive details. Exposure can be a threat to the system’s effectiveness, as most of the
stakeholders will lose confidence in it (Bain, 2015). Considering that data is sent in packets,
firewalls are useful in assessing if the individual packets have any hazardous elements. The
firewall will, thus, protect the system from being infected with Trojans and viruses that may
interfere with the functionality of the system. The firewalls will police the system by blocking
Trojans. Secondly, the firewalls will block any unauthorized users by denying them access to the
1
network (Rezaeibagha, Win, & Susilo, 2015). In that way, the system will be free from the
potential cyberattacks. Lastly, the firewalls will help in the authentication of the software
installed to alert malware that can lead to an incidence of keylogging.
The three primary stakeholders are the nurses, the management, and the licensed
researchers. In order to ensure that the access to the system is only privileged to the mentioned
stakeholders, the system will apply the multilevel security system. The multilevel security
system helps in the authentication of the users to ensure that anyone trying to access particular
information is authorized. In that way, the system will guarantee the safety of the users and
patients whose data will be entered into the system (Bain, 2015). The multilevel security system
will also help in tracking the respective stakeholders’ performance to assess the system
(Rezaeibagha, Win, & Susilo, 2015). Anyone will be prompted to create an account to access the
system through the network. After the capture of the details, it will then be left for the
administrators to verify the provided information to give the go-ahead. Additionally, the
administrators will have the power to suspend any account that portrays suspected activities.
Equally, any of the devices connected to the system via the internet will have to be registered
through the recording of its MAC address (Rezaeibagha, Win, & Susilo, 2015). In that way, the
management will be sure that any gadget requesting access is recognized since all devices have
unique MAC addresses.
With the increased uses of the internet, there is also increased expertise in hacking from
malicious groups. Thus, in order to clear the doubts from the system users, there is a need for
implementing error detection measures to ensure that the data transmitted is received with its
authenticity (Bain, 2015). Most of the data are transferred in binary forms. The error detection
approaches will help in assessing if the arrangement of the 1s and 0s is as per the initial impulse.
2
In that way, the management will be able to detect any hacking activities and take immediate
action before damage is caused. Through the sustenance of the data’s authenticity, all the
stakeholders will lay their trust in the processes giving a better chance of improving the system
to meet any new challenge that may occur. The improvements are highly achievable when the
developers get feedback from the users.
Most of the stakeholders may lack a comprehensive understanding of how the system
works. In such a situation, there may happen some recklessness that leads to an increased threat
to system security. Thus, it will be necessary to train all the stakeholders to ensure that they are
aware of the potential threats and how to mitigate them. Firstly, the malware cases can be
mitigated by enlightening the stakeholder on the possible effect of the malware and how to
overcome (Bain, 2015). The primary step of countering the malware is through ensuring that all
of the installed software is verified. Thus, despite the firewall presence, the initial step of making
the stakeholders understand the safety measures they should apply can help increase the
guarantee of data security (Bain, 2015). Secondly, educating the stakeholders will ensure that
they fully understand their responsibility regarding the security of the system (Rezaeibagha, Win,
& Susilo, 2015). Equally, the system will be updated as the agreement and as per the demand in
the market; thus, regular tutoring will be necessary to ensure that the users are having smoot time
in using the system. Therefore, educating the users on the functions that have been modified and
what is required of them will increase efficiency in the system (Rezaeibagha, Win, & Susilo,
2015). The efficiency will be by overcoming the drawbacks that may be caused by the
knowledge gap, where the users do not comprehend how to use the system.
In conclusion, the security of the system is determined through the involvement of all
stakeholders. The integration of the Electronic Records Management System in health care
3
services is a boost to the achievement of delivering quality services to the patients. The system
will help in the ease storage and retrieval of information in the health care services. The system
will use the WAN network system to give way for any link that may be required with the
external institutions. However, to ensure the authenticity of the data in the network, there will be
installing and testing the firewalls. The three primary stakeholders are the nurses, the
management, and the licensed researchers. In order to ensure that the access to the system is only
privileged to the mentioned stakeholders, the system will apply the multilevel security system.
The multilevel security system helps in the authentication of the users to ensure that anyone
trying to access particular information is authorized. In that way, the system will guarantee the
safety of the users and patients whose data will be entered into the system. With the increased
uses of the internet, there is also increased expertise in hacking from malicious groups. Thus, to
clear the doubts from the system users, there is a need for implementing error detection measures
to ensure that the data transmitted is received with its authenticity.
4
Sources
1. Bain, C. (2015). The implementation of the electronic medical records system in health
care facilities. Procedia Manufacturing, 3, 4629-4634.
2. Rezaeibagha, F., Win, K. T., & Susilo, W. (2015). A systematic literature review on
security and privacy of electronic health record systems: technical perspectives. Health
Information Management Journal, 44(3), 23-38.
5
Project Deliverable 2: Business Requirements
Duygu Ulker
Strayer University
CIS499: Information Systems Capstone
Professor Reddy Urimindi
0
Describe and define the scope of the project
The scope of the project is a web-based system that is used to collect data. The system will
analyze the reaction of the website (Arthur 2018). The system will operate as a full-service research
website. It will provide innovative and creative research solutions with efficiency and quality.
When others subscribe or register to the site for the first time, they will be filled out. In such cases,
the company enquires about the name, emails and other demographic information. The operation
and analytical system will be replaced by this system, where it will be targeting services like
Facebook Pixel, Google Display Network, and Google Adwords to collect data. The web-based
system will use such services to access data from profiled customers.
The system will be able to collect data according to the needs of its customers. It will use
three ways to collect the data; by asking directly, indirectly tracking, and acquiring data from
companies (Ardagna, Francalanci, and Piuri, 2017). There will be changes in the physical and
logical design of the existing database. The actual implementation of the new system will
incorporate a search engine obtained as a purchase component. The internal information will not
be part of the project. Moreover, website security, as well as password detection, will not be part
of the system.
Speculate as to how to control the scope
In controlling the scope, the management will ensure qualified workers are working on the
system (Arthur 2018). The workers will have essential skills required to bring the system to speed.
The project manager will supervise and ensure transformation of the system. Work performance
data will be used to manage the progress of the project. The project manager will monitor
performance of the project to control the development of the system. Workers’ input will be
analyzed and integrated for a good foundation project decision. This will help to implement change
1
after planned and actual results are compared. The change will help expand and direct the project.
Moreover, the risks associated with the project will be analyzed. The risk register will be used to
provide details on opportunities and threats that might occur in the execution of the system. As the
project concludes, the project manager will undertake project audits and evaluations.
Identify possible risks, constraints, and assumptions.
Risks
This project has various risks that range from cost and scope overruns. The project
manager has to manage the risks to stop them from affecting the project (Ardagna, Francalanci,
and Piuri, 2017). The first risk associated with the project is scope risk. Scope risk is associated
with software and hardware defects, integration issues, and dependencies change. Another
associated risk includes unexpected delays, estimation errors, natural factors and scheduling risk,
which provides unexpected delays. Resource risk is related to personnel and outsourcing issues.
Various employees will be associated with this projec…
Purchase answer to see full
attachment