SQL Phase 5

Phase  5  of  your  Database  Application   Develop  a  PHP  or  Java  Application  

Due  Date:  Tuesday  May  21,  2019  

Develop  a  ''user-­‐friendly''  PHP  or  Java  application  that  accesses  the  Database  that  you  built   in  Phases  1–4.  Specifically,  your  interactive  program  should  behave  as  a  front-­‐end  to  your   database  application  using  either  PHP  or  Java.  

Your  program  should  consist  of  a  simple  interface,  that  is  either  text-­‐based  or  GUI-­‐based,  in   which:  

a) A  list  of  at  least  five  alternative  options  is  offered  to  the  user.   (See  next  section  below  –  an  additional  alternative  should  be  quit.)  

b) The  user  selects  an  alternative.  

c) The  program  prompts  the  user  for  appropriate  input  values.   d) The   program   accesses   the   database   to   perform   the   appropriate   queries   and/or  

modifications  –  using  transactions  whenever  appropriate.   e) Data  or  an  appropriate  acknowledgment  is  returned  to  the  user.  

You  should  include  both  queries  and  modifications  among  your  options.  For  example,   if   your  database  were  about  bars,  beers,  and  drinkers  you  might  offer  options  such  as:   1) Look  up  the  price  of  a  given  beer  at  a  given  bar.  

2) Find  the  bar  with  the  lowest  price  for  a  given  beer.  

3) Given  a  drinker,  find  all  the  other  drinkers  that  frequent  at  least  one  bar  in  common.   4) Add  a  new  beer  to  the  Beers  relation.  

5) Increase  all  the  prices  at  a  given  bar  by  a  given  amount.   6) Quit.  

You  are  not  expected  to  do  anything  fancy  as  far  as  the  GUI  is  concerned.  Also,  handling  of   SQL  errors  can  be  quite  simple.  Alternatively,   simply   implement  an  sqlError  procedure   (method)   that   just   prints   the   error   message   from   your   MySQL   Database   Management   System.  

Submit   a   pdf   document   in   which   you   discuss   the   purpose,   design   and   conceptual   implementation  of  your  front-­‐end  application.  Show  screenshots  of  sample  user  interactions   and   the   corresponding   effect   of   how   each   of   the   user   interface   options   is   applied   to   the   Database  that  you  built  in  Phases  1,  2,  3  and  4.