|
Assignment 12 "CheapPizza.Com Prototype 2":
This
is a team assignment and refers to the
team project scenario linked
here.
A. Develop an excel workbook which contains the following development documents on 18 separate worksheets in this order and with these numbers and titles: "0. Team Membership" - list team members' names; "1. scenario" - (supplied as a link above); "2. requirements" - at least 40 requirements as "shall statements" with prioritization (1 most important /2 less important /3 least important) and classification as functional or non-functional; "3. mock-ups" - form, menu, and report mock-ups with example data presented in order and linked with arrows as a user storyboard (see uiFlowDiagram link below); "4. ERD" - complete with relationships, all attributes, and foreign and primary keys noted; "5. test script" - detailed; "6. domain dictionary" (Fig 5.4 p 166); "7. use case diagrams" (Fig 6.5 p 191); "8. use case summary" (Fig 6.3 p 200); "9. context diagram" (Fig 6.8 p 202); "10. class diagram" (Fig 8.13 p 278) include all business object classes with attributes and operations; "11. use cases" (Table 9.1 p 297) include a use case for each use case in 7 and 8; "12. sequence diagrams" (Fig 9.6 p 311) include a sequence diagram for each use case in 11; "13. high-level activity diagram" (Table 9.11 p 327) for whole system -- include partitions for actors (swimlanes); "14. increment 1 use case diagrams" subset of use case diagrams needed to implement all functional and priority 1 requirements; "15. increment 1 ERD" subset of the ERD needed to implement all functional and priority 1 requirements; "16. prototype ERD" showing the actual database implemented for the prototype [B below] -- include client and server tables and note which tables are on the client and which are on the server; "17. prototype deployment diagrams" for the access prototype implemented for B below -- show the access software on the client and show what is on the server. B. Develop a working prototype of an increment 1 version of your system in MS-ACCESS; the prototype is to provide at least all of the functionality that you identified in your requirements as functional and as priority 1. The prototype will: 1) include all of the tables in your ERD; 2) include all of the SQL necessary to provide the reports, including the accounts receivable statement; 3) include appropriate foreign and primary keys; 4) use data validation when appropriate; 5) the prototype is for multiple users on a local area network with shared files on a single PC on the local area network; 6) include functionality to create and maintain stores and specials, for "hungry pizza customers" to access the system, and to list the click-throughs summarized by special and store. Name your workbook and your MS-ACCESS file "411312 yourlastname1 yourlastname2 yourlastname3 yourlastname4 .xls" where "yourlastnamen" is the last name of a project team member, in alphabetic order, in all lower case letters and do not forget the space before "yourlastnamen" . Please zip the two files into a zip file named "411312 yourlastname1 yourlastname2 yourlastname3 yourlastname4 " with the extension provided by the zip compression program. (We need to do the zip compression because the college will not let MS-ACCESS extension files be transmitted as email attachments.) Email your zip file as an attachment to wleigh@bus.ucf.edu . Use "411312 yourlastname1 yourlastname2 yourlastname3 yourlastname4" as the subject line of your email and do not forget the space before "yourlastnamen". Each team member, prepare a peer evaluation of your team-mates in an email message to wleigh@bus.ucf.edu by midnight of the night the presentation is made. The subject of the email should be "ISM 4113 peer evaluation 12 MyLastName. The email message should look like: My Name Madonna (example) team mate 1 Poppa Smerf (example) 10 team mate 2 Sylvia Plath (example) 8 team mate 3 Gordon Lightfoot (example) 6 The peer evaluation scores should be between 0 and 12. The average of the peer evaluation scores awarded should not exceed 10. For example the average above is (10+8+6)/3 = 8, which is less than 10. (See the syllabus.) Resources: http://articles.techrepublic.com.com/5100-10878_11-1049547.html http://c2.com/cgi/wiki?GuiPrototypingTools http://books.google.com/books?id=xbH3CukBJMEC&pg=PA15&lpg=PA15&dq=prototyping+with+ms+access&source=bl&ots=o9Xa9FsIwk&sig=z4CBZ7EywTU3dAGOnSeoK0K826E&hl=en&ei=CaoeSu6dMpSJtgfz1uDsAw&sa=X&oi=book_result&ct=result&resnum=5 http://books.google.com/books?id=xbH3CukBJMEC&pg=PA20&lpg=PA20&dq=prototyping+with+Access&source=bl&ots=o9Xa9FsHuk&sig=qLUQQ2p2niqUo0jsue1xx1dg7AI&hl=en&ei=kakeSsPyIt-ptgeQyNDsAw&sa=X&oi=book_result&ct=result&resnum=7 http://articles.techrepublic.com.com/5100-10878_11-6164435.html http://www.pcapps.com/application-services/custom-development/prototype-design.aspx http://www.customsoftwarebypreston.com/Microsoft_Access_Development_Services.aspx example in access pizza system in access example 2 |