Database Modification in Fiber Fashion | Report

Running head: DATABASE MODIFICATION IN FIBRE FASHION
Database Modification in Fibre Fashion
Name of the Student
Name of the University

DATABASE MODIFICATION IN FIBRE FASHION1
Table of Contents
Introduction:....................................................................................................................................2
Research Questions:.........................................................................................................................2
Literature Review:...........................................................................................................................3
Analysis of Literature:.....................................................................................................................7
Conclusion:......................................................................................................................................9
Recommended Solution:................................................................................................................10
References:....................................................................................................................................12

DATABASE MODIFICATION IN FIBRE FASHION2
Introduction:
The following report deals with Fiber fashion which is an Australia based company. At
present, the firm makes use of end user-user database. Fiber come up with consistent presence in
the wholesale fashion industry for around 20 years. Similar to design, Fiber focus on humble
beginning by making use of classical lines (Chan, Ngai & Moon, 2017). The organization has a
fledgling business which has developed and flourish with colour. The organization has fabulous
labels which are considered as the masterpiece of wardrobe. Fiber aims to accessories which can
complement the inner look of the city warehouse. It comes up knowledgeable staff and
homemade treats like the icon (Pedersen, Gwozdz & Hvass, 2018). The report deals with the
design of a database system which can be used by fiber fashion in order to assist their business.
The new database system at Fiber Fashion can provide a list of benefits like reduces data
redundancy, data sharing, data integrity and complete privacy of data.
In the coming pages of report, an idea has been provided regarding current issue due to
use of end-user database. The organization has makes use of spreadsheet for keeping all the
details of the client and sale obtained on each brand. Fiber aims to represent a list of brand on
global platform. The report provides a background to solve the issues of the plan. A list of
research questions has been identified for the given topic. A proper analysis has been done
regarding current issues. A list of solution has been recommended that how this new database
system will help in assisting the business.
Research Questions:

DATABASE MODIFICATION IN FIBRE FASHION3
The primary objective of the research study is to find ways of improving the current IS
and database system. The research study will intensively focus on identifying various possible
solutions for database requirement as well as showing the features of each solution.
i. How current database is failing to meet the need of organizational processes?
ii. What are the existing database system that can support Fibre Fashion?
iii. What are the features and capacity of relational database?
iv. Is NoSQL database preferable in current scenario?
v. What are database management best practices in online retail shops?
vi. What are the technologies that can provide rich interface for chosen databases?
Literature Review:
According to Todeschini et al., (2017), relational database system is the most common
kind of database where all data is stored in the table. Database used in fashion industry are
known to be relational database. Relational database come up with clout needed for handling
multitudes for data and complex queries. The flat file takes up both space and memory and is
very much less efficient. Data are merely stored in lot of table or even in relation. The table is
divided into both the ways that is rows and columns (Lee, Seifert & Cherrier, 2017). SQL query
is the process which help in getting access to data. SQL stand for structure query language. SQL
query is very much helpful in creating, deleting and modification of table. Relational database
aims to provide huge number of benefits like manageability, flexibility and avoiding errors. The
point should be noted that relational databases are very easy to manipulate. Each of the data table
can be updated without any kind of disruption of others. Most of the RBDMS makes use of SQL
for getting access to data found in the tables (Sudha & Sheena, 2017). SQLite stand out to be a