System Analysis & Design for Pine Valley Furniture

This article discusses the system analysis and design for Pine Valley Furniture, an online library for study material with solved assignments, essays, dissertation etc. It covers the data to be collected on customer profile form, profile form for family customers, demographics summary report, and customer purchasing frequency report.

1
Running head: SYSTEM ANALYSIS AND DESIGN
System Analysis and Design
Student’s Name
School Affiliation

2
SYSTEM ANALYSIS AND DESIGN
1. Introduction
The Pine Valley Furniture is concerned with the processing of high quality made from the wood
furniture and it also supplies these materials around the United States. The firm started back in
the early 1980s with aim of manufacturing custom furniture for clients (Tangjang, and Nair,
2016). That time the records were preserved in a cabinet of a file but over years it has evolved
and came up with Information System for meeting the requirements of the users and
administrators from different locations. Currently, the firm is split in various locations within the
United States and in order to meet the requirements of the users satisfactorily came with this
system of automating services across different locations (Valacich, George, and Valacich, 2017).
Now the firm has an idea of developing an e-commerce website comprising of several forms of
customers such as home office, family as well as a student among other in order to uphold
competition with other companies offering similar services. The main purpose of the Pine Valley
Furniture Information System is to advance the sales as well as the ultimate benefits of the firm.
Through this system, the Pine Valley Furniture system expects a smooth flow of the company by
minimizing the cost of labor and management overhead costs.
2. Data to be collected on Customer Profile Form
Tracking System for customers of Pine Valley Furniture needs to be implemented which
involves the creation of the customer profile forms. In order to understand the needs of every
customer's several forms need to be developed but, in our case, will focus on family customers
profiles which are created when new clients place their initial order (Van der Wagen, and White,
2018). The customers will be expected to fill the whole form and accurately to accomplish the
process and so as to motivate the customers there will be a provision of 10% discount on the
average customer order who accomplishes the creation of the profile successfully. The existing

3
SYSTEM ANALYSIS AND DESIGN
clients will also be given a chance to participate in the user profiling method. Customer profile
data will be gathered through a client profile form. The information required mostly are the
individual details such as name, phone number, address, id, email, location as well as income
information, profession origin, booking information, requirements of the furniture, details of the
budget, size of the family as well as the interest level again might be available in the sheet of the
profile of the users such as comments among others (Butler et al., 2015).
3. Profile Form for Family Customers
The client profile form is utilized to gather data from clients in order the Pine Valley Furniture
can develop and keep their user database. The diagram below indicates the profile form of a
customer.

4
SYSTEM ANALYSIS AND DESIGN
The explanation of the information gathered is provided below:
Firm Name, the system produces User Id and the data available on the form.
The radio buttons are utilized to guarantee the correct selection of the choices and the edit texts
are for the provision of the required details in the appropriate formats.
The name field – the user is expected to supply full names and correctly and in case the order is
not followed the system prompts for an error message.
Age field – the user is required to supply their ages based on the correct format of the dates.
Phone number field – the user should provide at least 10 numerical in order to be validated.
Email field – the user should supply correct email with the appropriate format.
Address field – the customer should provide the resident house number, the name of the street,
city where he or she comes from, province, a country he or she originates and the zip code of the
city.
The system automatically gives a new user Id in order to avoid duplication of details since it is
unique.
The save button – this aid the user to in submitting the details into the system database.
Cancel button – the user can cancel the whole form if he opts to continue later.
Help button – in case the customer needs any assistance can click the help button and the
possible solution is offered relevantly.

5
SYSTEM ANALYSIS AND DESIGN
Next button – this aid the user once has completed the registration to move to the next window of
the system.
The alert for a discount is colored red to draw the user’s attention and the asterisk is utilized to
indicate the mandatory fields.
The form also consists of the buttons for saving data, canceling the process, requesting for help
and the button to allow the user to navigate in the next window.
4. Demographics Summary Report for Pine Valley Furniture
The demographic commerce analysis aids in achieving a various goal, to begin with, it helps in
discovering and identifying which sectors, as well as subgroups, live in the given population and
to produce a comprehensive reflection of the characteristics that an ordinary member of every
one of the sectors executes. The demographic reports in place have depicted effective techniques
for drawing the attention of the focused group of individuals for a given item in the globe
(Mulcahy et al., 2016). The reports incorporate global information to assist the marketers to
reach details involving each and every potential focused market. The demographic market study
reports can also aid in characterizing unique demographic profile. Generating a profile might
offer information concerning an ordinary participant for a given group to help in producing a
visual of a theoretical focus market. Demographics are the characteristics of a chosen human
population. Demographic emerging issues can be established through information comprising of
age, race, income, gender, location just mentions a few (Barrett et al., 2017). By using this
emerging information, one is capable of analyzing modifications in a certain population over a
given span of time and can also this information can help in economic as well as marketing
decision making. In reference of the requirement of the sales as well as a marketing category, the

6
SYSTEM ANALYSIS AND DESIGN
products by demographic summary report can offer details concerning sales by region, customer
category, product categories and is provided as shown below.
Name of the Product: …………………….
Product Type: Dining Sofa Kitchen Wardrobe Computer Desk
Range: 15k - 20k 20k – 50k 50k – 1I 1I and above
Specification: Length Width
Usage: Short Term Long Term
Category: Dining Room Kitchen Study Drawing
Color: Light Dark
Name of the product – the user is expected to indicate the name of the item in need.
Product type – the customer is required to choose the items he or she wants by checking the
checkboxes.
Range – the user is expected to indicate the range of amount he or she has in reference to the
demand of the product selected.
Specification – the customer needs to input the length as well as the width of the item needed.
Usage – the customer should indicate the duration of the item requested by either selecting the
short-term or long-term usage.
Category – the customer indicates the classification of the item in need and where to be used.

7
SYSTEM ANALYSIS AND DESIGN
Color – the user should be in a position to choose between the two colors.
The following are samples of products by the demographic summary report.
Sales by product.
Sales by region

8
SYSTEM ANALYSIS AND DESIGN
The information or ratio of sales incorporated in the study on the basis of several classifications
is as provided below.
The name of the company and date are provided on the report.
Sale by item pie chart shows the quantity of the product sold in every region.
Users are classified in reference to their age. The final pie chart provides details on which
classification of users has purchase how much items.
5. Customer Purchasing Frequency Report
The user purchasing frequency report provides data on the frequency of the buying of the users,
from which different conclusions on their purchases can be met. The diagram below shows the
design of the customer purchasing frequency report:

9
SYSTEM ANALYSIS AND DESIGN
The information illustrated above is a personalized report that implies that on requesting a report
about the specific user by his or her user Id, the system produces a report. The following is the
explanation of the report above:
The report comprises of the name of the company as well as the date.

10
SYSTEM ANALYSIS AND DESIGN
It depicts the details of the user such as the name of the customer, the id of the customer, for the
whom the above report is produced for.
The purchasing frequency is depicted by the graph and the amount of the purchases carried out
throughout the year is depicted here, again can generate monthly report too.
Buttons are provided to aid the functionality of discarding the report, printing the report as well
as saving the report for future use.
The system is designed in a such a way it provides the report of the necessary items such as the
id of the customer, name of the customer, the date customer joined, the amount of the purchase
the user has made, the date of the last purchase. The date of the generation of the report is system
generated in respect to the region of the customer. The above report can be printed and filed then
filed in a cabinet for back up in future in case of system failure. The graph indicates the
performance of the purchases by users over the years.

11
SYSTEM ANALYSIS AND DESIGN
6. References
Barrett, K. J., Brown, P. M., Clement, J., Cannon, J. B., Wolk, B., & Cheng, A. S. (2017). 2017
Ecological, Social and Economic Monitoring Plan.
Butler, P. R., Iverson, L., Thompson, F. R., Brandt, L., Handler, S., Janowiak, M., ... &
Connolly, S. (2015). Central Appalachians forest ecosystem vulnerability assessment and
synthesis: a report from the Central Appalachians Climate Change Response Framework
project. Gen. Tech. Rep. NRS-146. Newtown Square, PA: US Department of Agriculture,
Forest Service, Northern Research Station. 310 p., 146, 1-310.
Mulcahy, A. W., Kapinos, K. A., Briscombe, B., Uscher-Pines, L., Chaturvedi, R., Case, S. R., ...
& Miller, B. M. (2016). Toward a sustainable blood supply in the United States. Rand
Corporation, Santa Monica, CA.
Tangjang, S., & Nair, P. R. (2016). Integrated bamboo+ pine homegardens: a unique agroforestry
system in Ziro Valley of Arunachal Pradesh, India. Int J Environ Agric Res, 2, 25-34.
Valacich, J. S., George, J. F., & Valacich, J. S. (2017). Modern systems analysis and design.
Pearson Education Limited.
Van der Wagen, L., & White, L. (2018). Event management: For tourism, cultural, business and
sporting events. Cengage AU.