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 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