System Analysis and Design: Database for Hospital Management System

This report provides a comprehensive analysis and design of a system for a medical center, detailing the acquisition strategy, architectural design, and user interface. It includes a homepage and new patient registration interface designs, business process models using BPMN 2.0, program design, and physical data storage design. The acquisition strategy focuses on integrating multiple centers into a single system to store data and generate reports, while the architectural design explains the database's functionality. The user interface design includes patient and administrator access, and the BPMN 2.0 models illustrate processes such as patient card retrieval and prescription handling. The program design outlines network skills development and entrepreneurial ventures. Physical data storage design separates physical and logical structures, ensuring efficient data management. The report concludes with a bibliography of relevant sources.

Running head: SYSTEM ANALYSIS AND DESIGN
SYSTEM ANALYSIS AND DESIGN
Name of the Student:
Name of the University:
Author Note

1SYSTEM ANALYSIS AND DESIGN
Table of Contents
An acquisition strategy..........................................................................................................................1
An architectural design..........................................................................................................................2
User Interface Design............................................................................................................................3
Homepage..........................................................................................................................................3
New Patient.......................................................................................................................................4
Business process models using BPMN 2.0............................................................................................4
Program design......................................................................................................................................6
Physical data storage Design.................................................................................................................7
Bibliography..........................................................................................................................................8

2SYSTEM ANALYSIS AND DESIGN
An acquisition strategy
The acquisition strategy will help to understand the major needs of the organization and
business requirements. The organization has expanded a lot in last four years and aims at expanding
their business in a number of centres. The organization is basically a single centred organization. In
order to expand the business there is a need for new system that will help in proper development of
the communication system within the organization. Apart from this the system will also be able to
address the need of integrating the centres within a single system that will be able to store every data
regarding to the organization. This will help in generating the reports based on the working of the
organization. Business has adopted values that will be able to provide the customer with online
facilities. This will help in making the treatment process offered by the organization easier and will
increase the customer satisfaction level proper towards the organization. This will minimize the time
that is needed for providing proper service towards the customers. Thus efficiency level will increase
with proper implementation of the system. However the major issue that is faced with the working of
this system is that customers will not be able to access all the functions offered by the system. Apart
from this certain details will be available only to administrators. Before implementing the new system
it is important to have a proper feasibility analysis. The feasibility analysis includes analysing the
technical parts and determining the proper organizational feasibility. Technical feasibility includes
implementing proper measures that will help in the growth of business. This will help in the
development of the storage facilities within the organization. Thus it will help the organization too be
technically feasible. Organizational feasibility will help in increasing the communication system on an
overall base. This will help in making the project feasible from the organizations perspective.
Apart from all the factors affecting the implementation of new system it is important to ensure
that proper requirement is implemented within the organization. The major requirement for the new
system is that it should be able to store all the medical details regarding the patients within the
organization. The developed system should be capable of providing proper details towards the
organization. Apart from this it is important to ensure that the system is able to provide proper report
of medical details and track inventory that is maintained for the organization. The new system should

3SYSTEM ANALYSIS AND DESIGN
also have the capability of ensuring proper appointment for patients. The licenses of the nurse and the
pharmacists should also be renewed automatically by the system. There is a 0 level DFD diagram that
is described for the newly developed system.
An architectural design
The architectural design will help understanding the limitations and working of the system
properly. The architectural design explains the working of the database. This includes storing the data
within the system of hospital. The way data are transferred within the system.

4SYSTEM ANALYSIS AND DESIGN
User Interface Design
Homepage
The above page is a home page for patients. This will help the patients to access the page and
will allow them to choose from the features offered to them. From this page the patient will be able
select the doctors as per their need, can get the medicines through medical store. In case of emergency
they will be able to call for ambulance. The patient will be able to access all the features offered by
the medical centre. Apart from this the centre also allows the user to choose whether they are new to
the system or not. The patients are also allowed to add prescription of previous doctor so that they can
have the medicines based on the prescription.

5SYSTEM ANALYSIS AND DESIGN
New Patient
This page is created for registration of new patient. For availing the facilities it is important
for the patients to enter their data in the site of Family First Medical Centre. This form includes filling
up the personal data and medical details. In addition to this the patients are allowed to add their
picture. The patient can set preferable appointment date as per their need.
Business process models using BPMN 2.0
The business process model is used for understanding the process that is going on within the
system. This includes verifying address and name of the customer. After that the gateway is used for
verifying the address and name than the system goes on to creating a new card and the other system
goes on to retrieve patient card. After this the type of prescription battle label is being detected. The
system goes to obtaining the product. After collecting the payment , the patient receipt is generated by
the hospital.

6SYSTEM ANALYSIS AND DESIGN

7SYSTEM ANALYSIS AND DESIGN
Program design
Program design contains several levels. This includes network, skills development, connect
opportunities and Entrepreneurial Venture. The network layer contains peer network, community
network and global network. The skills development section is concerned with east coast start up
work, organizing the competition and hosting workshops. The connect opportunities is related to
events, management of funds and Mentorship. Entrepreneurial venture is related to load and execute,
helps in impacting analysis and helps in pitching day. This will help in properly working with the
hospital management system.
Enterpreneurial Venture
Load and Execute
Imapact Analysis
Pitch day
Network
Peer Network
Community Network
Global Network
Skills Development
Workshops
Pitch Competition
East Coast Startup Work
Conect Oppertunities
Conference/Events
Funds
Mentorship

8SYSTEM ANALYSIS AND DESIGN
Physical data storage Design
Physical data storage is used for representing the design that will help in separating the
physical and logical structures. This also helps in managing the physical storage associated with the
data without affecting the logical structures. Data file is basically physical file that is used on disk for
creating Oracle Database and contains data structures. This databases includes tables and indexes.
Storage device is used as a physical piece of hardware that is used for the purpose of storing data. The
file type that can be added to a storage device includes hard drive, USB flash drive and memory card.
The design includes user login system, hospital management database and user login system. The
hospital system contains two database one for the patient and another for maintaining the doctors
details.

9SYSTEM ANALYSIS AND DESIGN
Bibliography
Aagesen, G., & Krogstie, J. (2015). BPMN 2.0 for modeling business processes. In Handbook on
Business Process Management 1 (pp. 219-250). Springer, Berlin, Heidelberg.
Anand, J., & Lee, Y. (2016). Acquisition Strategy. The Palgrave Encyclopedia of Strategic
Management, 1-6.
Arévalo, C., Escalona, M. J., Ramos, I., & Domínguez-Muñoz, M. (2016). A metamodel to integrate
business processes time perspective in BPMN 2.0. Information and Software Technology, 77,
17-33.
Cervantes, H., Haziyev, S., Hrytsay, O., & Kazman, R. (2016, May). Smart decisions: an architectural
design game. In Proceedings of the 38th International Conference on Software Engineering
Companion (pp. 327-335). ACM.
Fielding, R. T., Taylor, R. N., Erenkrantz, J. R., Gorlick, M. M., Whitehead, J., Khare, R., & Oreizy,
P. (2017, August). Reflections on the REST architectural style and principled design of the
modern web architecture (impact paper award). In Proceedings of the 2017 11th Joint
Meeting on Foundations of Software Engineering (pp. 4-14). ACM.
Laakso, K. P., Husu, T., Romppainen, M., Fagerlund, J., Kettunen, M., & Standell, T. (2016, May).
User Interface Design In Agile Projects. In Proceedings of the 2016 CHI Conference
Extended Abstracts on Human Factors in Computing Systems (pp. 1007-1010). ACM.
Rousset, F., Ducros, N., D'Andrea, C., & Peyrin, F. (2015, August). Single pixel camera: An
acquisition strategy based on the non-linear wavelet approximation. In 2015 37th Annual
International Conference of the IEEE Engineering in Medicine and Biology Society
(EMBC) (pp. 6240-6243). IEEE.
Shneiderman, B., Plaisant, C., Cohen, M., Jacobs, S., Elmqvist, N., & Diakopoulos, N.
(2016). Designing the user interface: strategies for effective human-computer interaction.
Pearson.