Information Systems�and �Interaction

Order Details;

1 CSC-­‐10032  -­‐ Information  Systems  and  Interaction Coursework  2014/15 Deadline:  11.59pm  on  Friday  1st May Scenario A  pet  supplies  chain  (known  as  Stoke  Pet  Supplies)  has  asked  you  to  implement  a   simple  database  to  hold  product  and  stock  details  for  each  of  their  stores.  Each   store  stocks  a  number  of  the  pet  supply  products  which  are  made  available  for   purchase,  with  each  product  being  uniquely  supplied  by  one  external  supplier   (though  one  supplier  may  provide  many  different  products).  Stoke  Pet  Supplies   requires  two  reports  to  be  produced  in  order  to  enable  proper  stock   management.  The  first  report  should  record  the  stock  levels  for  each  product  at   each  store,  this  report  should  be  grouped  by  store  to  make  it  easier  to  read.  The   second  report  should  provide  information  on  how  many  products,  and  it  what   quantities,  Stoke  Pet  Supplies  currently  stocks  from  each  product  supplier  – this   is  to  enable  higher  management  to  assess  how  popular  certain  products  are   across  their  entire  organisation.   Whilst  implementing  the  database  system  (following  the  steps  below),  you   should  apply  common  sense  and  make  any  necessary  minor  administrative   decisions.  Your  coursework  report  is  to  document  your  work  in  carrying  out  the   following  steps,  and  include  sufficient  information  about  the  system   implemented  that  it  can  be  understood  without  difficulty.   Task  1  – Complete  in  MS  Word/PDF  (Report) a)  Produce  a  first-­‐cut  Entity  Relationship  (ER)  Diagram  for  the  system.   [5%] b)  Carry  out  the  Relational  Data  Analysis  procedure  from  the  “Organising  Data   and  Structured  System  Analysis”  lectures.  Include  details  for  each  normal  form   (up  to  3rd  normal form),  and  the  resulting  ER  Diagram.   [20%] c)  Following  the  examples  from  the  “Organising  Data  and  Structured  System   Analysis”  lectures  and  practicals,  use  your  ER  Diagram  and  normalised  attributes   to  produce  a  Relational  Database  Schema. [5%]   Task  2  – Complete  in  MS  Access a)  Implement  your  database  in  Microsoft  Office  Access,  complete  with  sample   data  (5-­‐15  records  per  table).  Remember  to  use  appropriate  data  types  and  to   implement  necessary  relationships.   [10%]   b)  Implement  in  Microsoft  Office  Access  the  two  reports  outlined  in  the  case   study.   [20%]   2 Task  3  – Complete  in  MS  Word/PDF  (Report) You  have  also  been  asked  to  create  a website  for  the  organisation described   above to  use  to  sell  products  directly  to  customers.     The  first  step  of  the  design  process  is  to  look  at  competitors  /  alternative  sites   with  a  similar  purpose.    Locate  and  review  four  alternative  sites,  considering   their  use  of  design  patterns,  icons  and  metaphors.     You  should  document  this  process  in  you  report  including  screenshots  and  a  few   sentences  about  each  pattern,  icon  or  metaphor,  explaining  what  it  is  and  how  it   relates  to  the  real  world  process  it  resembles.     [20%] Task  4  – Complete  in  MS  PowerPoint  and  insert  screenshots  of  the  finished   pages  into  your  MS  word  /  PDF  report The  next  stage  is  to  design  two  of  the  pages  of  the  site,  the  homepage  and  a   product  page.    You  should  create  two  designs,  one  design  optimised  for  a   desktop  computer,  a  second  design  optimised  to  be  viewed  on  a  mobile  phone. Include  screenshots of  all  four  pages  in  your  report  document,  and  annotate  each   page  with  your  design  decisions.   [20%] General  information Your  report  should  be  presented  in  a  professional  manner,  and  include  a  title   page  as  well  as  a  table  of  contents.    When  marking  the  report  it  should  be   obvious  to  the  marker  which  work  goes  with  which  task  (and  sub-­‐tasks).