Database Application Development Project Management

The given assignment involves creating a database application for Relish Hospitals, which will help in maintaining patient information in a better manner. The project includes developing a database that contains medical history, laboratory results, medication provided, and other relevant information. A project management plan has been created along with a Gantt chart and Work-breakdown structure to ensure the completion of the project within time. This solution covers all the necessary aspects of the assignment, including the development of the database application and the project management plan.

SOFTWARE DEVELOPMENT
& PROJECT MANAGEMENT

TABLE OF CONTENTS
INTRODUCTION...........................................................................................................................1
AIMS AND OBJECTIVES........................................................................................................1
SCOPE AND BOUNDARY.......................................................................................................1
BUSINESS CASE.......................................................................................................................1
PROJECT PLAN OF SCHEDULE, ACTIVITIES, RESOURCES AND COSTS....................2
QUALITY MANAGEMENT PLAN..........................................................................................7
RISK MANAGEMENT PLAN..................................................................................................8
CONSTRAINTS.........................................................................................................................9
CONCLUSION..............................................................................................................................10
REFERENCES..............................................................................................................................11

INTRODUCTION
Project has to be delivered on time for extracting benefits. Present report deals with
Relish Hospitals which needs to create database application for its patients for gaining
transparency. Aims and objectives will be discussed along with scope and boundary of project.
Moreover, business case will be highlighted. Project Management Plan will be made by using
Gantt chart and Work-breakdown structure. Quality Management Plan and Risk Management
Plan will be produced for business and further constraints regarding project will be explained.
AIMS AND OBJECTIVES
Aim: To create a database application for a hospital to manage information of patient,
accreditation- Relish Hospitals
Objectives:
 To create software with high quality.
 To frame better coordination among hospital staff and authorities.
 To create unified work system of every medical department.
 To assess medical history, laboratory results, medication provided from software
SCOPE AND BOUNDARY
The hospital could gain advantage with effective utilization of project management to a
plan, schedule and for anticipating outcomes. It will help in giving better care to its patients in
effective aspect and to attain and raise productivity (Groomer and Murthy, 2018). In the same
series, this will lead to increase quality of care and its processes in hospital for managing there
day to day operations. There are various healthcare projects which fail due to improper planning
and anticipation of various unforeseen circumstances. Furthermore, the implementation of
project management methods in appropriate aspect will lead to raise success rate of projects by
giving tools for mitigating and anticipation risks (Rostami, Creemers and Leus, 2018). In turn,
this will help in improving financial and quality performance of Relish Hospitals along with
brand reputation as well.
BUSINESS CASE
The database application helps in saving money, energy and time of both patient and
hospital as well. For instance, an individual suffering through mental illness and substance abuse
visited variety of local hospitals on regular basis which lead to infection (Nicholas and Steyn,
2017). This is bad for patients and hospital as well as it is waste of precious resources.
1

In order to this, hospitals could use database where is presence of patient records as if
they are treated already with certain tests along with their outcomes and will prevent through
unnecessary assignments. In the present scenario, individuals are highly relied on computerized
systems comparatively to manual and this will lead to high level of trusts in processes and
systems. The connectivity will be maintained among patients and peripheral systems while
managing operations through multiple automated systems (Goldberg, Asok and Lee, 2017).
Furthermore, database application will help in giving better concerned environment
among doctors, patients, hospital staff, group and for managing workflow. In this aspect, it has
capability for unifying legacy application and handling multitudes of requests of user with
outcome in uninhibited information flow among patients, staffs and doctors.
PROJECT PLAN OF SCHEDULE, ACTIVITIES, RESOURCES AND COSTS
Project Management Plan of Relish Hospitals
Task Name Duration Start Finish Predecessors WBS Cost
Project
Management 13 days Tue 08-
01-19
Thu 24-
01-19 1 $10.00
Project Initiation 2 days Tue 08-
01-19
Wed 09-
01-19 1.1 $0.00
Project Plan
documentation 3 days Thu 10-
01-19
Mon 14-
01-19 2 1.2 $1.00
Project Schedule and
Activities 2 days Tue 15-
01-19
Wed 16-
01-19 2,3 1.3 $2.00
Risk Management 2 days Thu 17-
01-19
Fri 18-01-
19 4 1.4 $2.00
Project Meetings 2 days Mon 21-
01-19
Tue 22-
01-19 5 1.5 $2.00
Project Close-out 2 days Wed 23-
01-19
Thu 24-
01-19 6 1.6 $3.00
Designing of
database
application
14 days Tue 08-
01-19
Fri 25-01-
19 2 $70.00
Meetings for
database design 2 days Fri 25-
01-19
Mon 28-
01-19 7 2.1 $10.00
Documentation of
database design 3 days Tue 29-
01-19
Thu 31-
01-19 9 2.2 $12.00
Meetings for
application design 2 days Fri 01-
02-19
Mon 04-
02-19 10 2.3 $10.00
Documentation of
application design 2 days Tue 05-
02-19
Wed 06-
02-19 10,11 2.4 $8.00
2

System architecture
design 2 days Thu 07-
02-19
Fri 08-02-
19 12 2.5 $10.00
Documentation of
system architecture 3 days Mon 11-
02-19
Wed 13-
02-19 12,13 2.6 $20.00
Application
Development 19 days Tue 08-
01-19
Fri 01-02-
19 3 $160.00
Programming of
language 4 days Thu 14-
02-19
Tue 19-
02-19 14 3.1 $20.00
Implementation code
control system 3 days Wed 20-
02-19
Fri 22-02-
19 16 3.2 $10.00
Code reviews 2 days Mon 25-
02-19
Tue 26-
02-19 16,17 3.3 $20.00
UI Developers 2 days Wed 27-
02-19
Thu 28-
02-19 18 3.4 $30.00
Testing application 3 days Fri 01-
03-19
Tue 05-
03-19 19 3.5 $20.00
Factory testing 2 days Wed 06-
03-19
Thu 07-
03-19 20 3.6 $20.00
Issue or bug
resolution 1 day Fri 08-
03-19
Fri 08-03-
19 20,21 3.7 $30.00
Testing of site
acceptance 2 days Mon 11-
03-19
Tue 12-
03-19 22 3.8 $10.00
Database
Development 23 days Tue 08-
01-19
Thu 07-
02-19 4 $240.00
Pilot testing 2 days Wed 13-
03-19
Thu 14-
03-19 23 4.1 $20.00
Data migration 3 days Fri 15-
03-19
Tue 19-
03-19 25 4.2 $30.00
Data Quality
Assurance and
Quality Control
3 days Wed 20-
03-19
Fri 22-03-
19 25,26 4.3 $20.00
Deployment of
Resources 2 days Mon 25-
03-19
Tue 26-
03-19 27 4.4 $50.00
Issue Management 2 days Wed 27-
03-19
Thu 28-
03-19 28 4.5 $20.00
Server Management 3 days Fri 29-
03-19
Tue 02-
04-19 28,29 4.6 $20.00
Source Code
Management 2 days Wed 03-
04-19
Thu 04-
04-19 30 4.7 $30.00
Installing
documentation 2 days Fri 05-
04-19
Mon 08-
04-19 30,31 4.8 $30.00
User training 4 days Tue 09-
04-19
Fri 12-04-
19 32 4.9 $20.00
3

Application Testing 11 days Tue 08-
01-19
Tue 22-
01-19 5 $140.00
Test environment
setup 2 days Mon 15-
04-19
Tue 16-
04-19 33 5.1 $30.00
Implementing test
plan 3 days Wed 17-
04-19
Fri 19-04-
19 35 5.2 $20.00
Unit testing 2 days Mon 22-
04-19
Tue 23-
04-19 35,36 5.3 $20.00
UAT (User
Acceptance Testing) 2 days Wed 24-
04-19
Thu 25-
04-19 37 5.4 $40.00
Reporting results 2 days Fri 26-
04-19
Mon 29-
04-19 38 5.5 $30.00
Maintenance and
Operations 7 days Tue 08-
01-19
Wed 16-
01-19 6 $85.00
System
Administration 2 days Tue 30-
04-19
Wed 01-
05-19 39 6.1 $35.00
System Tuning 3 days Thu 02-
05-19
Mon 06-
05-19 41 6.2 $40.00
Support from End
user and help desk 2 days Tue 07-
05-19
Wed 08-
05-19 41,42 6.3 $10.00
4

Figure 1 Gantt chart
5

Figure 2 Gantt chart
Figure 3 Gantt chart
Interpretation-
It can be analysed from the above Gantt chart that project would take 87 days to complete
and database application for Relish Hospitals will be created. This WBS is also prepared
highlighting that project will be completed according to scheduled activities in effective manner.
Schedule-
6

The schedule of project can be ascertained that it will be completed within 87 days and
all scheduled activities will be completed step-by-step in sequential manner. The activities as
scheduled will be met so that project may be delivered in effectual way so that Relish Hospitals
may be able to create adequate database for managing information regarding the patients and
maintain database (Eastman, 2018). Thus, scheduled activities will be completed within time.
Activities-
There are various heads and sub-activities being included in Gantt chart. It can be
evaluated that main heads of activities are Project Management, Designing of database
application, Application Development, Database Development, Application Testing and
Maintenance and Operations. In these activities, various sub-activities are included which will be
completed so as to create database application for the hospital.
Resources-
The resources such as technical, human and financial resources are being included in
order to complete project in the best manner possible (Kerzner, 2017). The resources are scarce
and require to be allocated in effective manner by which project deliverable may be attained with
ease. Moreover, it can be analysed that organisation will accomplish project within stipulated
time.
Costs-
The project costs include expenses to be incurred on completing project in a better
manner. It can be referred to Gantt chart that various costs will be incurred for different activities
so as to complete activities in sequential manner (Ragoussi and Costa, 2019). Overall project will
be completed on time and resources will be utilized in effective way so that deliverable may be
provided by Relish Hospital. This means that project will get completed and necessary costs will
be incurred.
QUALITY MANAGEMENT PLAN
Quality Planning Quality Control Quality Assurance Quality Improvement
Plan Do Check Act
What is done? Determine the
quality of project
Monitoring specific
products or services
To determine if
measurement of
Maximising effectiveness and
efficiency of project when
7

and how it will be
measured.
for determining if
they meet
performance
measurement
thresholds being
defined in
maintaining quality
of database
application of
hospital.
quality is appropriate
by evaluating overall
performance on
regular basis so that
project may be
delivered as per
objectives.
corrective actions are identified.
Thus, changes to quality
management plan may be
required to revise.
When it is
done?
Project Planning
phase
Execution and
control phase
Execution and control
phase
All phases of project
RISK MANAGEMENT PLAN
List of risks:
 Innovative, unproven technologies: There is entailed of application of innovative
technologies. The tools which are ever-changing along with protocols, techniques,
development system and standards raise the probability which will arise technology risk
in virtual and substantial software effort.
 Application and system architecture: Undertaking wrong direction along with
component, architecture or component reflects disastrous consequences (Five Types of
Risk In Software Project Management. 2018). With context of technological risks, it is
highly important that team must comprise experts for ensuring about work products in
similar direction.
 User and functional requirements: The basic requirements is to gather needs of users
with reference to features of software, quality and functions of service. As its process
needs are tedious, complex and lengthy which usually alter by discovery, integration and
prototyping activities. Thus, these disruptions will directly lead to critical failures of
software development in poorly planned aspect (Chawla and et.al., 2018).
8

 Performance: It is significant for encompassing expectations of partner and user related
to performance. Moreover, benchmarks should be given so as to ensure that project is
moving in right direction in the best manner possible.
 Organizational: The organisational problems have adverse impact effects on outcome of
project (Mascaraque-Ramírez, Para-González and Moreno-Sánchez, 2018). The plan of
project management should be efficiently executed and balance should be find out
between needs of team engaged in development and customer's expectations.
Considering above risks, Risk Management Plan is produced below-
S No. Risk Probability of Risk Impact on
hospital
Mitigation Plan
1 Failure to meet
performance of database
application as per the set
standard
Medium Medium For mitigating this risk, train
software development team on
tuning their performance. Update
review checklist and performance
during system testing.
2 Lack of employees with
required skills
Low Low Imparting desired training to
employees. Developing coding
practices for serving patients quite
effectively.
3 Database application
complexity
Medium Medium To make ensure to transfer
ongoing knowledge. Engage
experienced software developers.
4 Manpower attrition Medium Medium Rotating assignments among
people and train core group of
people.
CONSTRAINTS
The constraints are of six types such as risk, scope, resources, quality, time and cost.
These constraints are interrelated in effective manner and strain in one will have effect other. The
resources are not available, time to deliver project will undoubtedly increase (Shenoy. 2018).
9

Eventually, it will increase project cost because it will be more expensive rather than planned
one. On the other hand, if QA (Quality Assurance) finds that deliverable quality is deteriorating,
more resources will be required to be attain project (Joseph and Marnewick, 2018). It will
directly increase cost for engaging additional resources for fixing deliverable and thus, increase
time to deliver will be found. While, scope creep happens, then it will maximise cost, time,
resources and quality will be reduced.
CONCLUSION
Hereby it can be concluded that project management is required for completing project in
accordance to project objectives. Relish Hospitals will create database application which will be
helpful in maintaining information of patients in a better manner. The database will contain
information such as medical history, laboratory results, medication provided etc. This will help
business to focus on health of patients more accurately and information may be available to them
at their disposal. Furthermore, project management plan has been made along with Gantt chart
and Work-breakdown structure highlighting completing of project within time. Thus, project of
creating database application will be completed in time.
10

REFERENCES
Books and Journals
Chawla, V. and et.al., 2018. The sustainable project management: A review and future
possibilities. Journal of Project Management. 3(3). pp.157-170.
Eastman, C. M., 2018. Building product models: computer environments, supporting design and
construction. CRC press.
Goldberg, A., Asok, S. and Lee, D. T., Box Inc, 2017. Desktop application for access and
interaction with workspaces in a cloud-based content management system and
synchronization mechanisms thereof. U.S. Patent 9,652,741.
Groomer, S. M. and Murthy, U. S., 2018. Continuous auditing of database applications: An
embedded audit module approach. In Continuous Auditing: Theory and Application (pp.
105-124). Emerald Publishing Limited.
Joseph, N. and Marnewick, C., 2018. Investing in project management certification: Do
organisations get their money’s worth?. Information Technology and Management. 19(1).
pp.51-74.
Kerzner, H., 2017. Project management metrics, KPIs, and dashboards: a guide to measuring
and monitoring project performance. John Wiley & Sons.
Mascaraque-Ramírez, C., Para-González, L. and Moreno-Sánchez, D., 2018. Improvement of the
construction project of tuna purse seine vessels through a cost and term analysis. Ships and
Offshore Structures. 13(1). pp.20-27.
Nicholas, J. M. and Steyn, H., 2017. Project management for engineering, business and
technology. Routledge.
Ragoussi, M. E. and Costa, D., 2019. Fundamentals of the NEA Thermochemical Database and
its influence over national nuclear programs on the performance assessment of deep
geological repositories. Journal of environmental radioactivity. 196. pp.225-231.
Rostami, S., Creemers, S. and Leus, R., 2018. New strategies for stochastic resource-constrained
project scheduling. Journal of Scheduling. 21(3). pp.349-365.
Online
Five Types of Risk In Software Project Management. 2018 [Online]. Available Through:
<https://www.castsoftware.com/research-labs/risk-management-in-software-development-
and-software-engineering-projects>.
Shenoy. 2018 The 6 Project Constraints [Online]. Available Through:
<https://www.workfront.com/blog/the-6-project-constraints>.
11

12