Chapter One – Getting Started
© 2018 Pearson Education, Inc. Page 14 of 25
Online transaction data is stored in an online transaction processing (OLTP) database.
Companies build data warehouse to store data needed for data analysis in a business
intelligence (BI) system, which includes tools such as online analytical processing (OLAP)
systems.
1.35 What is Big Data? What is a NoSQL database? What are Web 2.0 applications, and
why can’t these applications use a relational database?
1.36 What is cloud computing? Where are the hardware and network resources used in cloud
computing located?
ANSWERS TO EXERCISES
The following spreadsheets form a set of named spreadsheets with the indicated column
headings. Use these spreadsheets to answer exercises 1.37 through 1.39.
A. Name of Spreadsheet: EQUIPMENT
Column Headings:
(Number, Description, AcquisitionDate, AcquisitionPrice)
Chapter One – Getting Started
1.37 For each of the spreadsheets provided, indicate the number of themes you think the
spreadsheet includes and give an appropriate name for each theme. For some of them,
the answer may depend on the assumptions you make. In these cases, state your
assumptions.
1.38 For any spreadsheet that have more than one theme, show at least one modification
problem that will occur when inserting, updating, or deleting data.
1.39 For any spreadsheet that has more than one theme, break up the columns into tables
such that each table has a single theme. Add ID columns if necessary, and add a linking
column (or columns) to maintain the relationship between the themes.
Chapter One – Getting Started
© 2018 Pearson Education, Inc. Page 16 of 25
D. One or Two tables:
COMPUTER (SerialNumber, Make, Model, DiskType, DiskCapacity)
or
COMPUTER (SerialNumber, Make, Model)
MAKE-MODEL (Make, Model, DiskType, DiskCapacity)
E. Four tables:
PERSON (PersonID, Name, DateOfHire, DeptName)
DEPARTMENT (DeptName, DeptManager)
PROJECT (ProjectID, ProjectManager)
ASSIGNMENT (ProjectID, PersonID, NumHours)
ANSWERS TO SAN JUAN SAILBOAT CHARTERS CASE QUESTIONS
San Juan Sailboat Charters (SJSBC) is an agency that leases (charters) sailboats.
SJSBC does not own the boats. Instead, SJSBC leases boats on behalf of boat owners
who want to earn income from their boats when they are not using the boats themselves,
and SJSBC charges the owners a fee for this service. SJSBC specializes in boats that
can be used for multiday or weekly charters. The smallest sailboat available is 28 feet in
length, and the largest is 51 feet in length.
Each sailboat is fully equipped at the time it is leased. Most of the equipment is provided
at the time of the charter. The majority of the equipment is provided by the owners, but
some is provided by SJSBC. Some of the owner-provided equipment is attached to the
boat, such as radios, compasses, depth indicators and other instrumentation, stoves,
and refrigerators. Other owner-provided equipment is not physically attached to the boat,
such as sails, lines, anchors, dinghies, life preservers, and equipment in the cabin
(dishes, silverware, cooking utensils, bedding, and so on). SJSBC provides consumable
supplies such as charts, navigation books, tide and current tables, soap, dish towels,
toilet paper, and similar items. The consumable supplies are treated as equipment by
SJSBC for tracking and accounting purposes.
Keeping track of equipment is an important part of SJSBC’s responsibilities. Much of the
equipment is expensive, and those items not physically attached to the boat can be
easily damaged, lost or stolen. SJSBC holds the customers responsible for all of the
boat’s equipment during the period of their charter.
Chapter One – Getting Started
A. Create a sample list of owners and boats. Your list will be similar in structure to that in
Figure 1-34, but it will concern owners and boats rather than owners and pets. Your list
should include, at a minimum, owner name, phone, and billing address, as well as boat
name, make, model, and length.
B. Describe modification problems that are likely to occur if SJSBC attempts to maintain the
list in a spreadsheet.
C. Split the list into tables such that each has only one theme. Create appropriate ID
columns. Use a linking column to represent the relationship between a boat and an
owner. Demonstrate that the modification problems you identified in part B have been
eliminated.
BOAT:
OWNER:
Chapter One – Getting Started
D. Create a sample list of owners, boats, and charters. Your list will be similar to that in
Figure 1-35. Your list should include the data items from part A as well as the charter
date, charter customer and the amount charged for each charter.
E. Illustrate modification problems that are likely to occur if SJSBC attempts to maintain the
list from part D in a spreadsheet.
F. Split the list from part D into tables such that each has only one theme. Create
appropriate ID columns. Use linking columns to represent relationships. Demonstrate
that the modification problems you identified in part E have been eliminated.
BOAT:
OWNER:
Chapter One – Getting Started
CUSTOMER:
CHARTER:
ANSWERS TO GARDEN GLORY PROJECT QUESTIONS
Garden Glory is a partnership that provides gardening and yard maintenance services to
individuals and organizations. Garden Glory is owned by two partners. They employ two
office administrators and a number of full- and part-time gardeners. Garden Glory will
provide one-time garden services, but it specializes in ongoing service and maintenance.
Many of its customers have multiple buildings, apartments, and rental houses that
require gardening and lawn maintenance services.
A. Create a sample list of owners and properties. Your list will be similar in structure to that
in Figure 1-34, but it will concern owners and properties rather than owners and pets.
Your list should include, at a minimum, owner name, phone, and billing address, as well
as property name, type, and address.
PropertyName
PropertyType
Address
OwnerName
OwnerPhone
BillingAddress
Jones Home
Residence
Elm St
E.J. Jones
223-1111
2nd Street
Eastlake Office
Office
Elm St
E.J. Jones
223-1111
2nd Street
Samish
Park
East Park
City
222-0030
City Hall
Westview
Park
West Park
City
222-0030
City Hall
Chapter One – Getting Started
B. Describe modification problems that are likely to occur if Garden Glory attempts to
maintain the list in a spreadsheet.
C. Split the list into tables such that each has only one theme. Create appropriate ID
columns. Use a linking column to represent the relationship between a property and an
owner. Demonstrate that the modification problems you identified in part B have been
eliminated.
PROPERTY:
PropertyName
PropertyType
OwnerID
Jones Home
Residence
100
Eastlake
Office
Office
100
Samish
Park
200
Westview
Park
200
OWNER:
OwnerName
OwnerPhone
BillingAddress
E.J. Jones
223-1111
2nd Street
City
222-0030
City Hall
Chapter One – Getting Started
D. Create a sample list of owners, properties, and services. Your list will be similar to that in
Figure 1-35. Your list should include the data items from part A as well as the date,
description, and amount charged for each service.
PropertyName
Type
Address
OwnerName
OwnerPhone
BillingAddress
Date
Desc
Charge
Jones Home
Residence
Elm St
E.J. Jones
223–1111
2nd Street
2/2/14
…
125.00
Eastlake
Office
Office
Elm St
E.J. Jones
223–1111
2nd Street
2/7/14
…
78.44
Samish
Park
East
Park
City
222–0030
City Hall
2/2/14
…
99.50
Westview
Park
West
Park
City
222–0030
City Hall
3/7/14
…
224.99
Eastlake
Office
Office
Elm St
E.J. Jones
223–1111
2nd Street
2/14/14
…
78.44
Eastlake
Office
Office
Elm St
E.J. Jones
223–1111
2nd Street
2/22/14
…
100.00
Westview
Park
West
Park
City
222–0030
City Hall
3/14/14
…
224.99
(Note: Description [Desc] data is omitted from above because there is no room to enter it.
Assume some legitimate description has been entered.)
E. Illustrate modification problems that are likely to occur if Garden Glory attempts to
maintain the list from part D in a spreadsheet.
F. Split the list from part D into tables such that each has only one theme. Create
appropriate ID columns. Use linking columns to represent relationships. Demonstrate
that the modification problems you identified in part E have been eliminated.
ANSWERS TO JAMES RIVER JEWELRY PROJECT QUESTIONS
[NOTE: The James River Jewelry Project Questions are available online in Appendix D,
which can be downloaded from the textbook’s Web site:
www.pearsonhighered.com/kroenke. The solutions for these questions will be included
in the Instructor’s Manual for each chapter]
James River Jewelry is a small jewelry shop. While James River Jewelry does sell
typical jewelry purchased form jewelry vendors, including such items as rings,
necklaces, earrings, and watches, it specializes in hard-to-find Asian jewelry. Although
some Asian jewelry is manufactured jewelry purchased from vendors in the same
Chapter One – Getting Started
manner as the standard jewelry is obtained, many of the Asian jewelry pieces are often
unique single items purchased directly from the artisan who created the piece (the term
“manufactured” would be an inappropriate description of these pieces). It has a small but
loyal clientele, and it wants to further increase customer loyalty by creating a frequent
buyer program. In this program, after every 10 purchases, a customer will receive a
credit equal to 50 percent of the sum of his or her 10 most recent purchases. This credit
must be applied to the next (or “11th”) purchase.
A. Create a sample list of customers and purchases and a second list of customers and
credits. Your lists should include customer data you think would be important to James
River along with typical purchase data. Credit data should include the date of the credit,
the total amount of the 10 purchases used as the basis of the credit, and the credit
amount.
B. Describe modification problems that are likely to occur if James River attempts to
maintain the lists in a spreadsheet.
C. Split the lists into tables such that each has only a single theme. Create appropriate ID
columns. Use one ID to represent the relationship between a purchase and a customer
and use another ID to represent the relationship between a credit and a customer.
Chapter One – Getting Started
D. Attempt to combine the two lists you created in part A into a single list. What problems
occur as you try to do this? Look closely at Figure 1-34. An essential difference exists
between a list of the three themes customer, purchase, and credit and a list of the three
themes PetName, Owner, and Service in Figure 1-34. What do you think this difference
is?
E. Change the tables from part C so that the purchase list has not only the ID of Customer
but also the ID of Credit. Compare this arrangement to the tables in your answer to
question 1.15. What is the essential difference between these two designs?
Chapter One – Getting Started
ANSWERS TO THE QUEEN ANNE CURIOSITY SHOP PROJECT QUESTIONS
The Queen Anne Curiosity Shop sells both antiques and current-production household
items that complement or are useful with the antiques. For example, the store sells
antique dining room tables and new tablecloths. The antiques are purchased from both
individuals and wholesalers, and the new items are purchased from distributors. The
store’s customers include individuals, owners of bed-and-breakfast operations, and local
interior designers who work with both individuals and small businesses. The antiques
are unique, although some multiple items, such as dining room chairs, may be available
as a set (sets are never broken). The new items are not unique, and an item may be
reordered if it is out of stock. New items are also available in various sizes and colors
(for example, a particular style of tablecloth may be available in several sizes and in a
variety of colors).
A. Create a sample list of purchased inventory items and vendors, and a second list of
customers and sales. Your first list should include inventory data such as a description,
manufacturer and model (if available), item cost, and vendor identification and contact
data you think should be recorded. The second list should include customer data you
think would be important to The Queen Anne Curiosity Shop, along with typical sales
data.
B. Describe problems that are likely to occur when inserting, updating, and deleting data in
these spreadsheets.
There will be similar problems for the CustomerSales spreadsheet, plus there may be problems
between spreadsheets if an item is deleted. The ItemID will be deleted, but what will we do
with the sale data?
Chapter One – Getting Started
C. Attempt to combine the two lists you created in part A into a single list. What problems
occur as you try to do this?
D. Split the spreadsheets you created in part A into tables such that each has only one
theme. Create appropriate ID columns.
E. Explain how the tables in your answer to part D will eliminate the problems you identified
in part B.
F. What is the relationship between the tables you created from the first spreadsheet and
the tables you created from the second spreadsheet? If your set of tables does not
already contain this relationship, how will you add it into your set of tables?