Academic Model Answers
Library for UK Postgraduates

Browse tutor-verified model answers across MBA, Law, Finance, Research Methods and more. Use as study references for your own work.

247 model answers 30+ subjects covered 50+ UK universities
Find your assignment

Search the Library

Filter by keyword, subject, or both. Updates live as new model answers are added to our portal.

Filtering by “Data Modelling” Clear filters

Available Model Answers (4)

Real-time Database Sync
Databases 1,000 words

Assessment #1 – Advanced Databases: NORTHERNTOURS Database Design and Implementation

This assessment for the Advanced Databases module (KL7011) focuses on the analysis, design and implementation of a database system based on the NORTHERNTOURS scenario, a fictitious transport company operating a fleet of luxury coaches across cities, towns and tourist locations in Northern England. The assessment requires students to demonstrate advanced database knowledge through conceptual modelling, logical database design, SQL implementation, data manipulation and the evaluation of alternative database technologies. The assessment addresses learning outcomes relating to the data life cycle, advanced data modelling and database design, as well as professional, legal, ethical, security, sustainability and risk considerations. The first part requires students to develop a conceptual database design for NORTHERNTOURS using Entity-Relationship (ER) or Enhanced Entity-Relationship (EER) modelling. The design should identify relevant entities, relationships, key attributes, primary keys and structural constraints. Students then convert the conceptual model into a logical relational schema using ER/EER-to-relational mapping, identify primary and foreign keys, ensure the relations satisfy Third Normal Form (3NF), select and justify a consistent naming convention, and produce a textual data dictionary containing relevant names, descriptions and constraints. The logical design is subsequently implemented using Oracle 11g, 12c or higher through appropriate SQL DDL statements and database constraints. The second part involves populating selected database relations with self-generated sample data and demonstrating database retrieval capabilities. Students must provide SQL DML statements, relational algebra expressions and SQL queries for specified NORTHERNTOURS business requirements. The solutions must be executed in a live Oracle environment and supported with appropriate output evidence. The third part extends the database analysis by considering object-relational and NoSQL database technologies. Students evaluate which aspects of the NORTHERNTOURS conceptual design could benefit from object-relational implementation, develop and populate a suitable object-relational subset, and demonstrate it through complex queries. They also analyse where NoSQL concepts could provide benefits and discuss design choices supported by representative NoSQL implementation code. Finally, students prepare a concise report for the NORTHERNTOURS managing director addressing sustainability, professional, legal, ethical and security issues, together with diversity, inclusion, cultural, societal and environmental considerations and commercial risk management. The report should use a critical review of relevant literature, systems, developments and standards and follow Harvard referencing conventions.

Read Model Answer →
Business 850 words

HopeLink Community Support and Food Security Database

This assignment requires students to design, develop and analyse a relational database for HopeLink Community Support and Food Security, a fictitious non-profit organisation working across rural and urban communities to reduce poverty and hunger. HopeLink currently relies on spreadsheets, which have resulted in inefficiencies and reporting errors. The proposed database is intended to improve operational efficiency, transparency and evidence-based reporting while supporting the organisation's work towards United Nations Sustainable Development Goals (SDGs) 1 and 2: No Poverty and Zero Hunger. The database development project involves five main entities: Beneficiary, Donor, Product, Collection and Collection Detail. Students are required to create a data dictionary defining the tables, attributes and appropriate validation rules. They must then use SQL within Microsoft Access to create the required tables through SQL View, rather than using the Access front end. Primary keys and foreign keys must be identified and implemented as part of the database design. Students must also establish relationships between the database entities and enforce referential integrity to maintain accurate information for management reporting and decision-making. Appropriate validation rules, user-friendly error messages, drop-down lists and input masks should be implemented where required. The database must be populated with sufficient realistic data for testing, with minimum requirements of 10 Beneficiary records, 10 Donor records, 20 Product records, 10 Collection records and 20 Collection Detail records. A further component requires students to develop five useful SQL queries in Microsoft Access to support analysis and reporting for HopeLink. The queries must follow specific requirements, including one parameter query, at least three queries containing a WHERE clause, at least one aggregate query and at least two queries involving joins across more than two tables. Students must provide screenshots of the SQL code and resulting outputs, together with an English explanation and a short justification of how each query could support HopeLink's operations and decision-making. The final component is an 850-word maximum business insights report investigating the use of food banks in the UK and considering how initiatives could support SDG 1 and SDG 2. Students are expected to use reliable external data, present relevant graphs and analyse current trends in food-bank usage. This section requires Harvard referencing and should use reliable academic, industry and other appropriate sources. The report is based on SDG 1 and SDG 2 and is not directly linked to the database developed for the assignment. Overall, the assignment assesses students' ability to apply data-modelling techniques, database design principles, SQL and data analytics to support organisational operations and strategic decision-making. It combines practical database development in Microsoft Access with data analysis and a business-focused evaluation of food-bank trends and sustainability goals.

Read Model Answer →
Information Visualisation / Data Analytics / Data Science 1,500 words

Information Visualisation Project Using Power BI and Python

Assignment overview — ready to paste This Information Visualisation project requires students to design, implement and critically evaluate effective data visualisations using two different technological approaches: Microsoft Power BI and Python. The assessment focuses on the practical application of information-visualisation principles, including data preparation, visual design, interaction, audience requirements and the extraction of meaningful patterns and insights from complex datasets. Assignment 002 Coursework 2025-… Task 1 focuses on interactive visualisation using Power BI. Students work with the UK Department for Transport's Road Safety Open Data (STATS19), which contains information relating to road traffic accidents, casualties, vehicles, locations, times and contributing factors. Students may analyse one year or multiple years of data depending on their visualisation objectives. Assignment 002 Coursework 2025-… The Power BI work requires students to identify an appropriate target audience and report type, select relevant variables, clean and transform the data, develop an appropriate data model and create analytical measures using Data Analysis Expressions (DAX). The resulting dashboard should communicate the context of the data and reveal meaningful trends, patterns and insights. Assignment 002 Coursework 2025-… Task 2 requires students to develop visualisations programmatically using Python, with Jupyter Notebook recommended as the implementation environment. Students independently select a real-world, publicly available dataset containing at least 10,000 observations and more than five variables. Unlike Task 1, visualisation tools that automatically construct visualisations, such as Tableau or Power BI, cannot be used for this component because programming is an explicit requirement. Assignment 002 Coursework 2025-… Assignment 002 Coursework 2025-… The submitted Jupyter Notebook should operate as an educational technical report explaining the selected dataset, preprocessing procedures, visualisation choices and resulting insights. Students are expected to justify their visualisation techniques, critically evaluate findings and discuss challenges encountered during development. The textual content of the notebook is limited to 1,500 words, excluding code and visualisations. Assignment 002 Coursework 2025-… The complete assessment contains several deliverables, including a maximum 6-minute Power BI demonstration video, a maximum 2-page Power BI report, the .pbix file, an 8-minute Python/Jupyter visualisation demonstration, the Jupyter Notebook, dataset and README file. All materials must ultimately be packaged into a single ZIP submission. Assignment 002 Coursework 2025-… Assignment 002 Coursework 2025-… Important: the brief does not specify a named referencing style or academic level, so I would select Not specified for those two portal fields rather than guessing. It also explicitly states that generative AI must not be used to create any part of the assessed submission, including code, debugging, writing, paraphrasing or bibliographies. Assignment 002 Coursework 2025-…

Read Model Answer →
Data Warehousing and Big Data

Data Warehousing and Big Data – Inventory Management Data Warehouse

This individual coursework for CS7079 Data Warehousing and Big Data requires students to design, implement and test a data warehouse based on a business case scenario and then export and migrate data to a Big Data platform for further processing. The assessment focuses on the inventory management business process of ABC Consumer Electronics Outlet Ltd, a multi-channel consumer electronics retailer operating from six stores around London and conducting online business across the UK and Europe. The company manages more than 10,000 products across approximately ten categories and more than 200 brands. The company already uses cloud-based and business applications including Vend, Linnworks and Xerox, which generate large volumes of transactional data. However, these datasets are stored separately by the individual applications, making it difficult for managers to produce integrated reports and perform analysis to support business decision-making. A business analyst has therefore recommended the development of a data warehouse capable of meeting the company's reporting and analytical requirements. For this coursework, the solution is focused specifically on the inventory management business process. The inventory management case involves three main business activities: sending purchase orders to suppliers when stock reaches minimum levels, receiving purchase orders and storing stock in appropriate locations, and controlling and maintaining stock levels including adding new products and adjusting existing stock. The required analysis includes daily stock levels for the previous month, weekly identification of products at minimum stock levels, analysis of stock levels by brand, product type and supplier, daily and weekly sent and received stock orders, and analysis of received stock orders by supplier and month. Students must analyse and design a dimensional data model that represents these business activities. This includes defining the grain of three central fact tables, identifying appropriate dimensions, defining dimension attributes and fact measures, and producing simple star schemas showing the relationships between fact tables and dimensions. The design must be justified according to the available data sources and the reporting and analysis requirements. The implementation stage requires students to create the relational database using Microsoft SQL Server Management Studio. Students must create the database, dimension tables and fact tables, establish appropriate primary-key and foreign-key constraints, and demonstrate implementation and testing through SQL commands and their results. Test data must then be populated into the data warehouse. The Big Data component requires migration of test data from the data warehouse to an Apache Hadoop platform using the Hortonworks Data Platform. Students must export the data warehouse data to an external data file, migrate the file into Apache HDFS, create a suitable data structure for loading the data into Hive, and demonstrate Apache Pig for manipulating the loaded data. Implementation and testing of the Big Data storage environment must also be demonstrated through commands and results. The coursework concludes with a personal reflective section in which students discuss what they have learned throughout the overall coursework and the challenges encountered during the process. The final submission is expected to be a well-written, structured and well-presented report combining data warehouse design, database implementation, testing, Big Data migration and reflective learning.

Read Model Answer →