ICT285 Databases TMA 2017 Assignment 2 | Design & Implementation & SQL
Case Study Re-read the description of the FastFoods4U case in Assignment 1 if you need to refresh your memory. Bill is pleased with your work so far and asked you to go on to implement your design. He has made a few clarifications and additions to the specifications that you should note: Bill’s trial of the system has been very successful and he now wants to broaden his service into other suburbs as well. He has also recruited more drivers, with the expectation that there will be drivers available in each suburb. However, customers will still only be able to have orders delivered from restaurants in the same suburb. Bill needs to know whether his meals are being delivered on time as per his advertising so the database will need to be able to provide information on requested and actual delivery times/dates. Bill is pleased with the way FF4U is developing and wants to make some further additions to the concept. He has decided to offer a service whereby customers will be able to s...