ITSU3008 Project 1: System Design Report for Mobile MCQ Application

This report outlines the system design for a mobile application facilitating online Multiple Choice Question (MCQ) tests, specifically targeting educational environments. The system supports two user roles: teachers and students. Teachers create and assign tests, while students take and review their results. The report details the application architecture, emphasizing a layered approach (presentation, business, and data layers), and the use of a database server for data storage and security. It includes a project flowchart illustrating the sequence of processes from user registration to test completion and result viewing. Furthermore, an Entity Relationship Diagram (ERD) is provided to illustrate the database structure, including entities such as Student, School, Teacher, MCQ, and StudentMCQ, along with their relationships. The report concludes by summarizing the key aspects of the system design, emphasizing the use of MS Visio for diagram creation and the application of normalized entities for efficient data management.

Student Name
Student ID 1
Assignment 4 – System Design Report
Submitted By
Course
Professor
Date

Student Name
Student ID 2
Executive Summary
The quick advance of IT based innovation has prompted vacuums related to social strategy. Most
data frameworks advancement tools mainly focus upon some technical issues, and also provides
some guidelines that address the ethical issues inalienable in new application outcomes. It is
contended that if we include ethical as well as moral issues, it may cause human and ecological
issues. The initial stage will be provided by mapping significant statements of professional codes
of ethics. [1]
Innovation is the behavior of human mind that helps to change society as well as change the
work environment. Configuration is the considered as the foundation of innovation. The new
innovations helps to solve various issues, satisfy our needs, shape our real world, change the
future, and make new issues. The design process helps to make decision making process a better
one, decisions that decide the vast majority of the last item cost, and the choices that find ethical
cost as well as its benefits. It is quintessentially a moral procedure. These days ethics is the
integral part of design. [2] In this report, we will further elaborate the online system for MCQ
and will develop ERD diagram and Network Architecture. It will help to further understand the
given scenario. The system will have two users - teachers and students. The system will help the
teacher to develop MCQ questions exam for a particular group of students. The students will
check the MCQ test and will perform the test and again teacher will login into the system to
mark the test accordingly and update it into the system. After updation, student will get the
notice about result and he would be able to check the result after logging into the system.
The framework consequently checks all the questions and afterward matches to its correct
choices which is feed by the administrator or the educator of the course and afterward it
ascertains the correct choices and after that it will show the accurate result obtained by the

Student Name
Student ID 3
student and checked by the teacher. After the completion of the test, it produces a suitable for
both the administrator/teacher and the student/client. The mobile application will be very easy
for both the user that depends on a safe platform for both the organization and the clients to
effortlessly answer their tests.
Introduction
An information system lie at the core of modern decision making process, that includes
information/data storage and control, information accessibility, and various alternatives
definition and determination. The ethics' role in software design configuration is increasing day
by day. Moving towards the overall advancement process, there are various methodological ways
to deal with the system development process. Some deal with the ethical measurements of
system development process. [3]
According to given scenario, many advantages exists in implementing new innovative
advancements. One of the these innovative advancement exists to manage students' data i.e to
manage online MCQ tests through mobile application. With the development of this application,
it becomes easy for the students to get the data and also assists the teacher in overseeing their
administrations. The project scope is to develop a system for managing mobile Quiz by Wi-Fi
system. This project mainly focus on schools where an accurate application can help in
managing examinations without much involvement of staff. The framework will help to support
one user in particular device. The user connects with it like an ordinary instructor discussion
where the framework poses questions and the students responds to those inquiries by choosing
the right answer among the numerous answers given by the framework. Here, we will discuss
about ERD diagram, network architecture and flow chart of the online Quiz application.

Student Name
Student ID 4
Architecture Diagram
The application architecture can be considered as application that can be developed by
considering various servers and layered architecture. We can develop Mobile Application
Architecture by using various advance methods as well as tools that are according to the
mobiles. The developed application is required to be supported by both iOS and Android systems
and also consider resolution, space as well as screen size.
The proposed mobile application must be according to the target application's prerequisites and
educational portal that can help in saving MCQ examination with student's details and must be
able to store the details of the educational institute and teacher's information. The app must store
official data framework and is required to help association's performance from the perspective on
operational administration. The mobile user interface is considered as the critical factor as since
that is really what clients face, work and connect with.
User interface is required to be user friendly. Here, we have considered layered architecture
infrastructure for the mobile application where three layers define the overall architecture and
processing of the application. These three layers are - presentation, business and data ones. The
presentation layer includes the system's front look which users will see while logging into the
system. It includes various in build components. Business layer keeps up the work processes and
practices of the end users, by providing actual functionality. Information layer deals with the
protected application structure and reliable application settings, overseeing information
usefulness for potential solicitations. [4]
All the data of mobile application will be stored in database server which will provide data
access logic and some security infrastructure will be provide which will guarantee that

Student Name
Student ID 5
confidential data will be displayed only to the authorized users. This step can be performed by
using API to the application layer of the mobile application. This connection with API will
ensure that the complete transparency can be provided to data operations which are done in this
level without influencing the application level. For instance, any type of updation to the existing
application in this level don't influence the application level of this architecture design. [5]
Project Flow Chart
A flowchart is the sequence of the processes shown in diagrammatical form. It is a nonexclusive
tool that can be adjusted for many reasons. Planning the flow of processes while developing
mobile application is initial but most important phase as the entire logic of mobile application
mainly depends on these processes. The flow chart helps us to get better idea about how the
processes will take place. It will also provide some understanding that how one process will

Student Name
Student ID 6
communicate with another process, their connection as well as their data connection as this will
be centralized database.
Here, we are not discussing about front end mobile interface, we are mainly focusing on the
sequence of processes. It is the sequence by which user comprehensively communicates with the
application and explores between its different areas. There are two noteworthy purposes behind
mapping out an application along these lines. Firstly, it should be guaranteed that each process
according to the requirement must be accompanied which implies that all the functional
processes are fulfilled. Secondly, we should attempt to fulfill all the requirements. By mapping
the flow by entering the username, password as well as pressing the login button effectively
being signed in is just its beginning. [6]

Student Name
Student ID 7
Here, we have used MS visio, to draw flow chart for the scenario which needs to be developed.
The first screen that appears will be registration of user. The user can be Teacher or Student.
After logging into the application as the teacher, his next responsibility is to prepare MCQ for
students and assign marking rubric to the questions that he has made. He first prepares MCQ test
for the students. Now this test will be assigned to students. The student will login into the system
and will do the test and submit it into the application. This will be online test. The teacher gives

Student Name
Student ID 8
the marking to the test given by the student and student will be able to check the marks obtained
in the test.
ERD Diagram
An Entity Relationship (ER) diagram is high level conceptual model that describes data in the
form of entity, attributes as well as relationship between them. An ER diagram is intended to
encourage database planning and then designing database structure. This model depends on the
idea of true entities and the connection between them. This diagram helps to analyze all the data
prerequisites efficiently in order to implement a well-structured database design. This data
models are translatable into relational tables that can enable us to develop database structure.
This is main idea that is designed by database designers as it acts as blueprint for developing
backend for the application systems. [7]
This diagram helps to provide better understanding of data and will help to find how this data
will be stored in the database. It can help in finding logical structure of the database and its
interaction with users. Contingent upon the size of progress, it tends to be unsafe to adjust a
database structure directly in like DBMS structure. To abstain from ruining the information in
the database, it is imperative to plan out the progressions cautiously. ERD is an instrument that
makes a difference. By attracting ER outlines to imagine database structure ideas, we can easily
recognize the errors and any type of configuration flaws, and to make updation before executing
the adjustments in the database. [8]

Student Name
Student ID 9
Here, according to given scenario, we have used five entities – Student, School, Teacher, MCQ
and StudentMCQ. School, Student and Teacher are parent tables that are related with child tables
StudentMCQ. StudentMCQ is transaction table. A school can have many students and many
teachers. A school can have many MCQ test that are saved in MCQ entity. StudentMCQ is
transaction table. A student can take many MCQ test, therefore it will have one to many
relationship. Also a teacher can prepare more than one MCQ test, hence it will possess one to
many relationship between MCQ and teacher. All the user id and password will be saved in
corresponding tables student and teacher. If the user is teacher than it will save details in teachers
entity and if it is student then it will save all the details in students entity. The answer keys for
each MCQ test will be saved into StudentMCQ as this is transaction table with student who has
performed that test and the teacher who has created that test.
Conclusion

Student Name
Student ID 10
Here, we have given the scenario of developing mobile application for generating online MCQ
test with use of wifi network system. We have developed architectural diagram, flow chart and
ERD diagram for better understanding of the mobile application system. The report helped use to
get more knowledge about data saving, entities, their attributes and the relationship between
these entities as we have used normalized form of entities. The flow chart which we have
developed helped us to get the knowledge about sequence of the processes that are included in
the mobile application system. This is mainly system analysis document that helped us to get the
idea about system development processes. We have used MS Visio to develop all the diagrams.
References
[1] J. Endrikat, F. Hartmann 2017, "Social and ethical issues in management accounting and
control: an editorial", J Manag Control (2017) 28:245–249. Available at -
https://link.springer.com/content/pdf/10.1007%2Fs00187-017-0253-x.pdf
[2] R. Devon 2004, "Design Ethics: The Social Ethics Paradigm", Int. J. Engng Ed. Vol. 20, No.
3, pp. 461±469, 2004. Available at -
https://www.researchgate.net/publication/228827371_Design_ethics_The_social_ethics_paradig
m
[3] P. Mishra, G. S. Dangayach 2011, "An Ethical approach towards sustainable project
Success", Procedia - Social and Behavioral Sciences 25 (2011) 338 – 344. Available at -
https://core.ac.uk/download/pdf/82343764.pdf
[4] R. P. Soares, E. Sediyono 2013, "The Analysis of Academic Information System Design of
IPDC Dili - Timor Leste by using EAP Approach", International Journal of Computer

Student Name
Student ID 11
Applications (0975 – 8887) Volume 84 – No 15, December 2013. Available at -
https://pdfs.semanticscholar.org/7d01/60720e9f1b4b4a0bfcfeecf548f0079d2eeb.pdf
[5] "What is a multi layered software architecture?", Packt Editorial 2018. Available at -
https://hub.packtpub.com/what-is-multi-layered-software-architecture/
[6] J. Ramon 2014, "Mobile UI Patterns - A Flowchart for User Registration, Login and Logout",
Available at - https://dzone.com/articles/mobile-ui-patterns-flowchart
[7] "What is Entity Relationship Diagram (ERD)?", Visual Paradigm 2018. Available at -
https://www.visual-paradigm.com/guide/data-modeling/what-is-entity-relationship-diagram/
[8] E. S. Btoush, M. H. Hammad 2015, "Generating ER Diagrams from Requirement
Specifications Based On Natural Language Processing", International Journal of Database
Theory and Application Vol.8, No.2 (2015), pp.61-70. Available at -
https://pdfs.semanticscholar.org/f37f/18db42d9dabf831fb9ca86cf3bfe133aae4a.pdf