[SOLVED] case study database 17spm_L15

$25

File Name: case_study_database_17spm_L15.zip
File Size: 273.18 KB

5/5 - (1 vote)

17spm_L15

Case Study

SPM 2017 Ron Poet Lecture 15 1

Introduction

Case Study

South Coast Nautical Supplies sells everything associated with sailing.

They currently have a website that asks the user to ring a number to
request a catalogue.

They want to start selling things on their site.

SPM 2017 Ron Poet Lecture 15 2

They will start selling books, which are fairly cheap.

o If the site doesnt lose sales compared with the phone and
catalogue, they plan to expand to other items.

The site needs to be live in 30 days time.

Who are the Users

Real users are people who buy sailing books, but we dont have access
to them.

The head of sales and marketing will be a proxy user.

She wants a typical ecommerce site.

SPM 2017 Ron Poet Lecture 15 3

o Search for books.

o Maintain a list of books each customer is interested in.

o Rate books they have bought.

o Check on the status of an order.

User Roles

Initial brainstorming creates the following user roles:

Hardcore sailor, novice sailor, new sailor, gift-buyer, non-sailing
spouse, administrator, head of sales, charter captain, experienced
sailor, sailing school, library, instructor.

SPM 2017 Ron Poet Lecture 15 4

Consolidating Roles

Novice and new sailors combined.

Instructor and sailing school combined.

Hardcore sailor and experienced sailor are both separate roles.

Gift buyer and non-sailing spouse become non-sailing gift buyer.

SPM 2017 Ron Poet Lecture 15 5

Keep administrator.

Head of sales becomes report viewer.

Library becomes librarian.

Role Details

Now work out details for each role under the headings:

o Experience with computers.

o Experience buying online.

o Experience with sailing terms.

SPM 2017 Ron Poet Lecture 15 6

o

The two roles expected to generate most sales are experienced sailor
and instructor.

Create 2 personas.

o Teresa: an experienced sailor.

o Captain Ron: an instructor.

Create Stories

Work through each role in turn for a couple of hours.

Stories for Teresa.

o Search for books by author, title ISBN.

o View detailed information on a book.

SPM 2017 Ron Poet Lecture 15 7

o

o Put books in shopping cart and buy them later.

o Remove books from the cart before buying.

o Enter billing and shipping address, as well as credit card numbers
to buy.

o Rate and review books.

Stories (2)

Teresa (more stories).

o Set up an account that remembers addresses.

o Edit account information.

o Put books in a wish list that is visible to others.

SPM 2017 Ron Poet Lecture 15 8

o

o Can transfer an item from their own or someone elses wish list
into her shopping cart.

o A repeat customer must be able to find one book and complete an
order in less than 90 seconds.This is a constraint.

Captain Ron

Stories for the instructor.Expected to buy the same books regularly
for students.

o View history of past orders.

o Easily repurchase items.

SPM 2017 Ron Poet Lecture 15 9

o See the last three items they looked at, even between sessions.

More Stories by Role

Novice sailor.

o See what books we recommend by topic.

Non-sailing gift buyer.

o Easily see others wish lists.

SPM 2017 Ron Poet Lecture 15 10

o

o Have items gift wrapped.

o Enclose a gift card with their own message.

Report Viewer.

o See daily purchases by category.

o Must be authenticated before viewing reports.

o Website orders must end up in the same database as telephone
orders.Constraint.

More Stories by Role

Adminstrator.

o Add new books.

o Approve reviews.

o Delete a book.

SPM 2017 Ron Poet Lecture 15 11

o

o Edit info about a book.

Customer.

o Check status of recent order and change it if it hasnt been sent.

o Peak usage of 50 concurrent users. Constraint.

Estimates

Developers think about each story in a group and come up with
estimates.

Constraints take 0 story points.

The 27 stories have costs ranging from , 1, 2, 4 and 8 story points.

SPM 2017 Ron Poet Lecture 15 12

Total story points are: 42, average = 1.6.

The Release Plan

The website will be needed in 4 weeks.

2 iterations, each of 2 weeks.

Two programmers estimate they will be able to complete 8 story points
in each iteration (velocity).

SPM 2017 Ron Poet Lecture 15 13

The customer prioritises the stories as must-have, should-have etc.

Must Have Stories, with cost

1-Search for author or title.

1-Put books in shopping cart.

-Remove books from cart before buying.

2-Buy books in cart.

SPM 2017 Ron Poet Lecture 15 14

2-Set up an account.

1-Administrator can add books.

-Administrator can delete a book.

1-Administrator can edit information about a book.

Should Have Stories

1-Advanced search.

-Edit credit card information in account.

1-Edit addresses in account.

4-See what books we recommend on a variety of topics.

SPM 2017 Ron Poet Lecture 15 15

Iteration Plan

Iteration 1.

o All but the last of the must-haves.

Iteration 2.

o The rest of the must-haves and should haves.

SPM 2017 Ron Poet Lecture 15 16

o

They add up to 15 story points and we have 16 available.

We will not be able to do any more stories.

Acceptance Tests

Search on title or author.

o Use searches that match at least one book.

o Use searches that do not match any books.

o Search on ISBN.

SPM 2017 Ron Poet Lecture 15 17

o

Put book in shopping cart.

o Put in-stock book in cart.

o Put the same book in twice.Count should go up.

o Put out of stock book in cart.User told the book will ship when
available.

Testing Constraints

Telephone and web orders in same database.

o Place an order and verify that it ends in the correct database.

SPM 2017 Ron Poet Lecture 15 18

Reviews

There are no reviews yet.

Only logged in customers who have purchased this product may leave a review.

Shopping Cart
[SOLVED] case study database 17spm_L15
$25