University Project: Information System Design for All Sports Business

This project provides a comprehensive design for an information system tailored to the All Sports business. It encompasses several key elements of system design, beginning with a use case diagram to illustrate user interactions and system functionalities, followed by a context diagram to define the system's boundaries and external entities. The project then delves into the internal workings of the system with a Level 0 Data Flow Diagram, which visualizes the processes and data flow. An Entity Relationship Diagram (ERD) is included to model the database structure, detailing entities, attributes, and relationships. A CRUD diagram is also presented to show the connection between the database entities and business processes. The project also includes system prototypes, specifically a login page and a registration page, offering a glimpse into the user interface. Furthermore, the project details the contributions of team members, and concludes with a reflection on the design process and its potential impact. The bibliography provides a list of references used in the design and analysis.

Running head: INFORMATION SYSTEM DESIGN OF ALL SPORTS
Information System Design of All Sports
Name of the Student
Name of the University

1INFORMATION SYSTEM DESIGN OF ALL SPORTS
Table of Contents
Introduction:....................................................................................................................................2
1. Use Case Diagram:......................................................................................................................3
2. Context level Diagram:................................................................................................................4
3. Level 0 Data Flow Diagram:.......................................................................................................6
4. Entity Relationship Diagram:......................................................................................................8
5. CRUD Diagram:..........................................................................................................................9
6. Prototype of System:..................................................................................................................10
7. sContribution of Team Members:..............................................................................................11
Reflection and Conclusion:............................................................................................................12
Bibliography:.................................................................................................................................14

2INFORMATION SYSTEM DESIGN OF ALL SPORTS
Introduction:
The software designing process is known for designing the system through the use of
UML notations, ERD, Prototyping and other procedures. The use case are used for catching the
user interaction with the system, the context and data flow diagram is used for identifying the
internal functions of the system. The ERD visualizes the database entities and relation among
those entities. The use of the prototypes are done for getting an idea regarding the interface of the
system.
The study is based on the information system designing for All Sports business. Within
the study, the use case diagram, context diagram, ERD, Data flow diagram level 0 and protytoes
of the website has been provided. Description of the diagrams has been given so that proper
understating of the designs can be developed.

3INFORMATION SYSTEM DESIGN OF ALL SPORTS
1. Use Case Diagram:
Figure 1: Use Case Diagram of All Sports Information System
(Source: Created by Author)
The use case diagram visualizes that the system will be accessed by five kinds of users
such as club president, members, editor, outsider business and staff of organization. All of these
members will be accessing the system through various access priority and authorization settings.
The report can only be accessed by the Club President. The club president will also select the

4INFORMATION SYSTEM DESIGN OF ALL SPORTS
members who can submit the articles. The article use case is connected to editor and member
actors. The articles will be submitted by members and the editors will select the articles that will
be selected for newsletter. The advertiser will submit advertisement in the newsletter. The
‘include’ connection illustrates that the newsletter must be created through the article and
advertisement use case.
2. Context level Diagram:
Figure 2: Context Diagram of All Sports Information System
(Source: Created by Author)
The context diagram shows the normal data flow in the system with the users. The
external entities are members, club president, staff and editor. The members will provide their
information to register into the database. Another data the members provide to the system is
articles. These data is provided as a file format. The system sends the mail containing the
newsletter to the members. The club president receives the reports from the database. The editors

5INFORMATION SYSTEM DESIGN OF ALL SPORTS
as well have to register into the database. The editors provide the names of the articles selected.
The system sends the articles to the editors.
The context diagram has been a great source of identifying the basic data flows in the
system. The external entities are accurately visualized into the context diagram.

6INFORMATION SYSTEM DESIGN OF ALL SPORTS
3. Level 0 Data Flow Diagram:
Figure 3: Level 0 Data Flow Diagram of All Sports Information System
(Source: Created by Author)

7INFORMATION SYSTEM DESIGN OF ALL SPORTS
The level 0 data flow diagram is the modified version of context level diagram. Six
processes has been visualized into the flow diagram along with seven data stores. The
registration process is the first process in the system. The members then provides the articles to
the system. A new record is created into the article data store regarding each article. The editors
then login to the system which has been shown in the 2.1 process data flow as editor id and
password flow. Then the process retrieves the articles from the D3 data store. ‘2.1’ and ‘2.2’
shows the article selection process. All the ids selected articles and advertisements are then sent
to the 4.0 or newsletter creation process, which is associated with D5, D6 and D7 database.

8INFORMATION SYSTEM DESIGN OF ALL SPORTS
4. Entity Relationship Diagram:
Figure 4: Entity Relationship Diagram of All Sports Information System
(Source: Created by Author)
The ERD or entity relationship diagram shows the database of the through a design
perspective. The database sample includes all the attributes, primary key, foreign key and

9INFORMATION SYSTEM DESIGN OF ALL SPORTS
relationship among the entities. The member and sport entity is connected through one to many
relationship. This implies that the one member can select many sports. It also shows that each
member must select one sport but not each sport must be selected by the user. This illustrates that
few or single sport may remain unselected.
5. CRUD Diagram:
Process
Entity
Member
Sport
Article
Editor
Newslett
er
Advertis
er
Advertis
ement
Member
Registration
CR UR
Article
Submission
R CU
Editor
Registration
CR
Article
Selection
R U R
Member Leave DR
Editor Leave DR
Advertiser
Registration
CR
Submit
Advertisement
CR R

10INFORMATION SYSTEM DESIGN OF ALL SPORTS
Newsletter
Creation
R R CR R
Figure 5: CRUD Diagram of All Sports Information System
(Source: Created by Author)
The CRUD diagram shows the connection between the database entities and business
processes. Taken as an example, the member registration will result into creating a new record
and reading data from the member entity. It will also update the Sport entity.
6. Prototype of System:
Figure 6: Login Page of All Sports Information System
(Source: Created by Author)

11INFORMATION SYSTEM DESIGN OF ALL SPORTS
This prototype shows the page through which the user will login to the page. It is
assumed the All Sports will have a personal main for staff and club president. They can select to
which part they want to login.
Figure 7: Registration Page of All Sports Information System
(Source: Created by Author)
The figure 7 represents the registration page of the All Sports information system.
7. sContribution of Team Members:
Team Member One:
Task
Analysis for Critical Use Case
Draw Critical Use Case
Analysis for Context Diagram

12INFORMATION SYSTEM DESIGN OF ALL SPORTS
Draw Context Diagram
Analysis for Level 0 Diagram
Analysis for CRUD Table
Draw CRUD table
Pages
Make Report
Team Member Two:
Task
Gathering ideas regarding the system
Identifying the needs of the system
Making the report structure
Testing the deigns
Make modifications to the diagrams
Creating the prototypes
Reflection and Conclusion:
From the above study it can be concluded that the system of All Sports will be developed
based on the basic functional and non-functional requirements of newsletter publication process.
The use case has provide a proper understating of the UX design of the system. The database of
the system is simple and thus failing at post implementation is very low. The issue of redundancy
in the database will be absent. The proposed system in the study will be able to handle the
business processes of All Sports properly and efficiently.

13INFORMATION SYSTEM DESIGN OF ALL SPORTS