Data Modelling, Management and Governance for Sports Club Management System

DATA MODELLING,
MANAGEMENT AND
GOVERNANCE

TABLE OF CONTENTS
INTRODUCTION...........................................................................................................................1
Use case diagram.............................................................................................................................1
Entity relationship model.................................................................................................................2
Normalized Database.......................................................................................................................4
SQL statement to create table in database.......................................................................................5
SQL queries.....................................................................................................................................6
Design decisions, issues and challenges faced while completing this report..................................8
CONCLUSION................................................................................................................................9
REFERENCES..............................................................................................................................11

INTRODUCTION
Data modelling can be defined as a kind of process which is used to create visual
representation of either whole information system or helps in developing communication
between data points and structure (Miao and et. al., 2021). It is one of the most important part of
database. In database it helps in providing relationship between various type of information that
are to be stored within a database. It is an important part of database because it can help database
users in getting a basic overview of ways in which data within a database is stored in an
appropriate and effective manner. This report will lay emphasis upon designing a database
solution for sports club record system. For designing a database solution, first of all use case
diagram was designed for understanding amin users of system and ways in which they will be
interacting with the system, then Entity Relationship Model will be designed for providing a
brief overview of database structure of Sports Club Management System, SQL statements used
to create tables within database will also be provided, and lastly 2 SQL queries will be explained
for showing ways in which Sports Club members can view their booking. For development of
this database PhpMyAdmin will be used.
PhpMyAdmin
It is a free and open- source tool of administration for both MySQL and MariaDB. It isa
portable web- based application written in Php and has grown popular for MySQL
administration tools. Some of the most important features of PhpMyAdmin are: web interface,
MySQL and MariaDB database management, import SQL/ JSON/ CSV file, export file in
different format, administer multiple server.
Use case diagram
Use case diagram isa kind of UML diagram which is drawn for summarizing details of
system user or actors, and ways in which they interact with the system also known as use cases
(Fauzan and et. al., 2019). One of the main use of this diagram is to help programmer or
developer to understand ways in which current system will be used, who will be using the system
and ways in which they will be interacting with the system (Sabharwal, Kaur and Sibal, 2017). It
is a high- level orientation diagram that provides an overview of ways in which system, use case
and users interact with each other.
In this use case diagram of Sports Club management system there are two main actors
who will be interacting with the system. Two main actors interacting with the system are: sports
1

club staff members and sports club members. Both the users interact with the system in different
manner. Sports club members can only register themselves to the system, login and book
activities in which they want to participate whereas Sports club staff members can interact with
the system in variety of manner. Such as Sports club staff members can interact with the system
for updating members information, activities schedule, checking attendance, updating staff
members information, view daily booking activities etc. On the basis of these identified use cases
and actors, use case diagram of Sports club management system have been drawn in appendix:
Please refer appendix.
Entity relationship model
Entity relationship model is a kind of graphical representation of database. It is a high-
level data model which is used to define main elements of data and relationship they have with
the system (Kheirabadi., and et. al., 2019). This model directly helps in defining relationship
between different entities and attributes. In other words, it can be said that it helps in providing
design view of database for understanding overall structure of database and type of data which
will be stored within this database (El‐ Assady and et. al., 2017). There are three main elements
in ER model that are: entity, attribute and relationship. Entity is represented in rectangular box,
attributes are represented in eclipse and relationship in Diamond or rhombus.
In the below drawn ER model there are four main entities named as: club_member,
staff_members, activity_booking, and sports_class. Each of these entities have their own
attributes that helps in identifying ways in which data will be stored within Sports club
management system. Each of these entities in below drawn ER model are interrelated to each
other with the help of relationship. For example: staff_membmers can update Sports_class,
Club_members can book Activity_booking etc.
Please refer Appendix
Normalized Database
Normalization is a process of structuring a database in accordance with a series of normal
forms for reducing data redundancy and bring improvement within data integrity. Out of all
types of normal forms 3rd normal form is most commonly used and implemented (Albarak and
Bahsoon, 2018). Third normal forms is also known as 3NF which is based upon a normalized
principle of reducing duplication of data, ensure data integrity and simplify data management.
2