VIDEO STORE Project Assumptions

1. VIDEO STORE Project Assumptions

2. I Am The Stakeholder!I Currently Own Seventeen Non-Franchised Block Buster Stores & I Hope To Purchase More!

3. I Have No Corporate Support!Each Software Application Is Stand-Alone – No Shared Data No Corporate Support

4. I Have A COTS Application Business Management ApplicationProfit – Loss – Employee Scheduling Each Of My Managers Get To Select TheirOwn Inventory It Manages Shifts & Schedules It Helps My Managers Determine How Well They Are Doing!

5. Inventory Subsystem VIDEO STORE Teams Go To WhiteBoard Do A Complete Class Diagram For Movies Only Movies Games Others? One Person Write On Board – One WriteOn Paper – Organize Fields Logically! Your Team Can Decide Whether Or Not To Place These In Same Container! Pros & Cons

6. I Know Lots Of Colleagues Who Have Had Problems With Custom Software!

7. My Colleagues Tell Me Some Developers Are Better Than Others!

8. I Am Going To Get Together With My Colleagues & Find Out Who They Recommend!

9. My Colleagues Provide Some RecommendationsSome People Will Eliminate Your CompanyBased On How Professional The Company Name

10. I Own Several Companies – I Have Had Custom Software Written BeforeI Estimate That This Application Will Cost Me ~$120,000

11. Some Of My Colleague’s Experiences With Custom Software Were Smooth Sailing But Many Were Disastrous

12. My Business Classes Encourage Risk Management! Loss?

13. Risk Management : Pay $9,000 For $4,800 Worth Of Software Hoping Not To Pay $120,000 For Poor SoftwareInventory Subsystem DesignDevelop Architecture Diagram For Inventory SubsystemDevelop Class Diagrams For Inventory SubsystemDevelop Specifications For Inventory Subsystem Inventory Subsystem Design ~4 % Of Overall Project Estimated Value = ~4% of $120,000 = $4,800 I Invite My Top 4 Companies ToParticipate – Hoping To Get 3 of the 4 I Offer Each Team An Opportunity To Participate And Offer Them $3,000 Each Best Team Gets The Design Project

14. Why Might You Do $4,800 Worth Of Work For $3,000Inventory Subsystem DesignDevelop Architecture Diagram For Inventory SubsystemDevelop Class Diagrams For Inventory SubsystemDevelop Specifications For Inventory Subsystem

15. As You Present Your Prototype, Part Of Your Job Will Be To Convince Me That You Offer The Best Solution For My Business

16. It Is Important To Me That My Software Design Company Anticipate My Needs

17. It Is Important To Me That My Software Design Company Understand My Business Before Your First Meeting:Google Search Business Journals Review Their Website Review Competitor Websites Etc.

18. Many Video Stores Are Closing Their Doors (Failure!)

19. You Should Ask YourselfWhy Are Video Store Going Out Of Business

20. Web Search – Business Journals – Etc.

21. Even Asked Some Friends At DinnerWhat Do You Not Like About Going To A Video Store?What Would Make The Experience More Rewarding? “It takes too long to find a movie. I read 300 boxes before I find one I want. There is never anyone to help much with my search needs.” “ I rent the same movie more than once; there needs to be some way for them to easily tell me if I am renting the same movie.”

22. Even Asked Some Friends At DinnerWhat Do You Not Like About Going To A Video Store?What Would Make The Experience More Rewarding? “It takes too long to find a movie. I read 300 boxes before I find one I want. There is never anyone to help much with my search needs.” “ I rent the same movie more than once; there needs to be some way for them to easily tell me if I am renting the same movie.”

23. Even Asked Some Friends At DinnerWhat Do You Not Like About Going To A Video Store?What Would Make The Experience More Rewarding? “I waste at least half an hour to forty-five minutes looking at the same movies each time I go. “I wish there some way to print a list of the available mysteries so that I could check them off as I see them.”

24. Even Asked Some Friends At DinnerWhat Do You Not Like About Going To A Video Store?What Would Make The Experience More Rewarding? “I sometimes go and find nothing! Frustrating. “It costs too much. There needs to be more flexible return dates.” “I wish there were some way to see my account – what I have previously rented.”

25. I think your company will • Deliver the system on time • Deliver the system that I need • Deliver a system that is easy to use • Deliver a system that is fast • Deliver a system that will help my business • Deliver a system that will enable me, and my employees to get more done in less time • Deliver a system that takes advantage of what technology has to offer I Am Going To Hire Your Company Because:

26. How Many Fields Do You Have In Your Media Entity?

27. Take A Look At What Others/Competitors Do http://www.blockbuster.com/ RENT

28. Would This Help Solve Any Of My Friends Complaints? http://www.blockbuster.com/

29. What Fields Would You Need In Your Media Entity For The Following? ActionAndAdventure – BoolActionComedy – Bool . . .

30. How Can You Improve Upon It? What Do You Like About This?Can This Type Of An App Be Fed From Your Database? FiltersItems I Have Not Rented New-Recent-OldItems Still Available [#?]

31. What Fields Would You Need In Your Media Entity For The Following? Photo – Blob - BinaryTrailer – Blob – BinaryReleaseDate – Date BriefAbout – vcharDirector1 – long int/vchar Director2 – long int/vchar Cast1 – long int/vchar Cast2 – long int/vchar Cast3 – long int/vchar Cast4 – long int/vchar Cast5 – long int/vchar Rating – vchar Category – long int/vchar . . .

32. What Additional Fields Would You Need In Your Media Entity For The Following? About – vcharReview Subsystem??? . . . Don’t Be Afraid To Add Your Own Stuff i.e. More Specific RatingR – Violence – Brief Nudity – etc. Don’t Include Adult Content In Public Area! Don’t Do The Complete Cast – 5 are sufficient!

33. Games Are Something To Be Researched By Your Team

34. Inventory Subsystem DoA Complete Class Diagram For Movies Only Movies Video Store Inventory Subsystem Report Card Games Others? • ? Your Team Can Decide Whether Or Not To Place These In Same Container! Pros & Cons

35. How Many Of You Have Something Like Barcode For Scanning? Weekly Special Come Rent It – If Not Available Get It Later For Free! Movies Movies • ? 110 Copies Do You Really Want To Enter, Or Maintain, 110 Copies Of All That Data?

36. Design 1 MovieItem Class Movies Movies

37. Design 2 - Relationship Allows You To Link MovieItems To Movie SELECT *FROM Movie, MovieItem WHERE (Movie.ID = MovieItem.MovieID) AND (Movie.ID = 12331) Movies Movies Movie.ID = 12331

38. Design 3 – You Can Extract Related Copy Info To Web Or Stand-A-Lone Applications SELECT *FROM Movie, MovieItem WHERE (Movie.ID = MovieItem.MovieID) AND (Movie.ID = 12331) Movies Movies Your prototype must include one sample data entry. You can use the text property to initialize it. We would normally use the DataGridView to fill in the information about the Copies. Since most of you would rather not add the database, you can create a prototype that simulates the table view with textboxes. Explaining to the Stakeholder that it will later look a bit more like a table with scroll bars.

39. Design 4 – Relate The Status Class To The Movie Item Movies Movies

40. Design 5 – Relate The Condition Class To The Movie Item Movies Movies

41. Design 6 – The Condition Class Can Be Used To FillCombo Boxes In Web Or Stand-A-Lone Applications Movies

42. Design 7 – The Condition Class Can Be Used To FillCombo Boxes In Web Or Stand-A-Lone Applications Movies • USE • Combo Boxes • Radio Buttons • Check Boxes • Numeric Up & Down • List Boxes • etc. • TO CONTROL USER INPUT WHEN POSSIBLE. Don’t Consider The Lists In This Presentation To Be Adequate. Missing?

43. One Week From TodayClass Diagram & Prototype For Edit/Add Movie (Multi-User System) Sample Form From My Database Design Course (Be Creative) EDIT

44. Edit/Add Mode Remove All Options Except Save/Cancel

45. One Week From TodayVisual Studio Prototype For Edit/Add Movie (Multi-User System) Sample Form From My Database Design Course (Be Creative) You Can Mix Controls – But Often Confuses Non-Web Users

46. Why Am I Here It Is Often Desirable To Add Non-Inventory Buttons To The Media Form • I Looked Up This Movie In A Search (Normal Edit/Add/Delete/Print/etc.) • Maybe want to check out a copy? Maybe I want to E-Mail Info about this movie to a customer Maybe I want to E-Mail Info about this movie to all customers interested in this Category of movies Maybe I want to order more copies Maybe I want to see who has checked it out Remember Fast & Easy

47. Why Am I Here I Wanted To