Statement of Work: Book Reviews

History

Several people have been reviewing books over the years and want to consolidate their reviews into a database. They have posted in various web sites but want to bring it all together. They want to make it easier to post reviews, compare them and search for items of interest. They also want to avoid some of the “trolling” and abusive reviews that mar most sites. They are hoping that by only allowing registered members to review and comment on reviews they can minimize some of that.

The database will be a back end to a web site. They intend to hire separate developers to create the front end. They would love to see their database and site become a major draw for book lovers of all kinds.

Scope:

The database will store data about books, the reviewers, reviews and commentaries on reviews. Only registered reviewers can post reviews and commentary, but anyone can search and read reviews. There should be many ways to search for reviews and books. Each review will contain a numerical rating for the book as well as text.

Constraints:

The database will not be expanded to include other media such as music and film.

Objectives

1. Create a database to store book reviews
2. Make the database easily searchable
3. Minimize abusive and irrelevant reviews

Time line and deliverables

1. Gather information, interviews. (One week)

Deliverables: interview questions, questionnaire.

2. Establish requirements and business rules (One Week)

Deliverables: List of Requirements, business rules.

3. Design the database. ERD diagrams (One Week)

Deliverables: Entity Relation Diagram with all Entities, Attributes and relationships.

4. Review the design for normalization. (One Week)

Deliverables: Normalized ERD. List of changes with reasons

5. Build the physical database (0ne Week)

Deliverables: Database with tables and relationships

6. Enter sample Data and Test the database (One Week)

Deliverables: Sample Data. SQL queries on requirements with results

7. Refine security and other elements (One Week)

Deliverables: Security Plan. Disaster Management Plan.