• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Help with Tea Service app

Samuel Maxon
Posts: 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator

You are asked to design and implement a software system using the features and functionality of the examples that you have worked through in the practical classes. You should design and build your system using JSP/Servlets using MVC on an Apache Tomcat server - with a local MySQL Relational database backend. You will be required to demonstrate and discuss your working system using Netbeans IDE and mySQL.
Your work will be marked in two steps.
Step 1 Six test case scenarios (48 marks)
Step 2 An explanation of how your system works + design considerations. (52 marks)
Assessment System
You are required to submit your work in the Blackboard VLE as a zipped Netbeans project.
Demonstrations will take place in scheduled practical classes at the end of semester one.
• You must download (from Blackboard) and unzip your project.
• You must run the SQL script provided to create and populate the required tables.
Your Netbeans project and mySQL server must be runnable on the normal FET lab machines (or your own laptop which you must bring).
It is your responsibility to attend scheduled classes – failure to demonstrate your system in class will treated as a non-submission and may result in zero marks.
The quality of your verbal expression in this demonstration is important – incoherent explanations will not achieve high marks. Please be advised that the demonstration normally lasts for a fixed duration of five minutes, so be prepared to concisely demonstrate and explain your system.
Feedback and marking will be provided at the demonstration. Please note that the mark is provisional and may be subject to amendment as a result of double marking.


Joan Trolley runs a service called Tea Up! – basically she takes snack orders for office workers at their desk and delivers the items to them.
She'd like to transfer her paper-based system onto a web-based system. Only Joan will be using this system (her clients do not have access to it).
As proof of concept a simple prototype will suffice.
• This prototype should initially have 4 clients and 4 snack items.
o An SQL script to create these tables is supplied.
• Prototype should use $ rather than £ (£ is non-ascii)
As a minimum it must have the following features:
• List of clients
• List of available snack items including prices
• Show a table of clients and items with the functionality to order items
o i.e. add or remove any number of items (or clear basket) for any client.
• List order: items and total price for each client + total price of all lists
Ideally it would also have these features:
• On buying the items:
o transfer orders to database
o clear current orders
• Ability to change item prices
• Ability to mark clients as ex-clients
• List summary of all items and costs ordered by any or all clients since system inception
You may assume the system will accept cookies.
Demonstration and Marking
Step 1 Test Cases.
• These must be demonstrated sequentially and as described.
• Marks could be lost – e.g. for a lack of clarity or failure to demonstrate tests sequentially.
• Each successful test case is worth 8 marks (total 48).
o Normally a test will pass or fail (i.e. 0 or 8 marks)
• Do not combine the Test Cases
o Note: Each sub-item (e.g. A or B) below is a separate step in the Test Cases – you may combine the steps in each Test Case
You must run the SQL script supplied so that at the start of your demonstration:
• The initial clients must be Luca, Clara, Dora and Hana.
• The initial items must be tea, cola, biscuits and cake.
• The orders table is created and is empty
If you think there may be some ambiguity in the specification or Test Cases you must check for clarification with the tutor in your normal practical class. False assumptions may cost you marks.
For the prototype demonstration Joan Trolley should be able to:
Case 1:
A. List all clients
B. List all items with their prices
Case 2:
A. Add for Luca 2 x biscuit and 1 x cake
B. Add for Clara 1 x cola
C. Show current order (items, quantities and cost) for Clara
D. Show current order for Luca
Case 3:
A. Clear Clara's list
B. Show current order for Clara
C. Show current order for Luca
Case 4:
A. Adds 4x cola and 5x biscuit for Dora
B. Changes cost of cake to $5
C. List all current orders for all clients
Case 5:
A. Buy goods i.e.
• transfer orders to database
• clear current orders
B. List a summary of all completed orders (showing client name, item name and quantity) since system inception (you may decide to show or exclude ex-clients)
Case 6:
A. Add a new client called Tessa
B. Dora leaves the company and becomes an ex-client
C. List all clients
C. List summary of all completed orders since system inception
Bear Bibeault
Author and ninkuma
Posts: 65274
IntelliJ IDE Java jQuery Mac Mac OS X
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Welcome to the Ranch.

So, what's your question?
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic