Wednesday, January 7, 2015

Statement of Work winter(2015)

Statement of Work

History

Several people have been putting book review on Amazon and other places, but would like to start putting them in the same place. They would like a database to track these reviews.

Scope

The database will track books and reviews. Reviewers must register to write reviews and add comments. All Reviews will rate the book on a scale of 1-5. Unregistered users will be able to seach books and reviews by title, author, and genre, but not able to comment or add reviews.

Constraints: This database will only track book reviews, not other media such as movies and music.

Objectives

Create a database to track book reviews

Create a database that allows people to register and give reviews

Time line and Deliverables

week 1: Determing and agree on the statement of work
Deliverable: Statement or Work

week 2: Gathering information and reviewing documents Deliverables: Questions and notes.

week 3: Defining Requirements and business rules Deliverable: list of Requirements and business rules

Week 4: Design the database. ERD model.
Deliverable: ERD

Week 5. Normalization (Refine the design)
Deliverable: revised ERD

Week 6: Create the physical database
Deliverable Database

Week 7: Add Sample data and test the database(SQL)
Week 8: Look at the Security needs

No comments:

Post a Comment