Deployment of workable DBMS solution for Hertfordshire Catering Limited (HCL) by comparing MS Access, MS Server and Oracle

This article discusses the importance of a workable DBMS solution for Hertfordshire Catering Limited (HCL) and compares MS Access, MS Server and Oracle. It also highlights the benefits of using Oracle as the chosen DBMS for HCL and how it can help in resolving customer complaints and proper record keeping. The article concludes with a recommendation to adopt Oracle as the DBMS solution for HCL.

DATABASE AND BUSINESS INTELLIGENCE
(Deployment of workable DBMS solution for Hertfordshire Catering Limited (HCL)
by comparing MS Access, MS Server and Oracle)
INTRODUCTION
Business intelligence systems can be understood to improve an enterprise decision, by
making tools for gaining storage of data, storing, accessing and analysing business data
evolved. Also, it is a combination of tools and systems involved in enterprise strategic
planning which aids in analysis for larger working efficacy on extended periods within
structural innovation scenarios. HCL in the last 8 years has been a customer driven
organization, delivering innovative solutions to the challenges of fast-growing market space.
The company aims to utilize the best quality catering services towards a wide range of
market-oriented services to further cater for the exponential rise in fast developing markets.
Based on the number of years in operation, the company is known to utilize fresh and high-
quality ingredients to sell fresh and local seasonal foods to schools and colleges as well as
offering a wide range of quality catering services to academics. The telesales operations and
online sales system have a varied range of customer complaints, where customer
experiences further enable to innovate faster actively.
Overview of the company and its aim
HCL as one of the most productively expanding company aims to further keep track of
employee details including details regarding customers, in terms of standard promotional
aspects and to further enhance stronger quality growth. Online sales system, further aims to
deliver stringent innovation, and faster pace among extensive business goals for competent
scope within longer oriented systems which further raises goodwill (Tricoche, 2020). HCL
aims to adopt new database management systems to scale up the telesales operations by
capturing customers orders as well as complaints. Software investment plays a strong role in
strengthened working vision in achieving a huge rise on extended paradigms informatively.
For this aspect, it can be analysed that HCL values extractable intelligence from DBMS
which enhances abilities to further innovate more competitively, for regaining scope towards
extensive scale domains. Within a recent period, businesses among companies are evolving
to develop a critical rise for high quality catering services within innovative business goals
competitively (Sharma, 2017). An in-depth comparison of MS access, SQL servers and Oracle
further will enable the company to develop a stronger working base diversely within
software parameters for achieving a stronger range of operations. HCL business aims to
develop potential scale expansion where extractable intelligence from DBMS enhances
working competencies to be further advanced for new scale informative growth. By adopting
new software, the company further will be able to evolve on extensive commercial growth in
terms of innovation business avenues extensively for a leveraged rise within business
extended goals competently (Syamsiana, Setiawan and Saputra, 2020).
Intelligence database
The intelligence database plays a crucial role in employing artificial intelligence,
interacting with users to ensure huge returned items in most relevant aspects within
working innovation parameters. HCL by using intelligence will be able to further intricate
flexible options and conduct major queries practically on wider horizons for competent
innovation variedly. The business of HCL aims to derive the best flexible approach in terms
of technology functional growth for determining the best vision-oriented paradigms and
developing fundamental expansion within technology (Van Aken and et.al, 2017).
The dilemma of deploying the best software solution gave rise to significant in-depth
comparative analysis on MS Access, SQL Server and Oracle which are some of the most
significant database systems used by companies operating in similar business spaces to

ideally form competent innovation. HCL aims to derive the best technology, best vision
formative scope for hindering expertise rapidly on new paradigms for technical profits rise.
There has to be also scaled uprise on varied technical business quest evolved, for
systematic database management aspects for expertise enhancement.
As the company has been witnessing a huge volume increase in consumer complaints,
where usage of the best database management system plays a crucial role for innovative
faster reach. HCL needs to expand the best database system to develop expertise in
handling customer experiences and innovate faster for large-scale profits, which pools up
innovation working reach competitively on the extensive scope. As the company has been
witnessing huge issues in keeping records of all systems, there is a deliberate need to adopt
the best systematic working, user-friendly, scalable, efficient and cost-effective DBMS.
Usage and investment in the best database system, will enable the business to diversify
scope and further generate higher functional working evolved for digital advancement (Raza
and et.al, 2018).
Features of MS access :
Features of Oracle:
MS access is small database
system, which allows to
further create small medium-
sized database minimum
security features extensively
on working grounds for
securing optimum rise on
features significantly. Oracle
on the other hand as
compared with MS access,
can be integrated with
advanced NT security
parameters which gets data
authentically worked on for
larger scale functional growth
efficacy.
Oracle adoption on other
hand determines massive
multi users, to deliver higher
scale quality reach among
operations for company to
optimize new functional
working parameters
innovatively. As HCL aims to
develop value from most
advanced demonstrated
extractable intelligence, for
higher quality business goals
and achievement to develop
potential growth expertise
rapidly.
Features of SQL: SQL server
is lot easier to work with as
compared with MS access
and needs to be dedicated
further advanced on by using
DBA administer which
further enables business goals
to be fragmented up
informatively on structured.
HCL has significant benefits
for adopting SQL, as
compared with MS access
which shapes quest rise
dynamically on piratical
business targets for extended
scope.
However, on
comparison with Oracle,it
holds advanced reach and
technology oriented scope to
be functionally evolved on
new working grounds rapidly.
It aims to further deliver new
predictable and well
documented aspects within
business model scenarios
productively on structured
horizons.
Pros: MS's access is
particularly scaleable, where
multiple users are there and
Pros: It reduces performance
outages, where resolving
problem efficiency is there
Pros: The SQL server is easy
to install, enhanced
performance is there and

significant rise evolving
among multiple users which
further forms advanced scale
adopted for extensive growth
(Zhang and et.al, 2018).
Cons: It lacks efficiency to
be adopted with changing
parameters of time among
company business goals,
which exponentially plays
crucial role for strengthened
vision significantly on larger
performance goals. Access
does not provide good
prototyping tool in
development and deployment
of tools for faster platforms
traducement, which lowers
productive innovation
strategically for new
paradigms potentially. It also
lacks scalable business
objectives for new services to
be delivered and providing
commitment on rolling
features for extended
platform growth.
within business grounds,
where stability is there for
effective rise on extended
competitive grounds rapidly
for new performance goals
innovatively.
Cons: Oracle database is
ported to varied platforms
reach for competition to be
segmented into deliverables
with changing pace among
business performance goals
exponentially.
several SQL editions are
there which gives excellent
data restoration aspect
worked on for management
(Nidzwetzki and Güting,
2017). It can be analysed that
there is lower cost of
ownership, for business to
further evolve by
implementing SQL software
and derives competent
innovation as compared to
MS access within company
working scenario.
Cons: SQL lacks innovation
further pace significantly on
wider horizons as compared
with oracle for competitive
business growth rapidly.
Scalability : MS access lacks
scalability within business
operations, as with changing
varied new goals company
need to develop proper
advanced technologies
rapidly on untapped grounds.
Scalability : Oracle is scaled
up for strengthening
improved advancement
Scalability : It can be also
analysed that there has been
significant growth organized
with implementation of
Oracle which shapes
competitive business to be
evolved. It is easy to be
adopted significantly on
extended functional growth
targets, which shapes scope
for leveraged rise grounds
diversely.
Migration: Easy for
company to adopt, but lacks
efficiency to be adopted in
longer time run.
Migration: Costly for
company to adopt and
develop new scale business
strategies significantly. It
gracefully brings change in
system configuration and
demand, where additional
Migration: There has been
scope evolved, to yield on
innovation for expertise
business growth within data
business management goals
for larger profitability

oscillations within
performance level of
applications is enhanced
variedly (Lustosa, Porto and
Valduriez, 2019).
parameters (Fakhimuddin,
Khasanah and Trimiyati,
2021).
Training cost: Training costs
for MS access is less for
company business goals and
need to be further integrated
on towards developing new
services training.
Training cost: Cost of
Oracle database, determines
company to get high scale
working returns and is also
vitally crucial to be adopted
with changing pace of time
for higher working
advancement rapidly on
extended business grounds
practically (Onyepunuka
Michael, Fumnanya and Eze,
2021). HCL determinately
will be able to signify new
back up of data operations
technically, and evolve on
optimistic functional
innovation competitively with
usage of Oracle which is also
one of the most profitable
investment for company.
Training cost: Training costs
of SQL is less as compared
with Oracle.
Maintenance cost: Less cost
as MS accesss is less costly
for business to develop
proper technology adoption,
where this will develop
proper affordable settings.
Maintenance cost:
Furthermore, by using oracle
software systems can be also
significantly evolved for
strengthened vision and new
scale vision on competent
vision for exponential growth.
The business domains are
also determined to be
leveraged significant growth
for higher profits, which
further rises extended
profitability evolved
primitively. Oracle on other
hand, determines new scale
functions to be further
segmented into productive
usage for larger scale
productivity worked on
Maintenance cost:
Affordable for business to be
implemented in significant
rise on extended business
parameters.

within exponential targets
dynamically.
Security: Less security as
compared with oracle and
SQL server.
Security: The Oracle database
management is automated,
policy based productive
aspect which shares
significant rise on new
applications' usage for
functional growth on
performance levels
commercially.
Configuration:The
comparison of Oracle and MS
access further creates
structural rise on productive
levels competently, which
develops stronger base on
extended paradigms towards
higher profitability
parameters on structural
growth rise. HCL with
changing business goals,
further aims to derive higher
quality rise on adopting the
best data base systems for
strengthening vital functional
grounds crucially.
Security: HCL will be able to
further integrate wider scale
targets, deliver wider
optimistic performance
growth for extensive work
records within data
management.
MS Access
Oracle

SQL Server
Value and importance of chosen DMS to HCL
The value should be mostly demonstrated because of extractable intelligence from
DBMS which shapes up efficacy competitive deliverables. The Oracle database management
system holds a huge functional rise for determining competitive innovation and huge
expertise by being best delivered on extensive paradigms. The value should be mostly
innovatively demonstrated for intelligence aspects to be further shaped up informatively and
bring on the competitive rise on software reach actively. This enables the business to be
diversified crucially, for strengthening innovation among management of valuable
operations in data management significantly on wider horizons.
On other hand, it can be also analysed that by using new scale services expansion
value there is further scope evolved for larger technical growth. The Oracle database
management system enables a proper systematic record of leveraged rise for also
delivering functional growth strategically. This further also correlates to deal with challenge
scenarios which further forms competitive scale operations evolve on evolving data
management systems significantly. HCL aims to develop track of customers contacts
effectively within business grounds, where the quality of services and incentives are also
further signified on productive working horizons on extended paradigms (Chauhan and
Tripathi, 2019). HCL by using Oracle database when compared with MS accesses and SQL
server aims to develop potential working rise diversely which further forms crucial working
grounds on systematic business paradigms within longer grounds innovatively. Furthermore,
the quality of services and incentives are also diversified by using the best software data
management on practical domains for gaining huge working profits on revenue grounds.
Recommendation/Conclusion

Based on the above comparison of the three DBMS (MS, access, SQL Server and
Oracle), it is evident that adoption of Oracle in HCL as DBMS will not only resolve the
pending issues in the telesales operations with customers complaints and proper record
keeping but also a leap of HCL to evolve on new vision-oriented targets and be optimistically
advanced for utilising data management systems advanced working scenarios rapidly.
Oracle also offers HCL business wide-scale efficacy, in comparison with SQL and MS access
which is less advanced and developed for attaining new functional working growth. This
further also derives business technical vision to be expanded on wider horizons, where MS
access and SQL are less diversified as compared to Oracle for delivering functional
utilization. The revenue and staff strength of HCL will be significantly evolved when
implementing Oracle as it further forms strategic rise to evolve on higher new profit working
goals.
Research within the present study has also highlighted vision, and practical working
domains to keenly expand scaled uprise among working operations records for optimizing
best profits. Furthermore, Oracle determines the best technical scope for larger crucial
advancement in leveraged functional profits within longer extended market potentialities
(Ataei, 2021).
REFRENCES
Books and Journals
Ataei, P. S., 2021. Theory and Implementation of a Variational Database Management
System.
Chauhan, N. and Tripathi, S. P., 2019. QoS aware replica control strategies for distributed
real time database management system. Wireless Personal Communications. 104(2).
pp.739-752.
Fakhimuddin, M., and et.al, 2021. Database Management System in Accounting: Assessing
the Role of Internet Service Communication of Accounting System Information. Research
Horizon. 1(3). pp.100-105.

Lustosa, H.,and et.al, 2019, October. Savime: A database management system for
simulation data analysis and visualization. In SBBD 2019-Simpósio Brasileiro de Banco de
Dados (pp. 1-12).
Nidzwetzki, J. K. and Güting, R. H., 2017. Distributed secondo: an extensible and scalable
database management system. Distributed and Parallel Databases. 35(3). pp.197-248.
Onyepunuka Michael, I and et.al, 2021. Effects of Access Database Management System
Hands-on Experience on Students’ Academic Achievement and Self-Efficacy in Database
Management. International Journal of Psychosocial Rehabilitation, 25(03).
Raza, B and et.al, 2018. Performance prediction and adaptation for database management
system workload using Case-Based Reasoning approach. Information Systems. 76. pp.46-58.
Sharma, N., 2017. Overview of the Database Management System. International Journal of
Advanced Research in Computer Science. 8(4).
Syamsiana, I. N and et.al, 2020. Design of Energy Database Management System (EDBMS)
on the unit 2 outgoing transformer at the State Polytechnic of Malang. In IOP Conference
Series: Materials Science and Engineering (Vol. 732, No. 1, p. 012052). IOP Publishing.
Tricoche, A., 2020. Database management system.
Van Aken, and et.al, 2017, May. Automatic database management system tuning through
large-scale machine learning. In Proceedings of the 2017 ACM International Conference on
Management of Data (pp. 1009-1024).
Zhang, B and et.al, 2018. A demonstration of the ottertune automatic database
management system tuning service. Proceedings of the VLDB Endowment, 11(12), pp.1910-
1913.