This is a practical and real-world project that puts the knowledge you gained into practice. You are required to investigate and understand a publicly available dataset, design a conceptual model for storing the dataset in a relational database, apply normalisation techniques to improve the model, build the database according to your design and import the data into your database, and develop SQL queries in response to a set of requirements. The objective of this assignment is to reinforce what you have learned in the whole course. Specifically, it involves how to build a simple application that connects to a database backend, running a simple relational schema.
Part A: Understanding the Data (0 Marks, Preliminary Work) Part B: Designing the Database (10%)
Part C: Creating the Database and Importing Data (10%)
Part D: Data Retrieval and Visualisation(15%) Assessment criteria