Database Implementation Report: XYZ United Web Database Analysis

This report focuses on the implementation of a web database for XYZ United, outlining the use of MySQL and Hadoop technologies for managing large datasets. It includes an Entity Relationship Diagram (ERD) to illustrate the relationships between entities like players and training sessions, facilitating efficient data retrieval and insertion. The report discusses recent advancements in database technology, from early scientific computing models to modern relational database management systems, highlighting applications such as Oracle and Apache Hadoop. Furthermore, it addresses implementation challenges, including increasing data volume, data recovery, query optimization, and concurrency control, as well as critical security issues related to data breaches and the protection of sensitive information. The conclusion emphasizes the role of technology in simplifying data management and the importance of addressing security concerns.

RESEARCH

TABLE OF CONTENTS
INTRODUCTION...........................................................................................................................1
TASK...............................................................................................................................................1
Implement the web database..................................................................................................1
Recent developments in the field of database technology......................................................2
Issues related to implementation and security........................................................................3
CONCLUSION................................................................................................................................3
REFFERENCES..............................................................................................................................4

INTRODUCTION
Database management system is a software of creating and managing the data. It
provides a systematic way of updating and deleting the data. Such queries includes select, insert,
update, delete. This report will create entity relationship diagram (ERD) for the given case of
XYZ United. It will provide a database to integrate and effectively utilise large data. This
research will provides coach with easiest use of database technology to establish relationship
between the different entities. Present study will explain the implementation of web database.
Furthermore, it will describe recent development in database management system. In addition,
study will explain implementation and security issue in DBMS.
TASK
Implement the web database
Web database implementation will be done with the help of integrated combination of
client side and server side applications. Here, client side applications consist of framework and
structure which provides interface to users. In this scenario, football coach wants to save the data
of players their training sessions. So to establish a relationship between interface and database , a
software is designed to provide relation with these entities. While server side is used to provide
connectivity and backed system which consists of MySql database. When front-end and back-
end share their features together, they provide a complete database to insert and retrieve the data.
1

Entity relationship diagram provides several entities which are connected with their
required attributes and here is also provided a relationship between those entities and their
fields . This diagram clearly describes relationship between player and training sessions. This
also provides “one to many” relationship style between player and registration. Many players can
apply in various sports (Sang, Xu & de Vrieze, 2016).
One player can register in multiple training sessions. More than one training session can
be registered with different multiple players.
Recent developments in the field of database technology
Initially, scientific computing model was used to manage the database and later on,
simple DBMS system came into existence. In the year 1964 IDS, network system came into
market. But in later phases, new and advanced software have overtaken these technologies.
(Qasim, Hammad &Imran, 2016). Database management technology is used to develop system
integration projects. It is considered as the easiest way to link business requirements with
2
Illustration 1: Entity relationship diagram

applications. It supports a relational database management system style. Recent development in
this field provides an appropriate use of technology which arranges such a large amount of
database to simplify the work of developers (Abel, E. E. & Obeten, E., 2015). There are multiple
types of applications which are used to arrange those big database in an integrated and efficient
way (Web Database Integration, 2018). Applications which support those technologies are as
like oracle database SQL, Apache Hadoop technology, etc.
Issues related to implementation and security
There are many implementation issues that can be faced by person by applying Database
management system. One of the major problems is increasing data volume. In such condition,
person may find difficulty to run application. Data recovery is another major implementation
issue in DBMS. If individual fails to run application successfully then it can create problem in
showing relationship between attributes. If the system has lost entire database is quite possible to
recover all details but if users needs to recover only partial data then it becomes problematic for
individual to recuperate this part. It can be a time consuming process as well. Furthermore,
auditability is another major issue related to same (Carrega & et.al., 2017). Query optimization
and concurrency control are other issues in DBMS. Rewriting of query that has been submitted
by other user is the complex problem. By this way actual results can be differed from expected
outcome.
Security is considered as one of the major issues for database management. IT system
stores many critical data of public and private enterprises. If these details are not secured then it
may create complexity for entire project. Data breach can increase the cost of company that may
affect goodwill of firm to a high extent (Braun & et.al, 2014).
CONCLUSION
It can be concluded that technology had provided the easiest way to arrange large amount
of data. This report has provided the use of MySql and Hadoop technology in maintaining big
database. Relationship between entities and its attribute helps in updating and deleting the
required data. MySql easily helps in retrieving and inserting the required data into database. It
had also discussed some concerns related to security and implementation of database.
3

REFFERENCES
Abel, E. E. & Obeten, E., (2015). Restaurant Customer Self-Ordering System: A Solution to
Reduce Customer/Guest Waiting Time at the Point of Sale. International Journal of
Computer Applications. 111(11).
Braun, J. & et.al., (2014). System for fast angle changing in video playback devices. U.S. Patent
8,837,921.
Carrega, A. & et.al., (2017). A middleware for mobile edge computing. IEEE Cloud Computing.
4(4). pp.26-37.
Qasim, A., Hammad, S. & Imran, A., (2016). Concurrency control in distributed database
system.
Sang, G., Xu, L. & de Vrieze, P. T., (2016). Implementing a Business Intelligence System for
small and medium-sized enterprises.
Online
Web Database Integration. 2018. [Online]. Available through<http://holowczak.com/web-
database-integration/>
4