Data Modelling Management and Governance - Desklib

DATA MODELLING
MANAGEMENT AND
GOVERNANCE
1

TABLE OF CONTENTS
INTRODUCTION...........................................................................................................................3
MAIN BODY...................................................................................................................................3
1. UML use case diagram................................................................................................................3
Use case relationship...................................................................................................................6
Benefits of use case diagram.......................................................................................................7
2. Entity relationship diagram for school scenario..........................................................................9
Database system diagram...........................................................................................................16
3. Logical design (ERD) and physical design................................................................................18
4.SQL Queries................................................................................................................................23
CONCLUSION..............................................................................................................................28
REFERENCES..............................................................................................................................30

INTRODUCTION
Data modelling refer to the process of developing the simplified diagram of the software
system which contains the data elements and other symbols etc. and it also shows how the data
flows within the system (Liu and et.al 2020). Data modelling is all about to generating the
blueprint for the desired database system or reengineering with the legacy applications. It
comprises of the visual representation of the complete information system or to communicate the
associativity between every data point aspects. data models can be developed around the
requirement of business. There are specific data models which the user concerns with conceptual
data model, logical data model and physical data model. Where it gives the clear image about the
data entities along with its various attributes (Sawaneh and et.al 2018). Database management
system refers to the computerised data storing system where the data is available in the arranged
or organised form that can be easily retrieved and accessed. Every business has their individual
data base system where they store their business details and other critical information, for
accessing the data they are provided with particular authentication in order to protect data from
any malicious activities. Data model generally examine the structured data that keeps the
persistent data within the relational database system and it is specified within the data modelling
language.
Following report will cover the description about the UML use case diagram that will be
made for the local secondary school in Luton who is looking forward to develop the database
system that comprises of all their useful details and other information. It will cover the Entity
relationship diagram where it will also highlight the conversion of logical ERD into physical
ERD and also covers the SQL queries for data access and information retrieval.
MAIN BODY
1. UML use case diagram
Unified modelling language diagram assists in providing the visual aspects of the system,
it generally describes the quantifiable factors about the system which is discussed visually like
relationship, behaviour and its cardinality, functionality (Zhidchenko and et.al 2021). UML is
utilised as the modelling of the system that is independent of the language platform, it provides
the standard approaches for write down the system models that consists of the conceptual ideas.
It is further classified into the categories that are on the basis of the structure where it covers the
3

Class diagram, composite structural diagram, object diagram and component diagram. While
other category is behavioural diagram where it covers the state machine diagram, activity
diagram, use case diagram and sequence diagram, timing diagram. UML diagram offers the
greater flexibility as it is one of the common used and widely accepted language for the outlining
programs.
UML use case diagram refers to depicting the functionality about the system and for its
components. These diagram are most commonly used diagram in order to describe the functional
requirements about the system and its interaction with the system users (Fischer, Scholten, and
Unwin, 2019). This diagram uses the set of use cases where it also involves the actor and their
relationship, it describes the different scenarios from which the system is used, it provides the
greater level view about the system. Main purpose of use case diagram is to specify the context
of the syst4em and to capture the system essential requirement, it also validates the architecture
of system and drive the execution or deliver the test cases. For the local school case scenario, it is
provided with the details that the school wants to develop their database system where they can
store the details of their staff, students and subjects. It comprises of the aspects that are as
follows:
Actor: Actors, someone or other external hardware system who interacts with the system and
they have crucial role in the business they are similar to the user but user can play other different
roles. They generally trigger the use case and play their role towards the system to enter the input
within the system in order to get the output. Regarding the school scenario two actors are
identified as student (pupil) and staff.
Use case: System functions that is process (automated or manual), every actor is required to
associates with the use case while some of the use cases might not associates with the actors.

Communication link: Participation of the actor within the use case system is represented by the
solid link, that generally associates the use case with the actor. With the help of this actors are
connected with the use case and also indicates the communication as how actor is
communicating with the use case (Mehta and et.al 2021). Thus connector helps in specifying that
particular actor has the role within the system. For an instance for school scenario in use case
diagram it will show how pupil can access the system and can take the subjects, also shows how
staff access the system and perform their specific role within the system.
System boundary: System boundary indicates the entire system where it describes the required
documents. For the large size and complicated system every module is considered as the system
boundary.
5

Use case relationship
Use case shares the distinct type of relationship where decision regarding relationship between
the two use cases is taken by the software analysts of that particular use case diagram. Where the
relationship between the two use cases is generally consider as modelling the dependency among
the use cases (Revesz, Rashid and Tuyishime, 2019). By reusing the use case with the different
kind of relationship is effective as it decreases the efforts that is needed for constructing the
system. Some of the use case relationship are as follows:
Extend: This relationship can be used as to specify that the particular use case is extending the
behaviour of the other use case. Such type of relationship helps in disclosing the information
about the application which generally do not appears and hidden within the use case.
Include: Include relationship is found when the use case is presented as using the functionality
and other aspects of the other use case. It is depicted by the directed arrow with having the dotted
line.

Benefits of use case diagram
There are various advantages of use case diagram which assists the software developer to design
their process as per the user’s perspective. As an outcome system works more efficiently and
helps in achieving the user’s goals (Utomo,Cahyono and Tristono, 2019). There are other
benefits of use case diagram is as follows:
 This diagram is usually traceable; it provides the information about structure as well as
system behaviour.
 It assists in analysing the complete functional requirements about the system so desired
result can come out.
 Its simplicity and easy interface lead the businesses to easily commence with and use
case also compatible for the software developer to deliver end result to their end users.
 They are reusable in project and it captures all the requirements for every iteration within
a creation guidance for the programmers, within test cases and also in user
documentation.
 Use cases are also useful for the scoping and it also make easier or simpler for the project
to undertake the phased approaches for the delivery, it can be easily removes and added
from the software projects when the priorities changes (Wajszczyk and Gruszka, 2020).
 Every use case defines the one approach for system is being used but additionally use
case modelling also helps in explaining the things which are not correct. Identification of
the exception points to the successful scenario in initial phase within a project is quite
helpful and saves a lot of time by determining the appropriate requirements.
 Its major advantage is that it is written in the natural language that means it can be easily
understood as well as it gives the easier way for communication and interaction with the
users. It also helpful is managing the complexity of the large projects by simply
decomposing the issue within a different functions and can be easily specified by the
user’s perception.
7

Above is the use case of Secondary school system where the major two actors are staff and
pupil(students) who access the system. there are sort of use cases involves in the diagram where
first is about login and logout system which is accessible to both staff and student (Chauhan and
Tripathi, 2019). Pupil register to course and view the subject course, they also give exam and
accessible to view the result. On the other hand, staff manage the student attendance, and view