Assignment title: Information


1. Prepare a user interface storyboard for staff to make changes to the preliminary roster.Not sure how to make a storyboard? Storyboards show task flow and information layout. Here are some examples for your consideration: • http://msdn.microsoft.com/en-us/library/windows/desktop/Ff800706.0e12f17e-860b-4be5-a89d-b914b38b0680(l=en-us).jpeg • http://courses.csail.mit.edu/6.831/wiki/images/thumb/a/a8/MOD-Storyboard-4.png/300px-MOD-Storyboard-4.png• http://www.museumsandtheweb.com/mw2007/papers/vanLoon/vanloon-figure4-thumbnail.jpg • http://www.stavchansky.net/images/feature_ftsStoryboard.jpg Put your answer here.2. Design the "report" that will be sent by SMS or email once the system has finalised the roster.Put your answer here.3. Design the report of staff availabilities.Put your answer here.4. Design a user interface storyboard for amending the roster after it has been finalised (eg, when someone is unexpectedly unable to work Joanna or Priyam have to allocate their shift to someone else).Put your answer here.Data design5. Create an ERD for the rostering process.Put your answer here.A table is provided in Appendix One. The data is in 1NF.6. Normalise the table(s) to 2NF.Put your answer here.7. Normalise the tables to 3NF.Put your answer here.8. If you identified any new tables during normalisation, update the ERD. Put your answer here.