Identify, handle and manipulate structured and unstructured data using modern databases.

Learning outcome 1: Identify, handle and manipulate structured and unstructured data using modern databases.

Learning outcome 2: Efficiently handle and manipulate large datasets.

Learning outcome 3: Identify and implement appropriate data management techniques.

Learning outcome 4: Apply analysis techniques to extract knowledge from data.

1 Aim

This coursework examines the student`s ability to design a relational database, manipulate and analyse large datasets, and to interpret analysis results.

2 Coursework Contribution

This coursework contributes 100% to the final module grade. For the weightings of different parts, please see the separate marking grid document.

3 The Tasks

3.1 Part 1: Designing a Relational Database

Little Panda is a takeaway who wants to open up its business to accept online orders. To do this, it needs a database to store its food menu, customer data and orders.

Your task is to design a relational database that runs on MySQL. Here are some requirements:

Customers must register before they can make orders. They must provide enough details for home delivery.

Menu item prices may change. Customers are charged prices at the time of order.

Little Panda needs to know the status of an order so that they can follow up.

e.g. either it is "waiting to be cooked", "cooked and to be delivered", or delivered, etc. You can assume all orders are paid before they enter the system.

Order details must be stored for accounting purpose, even after they are completed.