Dirt Bikes U.S.A. sells primarily through its distributors.
to download the database file. It maintains a
forward it to Dirt Bikes. Dirt Bikes would like to be able to
ively to its customers. The marketing
of special racing events and of sales on parts. It would
bike racing events. In addition, Dirt Bikes would like to
motorcycle. If a motorcycle was purchased from Dirt
purchased. If the customer owns a non
motorcycle, the company would like to know the
manufacturer and model of the other motorcycle (or
motorcycles) and the distributor from whom t
he
customer purchased that motorcycle.
On the basis of the above information, perform the
following activities:
1.
Redesign Dirt Bikes’ customer database so that it
can store and provide the information needed
for marketing. You will need to develop a design
for the new customer database and then
implement it using database software. Consider
using multiple tables in your new design.
Populate each new table with 10 records.
2.
Develop reports that would be of interest to Dirt
Bikes’ marketing and sales department
(for
example, lists of repeat Dirt Bikes customers, Dirt
Bikes customers who attend racing events, or the
average ages and years of schooling of Dirt Bikes
customers) and print them.
Task 2:
The management is concerned that Dirt Bikes’ computer
systems
could be vulnerable to power outages,
vandalism, computer viruses, natural disasters, or
telecommunications disruptions. You have been asked to
perform an analysis of system vulnerabilities and disaster
recovery planning for the company.
Answer the questio
ns below. You may refer to Table 7.2,
“Examples of Computer Crime,” on page 242 of your
textbook for more information.
1.
Identify the threats to which Dirt Bikes’ systems
are most vulnerable.
Classify the most critical systems at Dirt Bikes.
What would be th
e impact on the company if
these systems could not operate? How long
could the company survive if these systems were
down? Which systems are the most important to
back up and restore in the event of a disaster?
3.
Use the Internet to locate two disaster reco
very
services that could be used by a small business,
such as Dirt Bikes. Compare them in terms of the
services they offer. Which of the two services
should Dirt Bikes use? How would these services
help Dirt Bikes recover from a disaster?
Task 3:
Dirt Bik
es cannot fulfill many of its orders on time
because of delays in sourcing some important motorcycle
components and parts, such as fuel tanks. Complaints are
mounting from distributors who fear losing sales if the
dirt bikes they have ordered are delayed t
oo long. Dirt
Bikes’ management has asked you to help address some
of its supply chain issues. Based on this information,
answer the questions listed below:
1.
Use the Internet to locate alternative suppliers
for motorcycle fuel tanks. Identify two or three
s
uppliers. Find out the time and the cost of
shipping a fuel tank (weighing about five pounds)
by ground (surface delivery) from each supplier
to Dirt Bikes in Carbondale, Colorado. Which of
these suppliers is likely to ship the fuel tanks in
the shortest a
mount of time and at the lowest
cost?
The management wants to know about any
supply chain management software that would
be appropriate for a small business, such as Dirt
Bikes. Use the Internet to locate two providers of
supply chain management software.
Briefly
describe the capabilities of the two software
applications and indicate how they could help
Dirt Bikes. Which of these products would be
more appropriate for Dirt Bikes? Why?
3.
(Optional) Use electronic presentation software
to summarize your findin
gs for management.
Task 4:
Dirt Bikes’ management believes that the company could
benefit from e
–
commerce. The company sells motorcycles
and parts primarily through authorized dealers. It also
advertises in various magazines catering to dirt bike
enthusi
asts and maintains booths at important off
–
road
motorcycle racing events. You have been asked to explore
how Dirt Bikes could benefit from e
–
commerce and by
selling online through a website.
1.
Prepare a report for management that answers
the following
questions:
a.
How could Dirt Bikes benefit from e
–
commerce? Should it sell its
motorcycles or parts online? Should it
use its website to advertise its products
and services or to offer customer
service?
b.
How would a website provide value to
Dirt Bikes? Use th
e Internet to research
BU1
3
1
Project
9
Project
Part
Description/Requirements of Project Part
Evaluation
Criteria
the cost of an e
–
commerce site for a
small
–
to medium
–
sized company. How
much revenue or cost savings would the
website have to produce to make it a
worthwhile investment for Dirt Bikes?
2.
Prepare specifications to describe the function
s
that should be performed by Dirt Bikes’ website.
Provide links to other websites or systems in
your specifications.
3.
(Optional) Design the home page for Dirt Bikes’
website along with an important secondary page
linked to the home page using a word proces
sor
or a Web page development tool of your choice.
4.
Identify some important website features that
can be used to create customer relationships.
Analyze the challenge that Dirt Bikes may face in
the course of creating customer intimacy and
loyalty.
Task 5:
Dirt Bikes promotes itself as a “learning company.” It
encourages employees to undergo training to help them
advance in their careers. As employees move on, their
positions fall vacant. These positions must be filled
quickly to maintain the company’s pace
of production.
Dirt Bikes’ human resources staff would like to find a way
of quickly identifying qualified employees who have the
training to fill vacant positions. Once the company knows
who these employees are, it has a better chance of filling
open pos
itions internally rather than paying to recruit
outsiders. Dirt Bikes would like to track each employee’s
BU1
3
1
Project
10
Project
Part
Description/Requirements of Project Part
Evaluation
Criteria
years of education and the title and date of completion of
any training that each employee has attended. Dirt Bikes’
existing employee database is lim
ited to basic human
resources data, such as employee name, identification
number, birth date, address, telephone number, marital
status, job position, and salary. Click
here
to download
some sample records from this database. Dirt Bikes’
human resources staff maintains employees’ skills and
training data in paper folders.
On the basis of this information
, prepare a system
analysis report describing Dirt Bikes’ problem and
suggesting a solution that can be implemented using
database software. The report should include the
following points:
Description of the problem and its organizational
and business impa
ct
Proposed solution and solution objectives
Information requirements to be addressed by
the solution
People, organization, and technology issues to
be addressed by the solution, including changes
in business processes
On the basis of the requirements you have identified,
design the solution using database software and populate
it with at least 10 records per table. Consider whether you
can use or modify the existing employee database in your
design. Print out the design
for each table in your new
application. Use the system to create queries and reports
that would be of interest to the management, such as the
names of employees who have a college education, or
have undergone training in project management
3
1
Project
11
Project
Part
Description/Requirements of Project Part
Evaluation
Criteria
advanced com
puter
–
aided design (CAD) tools. If possible,
use electronic presentation software to summarize your
findings for the management.
Submit a report including the answers to the
questions posed in this part of the project.
Include appropriate databases to supp
ort your
answers.
Submission Requirements:
Submit your findings in an MS Word document.
Submit the updated spreadsheet and database
files.
Font: Arial; 12
–
point
Line Spacing: Double
