Assignment Type:                            Individual Report

Percentage of Module Mark:              70%

Due Date:                                       4th of December 2023, 3pm (Upload to Canvas)

Title: A Specification Document + Oracle Apex Database + Prototype

The  goal  of  this  project  is  for  you  to  end  up  with  a  clear  and  detailed  specification document   (and any   supporting   files),   which   could   then   be   handed   to   a   Software Developer,  in  order  for  them  to translate it into a working piece of software (Mobile App or Website). Marks will be gained for increased clarity, consistency and detail, likewise marks may be lost for lack of clarity and too much ambiguity.

Project Deliverables:

1.  Propose a Mobile App/Website idea within the healthcare sector. It doesn’t need to be majorly complicated but does need to do at least one thing well. Describe this App/Website in maximum 600 words. The main focus here is to detail what exactly the app will do (e.g. problem domain, functionality, features, business value, target market).

2.  From your above description, sketch out the  main  screens  (User  Interfaces)  of  your App/Website. Between min 7 to max 10 screens are required. Either use pen and paper or using MS Visio or similar tools. Once you are happy with the screens either take a photo

of the sketch (if using pen and paper) or save the digital diagrams you created.   3.  From your description create 3-4 user stories (per screen) for your App/Website. 4.  Develop a data model/ERD for the proposed App/Website (max 7 entities).

5.  Translate your ERD into a database through Oracle Apex. Build tables, fields (attributes) and relationships and ensure to give the fields the correct data type. The database must contain 8 query objects and 6 form objects. You may use each query as a basis for a form if you wish. Your forms must somewhat be related to your screen layouts i.e. one screen mock-up for an individual form. Create at maximum, a one-minute video (screen capture with audio) for each form and show it working and discuss the SQL code behind it. Save each of your SQL files and attach them to your zip file submission.

6.  Make    a     prototype     of    your     app     using    the     ‘prototype     on     Paper’    app: https://marvelapp.com/pop (feel free to use other tools if necessary). Create an account on this website and upload photos of your screens/wireframes to the Website and then you can set up screen navigation. Example:

https://www.youtube.com/watch?v=flUXlVQk5wA.

Once all of the  above sections (1-6) are  complete,  put  them  into  a  single document (e.g. MS     Word).  Then     convert     this     file     into     an   Adobe   PDF  document.  Add  any diagrams/sketches/SQL files  etc  into  a  folder  and  ZIP/compress the folder.

Therefore, you will submit two items:

1) Adobe PDF file (specification document).

2) Zip/Compress file containing all of your supporting files (e.g. MS Visio project file, SQL files etc). Please ensure all Oracle Apex files are uploaded so that I can recreate your database and run your SQL scripts.

Upload your PDF and zip file (containing all documents/files) onto Canvas, under IS6125, on or before 4pm on the 4th  of December 2023. The key in this assignment is to communicate what your app/website will do via the various deliverables. You don’t  need to worry  how the technology would  work  if  it  were  a  real system.

Examples that will assist you with your assignment:

1. Examples of Screen Sketches/Designs: https://onextrapixel.com/ some  of  these  are  too complex  for  this   assignment   but  you   can take elements/ideas from them. Balsamiq is a great tool for building screens (Wireframing) if you don’t like sketching: https://balsamiq.com  2. Examples of Data Model/ER, See Lecture Slides on Canvas.

3. The tutors will go through translating ERDs  into an Oracle Apex  database  in upcoming tutorials.

Required Format:

-     All external sources of information must be referenced (Harvard referencing style)

-     Font - Times New Roman size 12

-     Spacing - 1.15

Cover page to include the following :

-     Report Title

-     Student Name

-     Student Number

-     Degree Code

-     Module Code

-     Lecturer Name

Generative AI tools

Such applications/tools/platforms can be used for brainstorming and prototyping purposes within  this  assignment  only.   If  used,  the  questions  proposed/input  and  the  responses generated must be clear, referenced and added to the appendix of your application. Output from Generative AI tools must not be submitted, as if it was your own work

Marking Scheme:

Very clear and logical proposal          10%

A collection of sketches of the app/website screens which support the proposal           10%

Supporting user stories to support the app/website screens              10%

Well-structured ERDs which match up well with the proposal              30%

A working Oracle Apex database based on ERD model                  30%

Prototype system               10%