ITSU3008 Project 1: Makeable App Database Development, 20XX

This project, for ITSU3008, focuses on the Makeable App database development, designed to assist users with disabilities by connecting them to relevant technological solutions. The project encompasses a detailed literature review, Gantt chart, budgeting, hardware and software requirements analysis, functional and non-functional specifications, and a discussion of the project methodology and scope. It includes feasibility and risk constraint analyses, along with use case diagrams, network architecture diagrams, project flowcharts, and ER diagrams. The app's database stores user profiles, categorized by disability types (vision, autism, speech, learning), allowing users to select specific functions and receive recommendations for suitable applications. The project also addresses the app's architecture, data storage, and user interaction, covering aspects such as accessibility, usability and cross-platform development. The budget includes both non-recurrent and recurrent expenditures. The project aims to provide a comprehensive database system for the Makeable App, ensuring efficient data management and user-friendly functionality.

ITSU3008 Project 1
Makeable App Database Development
Student ID and Student Names
Semester X, 20XX
1

Table of Content
s
Table of Contents.............................................................................................................................. 2
Executive Summary....................................................................................................................... 3
Introduction.................................................................................................................................... 4
Literature Review........................................................................................................................... 4
Gantt chart...................................................................................................................................... 7
Budgeting....................................................................................................................................... 8
Hardware Requirements................................................................................................................ 9
Software Requirements................................................................................................................. 9
Functional Requirements............................................................................................................ 10
Non-Functional Requirements....................................................................................................10
Methodology................................................................................................................................. 11
Project Scope............................................................................................................................... 12
Feasibility Analysis...................................................................................................................... 13
Risk Constraint analysis.............................................................................................................13
Use case diagrams and descriptions.........................................................................................14
Use case diagram.................................................................................................................14
Use case description.............................................................................................................14
Network Architecture/ Architectural Diagram............................................................................14
Project Flow Chart....................................................................................................................... 16
ER Diagram/ Protocols and Technologies.................................................................................16
Reference...................................................................................................................................... 18
2

Executive Summary
This is the project about the makeable application database design which is used to store the
various users’ information, the target users are the carer and the people with disability.
This app will enable the people with disability and carer to use the app to create their profile
where they select their category, the selected categories has the identities like vision, autism,
speech and learning from where the users will select from.
Each identity has the various functions from which the users select from like the sight
assistance and magnification then the user completes the process by viewing the profile. After
the complete process the user receives the reviews of the matched applications that he can use
for his problem.
In this project the following activities are also covered literature review, Gantt Chart, project
budgeting, identification of Hardware Requirements, Software Requirements, Functional
Requirements, Non-Functional Requirements, discussing the project Methodology, Project
Scope, performing the Feasibility Analysis, and Risk Constraint analysis. However in this
project there will also be presentation of the Use case diagrams and descriptions, designing of
the Network Architecture/ Architectural Diagram, Project Flow Chart and ER Diagram/
Protocols and Technologies.
3

Introduction
This is a project concerning the development of the makeable application development that is
aimed at helping various app users with various disabilities which includes physical or mental
problems and thus enabling them to connect to the current technologies.
The project app will be developed using the flutter technologies and it will have the back end
database system that will keep record of the various user’s profiles, however this app will be
able to list the various applications and devices, various help tips, the users’ reviews and
guides for various people that helps others as well.
Therefore the makeable app will be mainly be used by the various people with disabilities
and the people that willing to take care of people with disability.
This project will cover various aspects which includes the literature review, Gantt Chart,
project budgeting, identification of Hardware Requirements, Software Requirements,
Functional Requirements, Non-Functional Requirements, discussing the project
Methodology, Project Scope, performing the Feasibility Analysis, and Risk Constraint
analysis. However in this project there will also be presentation of the Use case diagrams and
descriptions, designing of the Network Architecture/ Architectural Diagram, Project Flow
Chart and ER Diagram/ Protocols and Technologies.
Literature Review
As per the research done by [1], the essential thing about a web server is that it should have
the ability to tackle much number of users in an efficient way. For this purpose the
programming language that should be chosen has to be selected in a careful manner. Server
side scripting languages such as PHP, Python has to be compared with Node.js. As per the
authors Node.js is a very good tool in case the application that is to be developed has to
include live interaction along with real-time results. Node.js has the capability to quickly
deliver data up and down a specific web server. Some years back, with CPU performing a
single thing at a time, people had to face lot of problems. Multi-threading was the solution to
this problem that allowed users to have multiple threads on a CPU. It has switch in between
them every time resulting in lots of overhead. Node.js came as a solution to this overhead
problem by running in a single event-driven thread. It is just that instead of developing a new
thread every time when a request is made it can use only one thread for every single request.
When making a call to a database for instance instead of blocking it till it gets returned one
can run a call-back function after completion of the call. The only thing is that at a time only
4

one call back function can be executed. All other functions such as incoming HTTP request is
easily handled by Node simultaneously. The application code will not be executed at time
when anything else is getting executed thus having the full attention of Node’s JavaScript
engine while it is on the run mode. Node.js has a good performance when considering
multiple users as compared to PHP and Python. The authors suggest that selecting a proper
database is very important taking into consideration a web server. Softwares such as Node.js
help application developers to establish connection of their applications with their database
easily and they do not have to worry about the coding at the server side.
As per the research done by [2], mobile applications can certainly be made use of by
the disabled people. The Web Accessibility Initiative (WAI) addresses accessibility of the
mobile applications. ISO 9241-201:2010 provides proper guidelines for the human centred
design for interactive systems. Involving disabled people in these applications designs is not
an easy process rather it is tough to cater to the needs and requirements of these people.
Mobile assistive technologies have become one of notable achievements in case of disabled
people. Application developers are coming up with various applications that can be used by
people with impairments. Authors are of the opinion that these applications have various
benefits such as ease of portability, lasting benefit and other psychological benefits. The key
or vital concept in designing mobile application interface is accessibility. The main element
of accessible application is set of certain functional elements that make it possible for the
people with impairments to use the same for various purposes. Designing applications for
people with impairments also means that they can be used by everyone that is the central
concept is “Design for all”. Another important concept is usability and this can be said to as
closely relate to accessibility. It not only considers how these applications work but also how
the end user interacts with the application. Usability of an application refers to three
important features that are effectiveness, satisfaction as well as efficiency. Some
recommendations that are suggested by the author to develop these types of applications are
as follows:
1. Navigation and graphic designs- This includes certain points such as application should
have consistent as well as simple menu, minimal user input, good contrast in between text
and background and many more.
2. Requirements to text- Images should be used for reducing the cognitive load, easy
language with short as well as simple title.
5

3. Personalization- The menu of the application requires being adjustable so that it adapts
well to the user’s needs.
As per the research done by [3], mobile application development is different from the
traditional software development in various ways. Application developers need to consider
various factors that include battery life of host device, lifecycle of the mobile applications
considering frequent interruptions as well as the limited hardware capability of the mobile
devices. On top of these if the applications are to be built for persons with impairments it
requires more functionality. Choosing appropriate framework is another issue in case of the
development of applications. Cross platform development frameworks are available to the
developers and all these have their own advantages as well as disadvantages. Google’s Flutter
is one such cross platform development framework that is made use of in the development of
applications to give it a feeling of website. Cross-platform toolkits as such wrap the native
platform controls providing some cross-platform abstraction over them. The applications
when being built for people with impairments should have a lot of functionalities and thus
developers can certainly make use of Flutters’ rich widget library along with open source
widgets. This makes it a feature-rich platform and the developers find it easy to work it. The
developers that use Flutter make use of Dart as the programming language and the engine of
Flutter compiles application to native ARM code that is packaged with Flutter runtime engine
that allows the user interface to work on not only Android but also on the iOS platforms.
Android Studio 3.1.4 was made use of as IDE for developing Flutter applications. Dart 2.0
was the primary programming language. Flutter requires fewer line of code than its native
counterparts such as Native Android and Native iOS. Thus authors are of the opinion that
cross-platform development frameworks provide various opportunities making applications
compatible to different platforms with a single codebase. High quality applications can be
built by making use of these cross-platform development frameworks.
6

Gantt chart
The below is the makeable app project Gantt chat that shows the various tasks that will be
carried out within a specific time, the chart will therefore provide time schedule to the
development team to ensure that the project is developed and delivered on time.
7

Budgeting
The implementation of the makeable app will require some hardware, software and also
human labour, and therefore the budget will be both recurrent expenditure and non recurrent
expenditure as shown below.
Non Recurrent Expenditures
Non Recurrent Expenditures Costs (USD)
Computers and laptops systems 1500
Printers and stationeries 1000
Network infrastructure 1200
Database server 550
App Hosting server 550
Hard-disk and flash-disk 200
Computer system Software applications 2500
Development application tools 550
Development team payment 4000
Total 12500
Yearly Recurrent Expenditure
Annual Recurrent Expenditure Costs (USD)
Computers and laptops systems 350
Printers and stationeries maintenance cost 250
Computer system Software and applications update cost 250
Computers System and servers maintenance 350
IT employees payment 6000
Total 7500
Overall yearly cost 19700
Hardware Requirements
The following are hardware’s which are required during the system implementation.
8

Hardware Description
Computer system These are computer system used during the app development by the
development team.
Database server This is the special computer system that will be used to host the app
database which will be used to store the user’s details.
Hosting server This is the special computer system that is used to host the developed
application system.
Network cables This is the network connection media that links the various networking
devices and computers in the organization.
Network switch This is a network device that is used to connect the various network devices.
Network router This is the network device that will be used to connect the network to the
internet services.
Printers and stationeries These are the printing devices and materials that will be used for the report
documentation and printing for the customers and development team.
Hard-disk and flash-disk These are the storage devices that are used to store documents and software
and also used to transfer items between computers.
Software Requirements
The following are the software applications that will be used in the entire project:
Software used Descriptions
Microsoft Windows
Operating systems
This is the operating system installed in the development computers and it is used since
it is simple to use and has user friendly interfaces.
Local Database
applications
This is database that is used to save app data locally before is uploaded to cloud
database.
Centralized cloud
database system
This is the database that is provided cloud server database vendors at a cost and stores
the app data remotely.
Android studio 3.1.1 This is the app development tool that is used to implement the makeable app using the
flutter development method.
Flutter development
environment
This is the app development environment that will used to implement the proposed
makeable app system.
9

Functional Requirements
The following are the main functional requirements of the proposed makeable application:
i. The app should allow the users to register and create profile.
ii. The app should display a welcome screen message to the users.
iii. The app should enable user select if is a person with disability or carer.
iv. The app should allow the user select areas need some assistance.
v. The app should allow the user to change area needed some assistance.
vi. The app should show related functions with the previous user selection
vii. The app should allow the user to navigate through the various functions.
viii. The app should provide the reviews, information and tips of the matching apps for
the selected function.
ix. The apps should give options of viewing matching apps or moving to profile.
x. The app should allow viewing of the selected functions.
xi. The app should enable viewing of the details of the matching apps.
Non-Functional Requirements
The following are some of the makeable app non-functional requirements:
i. Performance
The app will be quick to response, high through-put, minimal execution time and large
enough memory store capacity for storing user’s records.
ii. Safety
The app safety will be considered while developing the makeable app and this will be put in
place through the use of backup facility, good project financing and use of skilled team
members.
iii. Availability
The app should be available to the users including the carer and the disabled persons at anay
certain time they want to carry out some operations.
iv. Correctness.
The app should enable the users to redirect to the required app page with no resulting errors.
10

v. Maintainability.
The admin of the app should easily add, delete, update and modify the user’s records.
vi. Security
The makeable app will have security and privacy features will put in place like the logins and
be accessible to various devices.
Methodology
The development of the makeable app will be implemented using the waterfall development model
which has a total of six phases as in the figure below.
i. Phase 1: Requirement Gathering and analysis
11

In this phase the app requirements will be captured and documented using the app
specifications documents by the system analysts.
ii. Phase 2: System Design
In this phase the various identified system requirements from phase one are analyzed and
studied and then a system design is prepared by the system designers and this help in
specification of the hardware and software required and entire system architecture [4].
iii. Phase 3: Implementation
In this phase the app units development is done by referring to the app design form the
designing phase, the app units are developed and tested through the unit testing method.
iv. Phase 4: Integration and Testing
In this phase the app units developed in the implementation phase are integrated to single app
system and then the integration test is carried out to check any fault or failure.
v. Phase 5: Deployment of system
After the full testing of the functional requirements the app is deployed to the user’s
environment and released to the market [5].
vi. Phase 6: Maintenance
In this phase the various issues from the users environments are fixed and patch get released
and an advanced app version is released and thus all changes are fully delivered to the app
users.
Project Scope
The makeable app will cover various aspects which includes the following:
12

i. Gathered app requirements.
ii. Project risks constraints.
iii. Identified Project feasibility.
iv. Designing App database Use case diagrams and descriptions.
v. Designing app Network Architectures/ Architectural Diagram.
vi. Designing Project Flow Charts diagram [6].
vii. Designing the ER Diagrams/ Protocols and Technologies.
Feasibility Analysis
The development of the makeable app will be of great importance to the various people living
with disability both physical and mental, therefore the app is highly feasible due to the
following justification reasons.
i. The app will enable the people with disability access the various apps that give
help tips.
ii. The app will enable the people with disability create a profile with their specific
disability and need.
iii. The app will enable the disabled persons to access the carers.
iv. The app will enable easy adding, updating, deleting and modification of the
disabled and carers records [7].
Risk Constraint analysis
During the development of the proposed app there are various possible risks that might arise
as listed below together with the mitigation methods.
Risk constraints Mitigation methods
Team members Lacking required
skills and techniques.
Training the team members to give them required
skills before start of project.
Tight project schedules Ensuring the system phases are allocated sufficient
time with priorities.
Lack of management skills by
project managers.
Training the team managers on various project
management skills.
Lack of co-operations among team
members.
Ensure the team members are well facilitated and
motivated to improve their productivity.
Low budget estimate and Assessing the project to get the specific figure while
13

allocation. doing the budget allocations.
Use case diagrams and descriptions
Use case diagram.
[8].
Use case description
The above is the makeable project use case diagram that illustrates how the various system
users who are actors perform some operations as discussed below.
Purpose:
This use case diagram is meant to show how the people with disabilities and carer make use
of the makeable app to create their personal profiles.
Summary:
The main aim of the makeable apps is to enable the users to create their profiles according to
their respective categories, in this case we have various use cases including the Selecting
disabled person option, Selecting care giver, Selecting areas that one need some assistance,
changing areas of assistance, navigating through functions, selecting the app functions,
viewing the matching apps details, review the matching apps information, and viewing the
user profile use cases.
In this use case diagram there are three actors who includes the carers, people with disability
and the administrators, both the carers and the disabled people creates the user profiles where
14

they select area of the assistance, the various functions and view the matching apps that
match their needs, moreover the admin is responsible of making various modification of the
users profiles.
Description:
No. Use cases Description Actors
1. Selecting disabled
person option
In this the disabled person creates a profile by
selecting the person with disability option.
Disabled
2. Selecting care giver In this the carers creates a profile by selecting
the carer option.
carer
3. Selecting areas that
one need some
assistance
In this the person with disability select form the
various options the area that he require some
help.
Disabled
4. Changing areas of
assistance.
This is where the person with disability changes
the area of assistance in case they made errors
during the initial selection.
Disabled,
admin
5. Navigating through
functions.
This is where the person with disability or the
carer views various functions available
according to the area selected.
Disabled,
carer
6. Selecting the app
functions.
This is where the person with disability or the
carer selects functions from available functions.
Disabled,
carer
7. Viewing the
matching apps
details.
This is where the person with disability views
the various details of the app that match their
need areas.
Disabled,
carer
8. Review the matching
apps information.
This is where the person with disability check
on the reviews about the matching apps
provided after selecting the area.
Disabled,
carer
9. Viewing the user
profile
This is where the disabled and the carer view
their created profiles or even the admin view
the users profile and either delete or update
them.
Disabled,
carer, admin
15

Network Architecture/ Architectural Diagram
The below is the project network and architectural diagram that indicate the various
components in the app running environment which includes the app users, the access devices
including the phones, the cloud database server and app hosting server [9].
16

Project Flow Chart
The following is the flow chart diagram indicating the various functions of the system and the
flow of the events in the proposed makeable app.
[10].
ER Diagram/ Protocols and Technologies
The below is the entity relationship diagram that will be used as a prototype to implement the
database for the makeable application.
17

[11].
18

Reference
[1]. S.L. Bangare, S. Gupta, M. Dalaland A. Inamdar. Using Node. Js to build high speed and
scalable backend database server. In Proc. NCPCI. Conf (p. 19).2016, March.
[2]. J. Dekelver, M. Kultsova, O. Shabalina, J. Borblik, A. Pidoprigora and R. Romanenko.
Design of mobile applications for people with intellectual disabilities. Communications in
Computer and Information Science, 535, pp.823-836.2015.
[3]. M. Gonsalves. Evaluating the mobile development frameworks Apache Cordova and
Flutter and their impact on the development process and application characteristics.2019.
[4]. B. Dick. IT Project Management Essentials: Information Systems Project Methodology
Kindle Edition. Amazon Digital Services LLC,500,pp.120-121.2018
[5].E. Elmasri.Database Systems: Models, Languages, Design and Application Programming.
PEARSON EDUCATION, 450.pp 58-68, 2015.
[6]. Ramez,E. Database Systems: Models, Languages, Design and Application Programming
/ International Edition Paperback. PEARSON EDUCATION,980. pp 589-592, 2016.
[7].B. Shamkant.Fundamentals of Database Systems. India:pearson,1200.pp1012-1015, 2016.
[8]. C. Thomas. Database Systems: A Practical Approach to Design, Implementation and
Management: WITH Success in Your Project.Addison Wesley,600.pp112-115, 2015.
[9]. H. Stephen, Management Information Systems with student CD and MISource.
McGraw/Hill, 800.pp225-230, 2016.
[10]. B. Paige. Business Driven Information Systems with MISource 2007 and Student CD.
McGraw/Hill, 750.pp205-220, 2016.
[11]. I. Specialist. CISSP Certified Information Systems Security Professional Study Guide
2018. New York:Independently published, 950.pp500-520, 2017.
19