Filter by keyword, subject, or both. Updates live as new model answers are added to our portal.
Databases and Business Intelligence
Databases and Business Intelligence – KAP Speciality Chocolates Database Coursewor
This individual coursework for the Databases and Business Intelligence module provides practical experience of database systems through the realistic KAP Speciality Chocolates case study. Students are required to design and implement a relational database solution that supports the management of products, stock, suppliers and purchase orders for KAP Speciality Chocolates Ltd. The case study describes a growing chocolate business with a shop and a storeroom that requires a database system to reduce operational errors and improve stock control. The first task requires students to analyse the case study and identify appropriate entities, attributes, relationships, primary keys, foreign keys and dependencies. Students must produce an extended Entity Relationship Diagram showing how the identified elements should be related. The diagram must include participation and cardinality constraints, and students must clearly document the assumptions made and the notation used. A range of modelling notations and software tools may be used, provided that the required database elements are clearly represented. The second task requires students to translate the ER design into a relational database implementation by writing SQL Data Definition Language statements. The SQL must define suitable tables, attributes, data types, primary and foreign keys and relevant constraints. The chosen data types should be appropriate and foreign-key data types must correspond correctly to their related primary keys. The third task focuses on SQL Data Manipulation Language and requires students to create queries addressing a range of business information needs. These include producing a product price list, identifying purchase orders due for delivery on a specified day, generating shop re-stocking lists, changing product cost and selling prices, identifying products with outstanding purchase-order deliveries, producing a re-order list for products below their minimum warehouse stock level, and identifying suppliers that provide multiple cartons. Students must populate their tables with sufficient suitable data to demonstrate that the SQL works and provide evidence of testing through screen captures of SQL statements and results. The fourth task requires students to demonstrate that the database design is normalised to Third Normal Form (3NF). The normalisation process must begin with unnormalised data and show the stages through First Normal Form (1NF), Second Normal Form (2NF) and Third Normal Form (3NF), explaining the changes and reasons at each stage. The final normalised solution must remain consistent with the ER diagram, assumptions and entity and attribute names used in the database implementation. The final submission must combine all tasks into one report written in English, using Arial 12-point font and single spacing. The report must contain the extended ER diagram and assumptions, SQL table definitions, SQL queries with explanations and testing evidence, and a written explanation of the normalisation process. The completed report must be submitted as a single PDF through SurreyLearn by the specified deadline.
Read Model Answer →
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 →
Leading Through Digital Change
1,500 words
Digital Transformation Report and Poster
This assessment requires students to act as a Senior Digital Transformation Manager and produce a Digital Transformation Report and Poster for one selected sports retail organisation. The purpose of the assessment is to evaluate the organisation's current digital environment and recommend changes that can help it maintain competitive advantage and create business value in response to continuing digital change, changing consumer expectations, e-commerce growth, sustainability requirements, digital innovation and supply chain resilience. The assessment consists of three connected sections addressing digital transformation strategy, future digital trends and digital leadership. The first section requires students to critically review and propose an appropriate digital transformation strategic framework for their selected organisation. Students must select and apply one framework from McKinsey's 4Ds, BCG's 3 Stages, Gartner's 6 Steps or Cognizant's 4 Pillars. The framework should be applied to the chosen organisation rather than simply described. The analysis should also establish digital transformation objectives that support key business functions such as operations, ICT and marketing, with relevant examples and evidence from research used to strengthen the discussion. The second section requires the design of an A4 poster evaluating two disruptive technologies or techniques that are likely to influence the smartphone industry, employment and the labour market over the next five years. Potential technologies identified in the brief include Artificial Intelligence and Machine Learning, 5G connectivity, Internet of Things, robotics, drone delivery, blockchain, augmented reality and virtual reality. The poster should communicate the expected impact of the selected technologies using academic literature and real-life examples. The third section focuses on digital leadership. Students must analyse and propose two appropriate digital leadership styles that the selected organisation should develop to effectively manage and support digital transformation. Possible approaches include hyperaware agile leadership, ethical technology leadership, people-oriented leadership, agile leadership and Goleman's leadership styles. The recommendations should be supported by relevant theories, academic literature and real organisational examples. The assessment is aligned with three learning outcomes. These address the application of management and leadership strategies during digital change, critical assessment of the impact of digital change on markets, organisations and employees, and evaluation of the leadership attributes and skills required to manage organisations and people in digitally changing environments. The final submission must include a clear introduction and conclusion, demonstrate intellectual originality and critical analysis, use appropriate academic evidence and follow Harvard referencing. The report is limited to 1,500 words, excluding the A4 poster, and students must select only one of the specified sports retail organisations for their analysis. The selected organisation should be analysed consistently across the strategic framework, future technology and digital leadership sections.
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 →
Data Visualisation / Business Intelligence
2,500 words
Data Visualisation (BS666) — Business Analyst Client Report: Dashboard Development, Tool Evaluation and Accessibility in Power BI and Tableau
This Level 7 resit assessment takes the form of a single client-facing report written from the position of a qualified business analyst. Rather than assembling semester activities, it asks for one sustained piece of analytical writing that carries a business case from raw open data through to a defended set of visualisations and the decisions they support. The report opens by identifying a data source drawn from an approved open repository and setting out the business problem the client faces. Provenance, structure, granularity and known limitations of the dataset are examined honestly at this stage, since every downstream claim rests on them, and all data is referenced in full — including data appearing inside charts, as the brief specifically requires. The main body works through three connected strands of critical evaluation. The first traces the development sequence of the visualisations themselves: how the data was prepared and cleaned, why particular chart types were selected over the alternatives available, how layout and interactivity were arranged for the intended audience, and how the design changed across iterations once weaknesses became visible. At least three completed visualisations are then evaluated individually and critically — what each one reveals, where each falls short, and what a reader could reasonably conclude from it. The second strand compares Power BI and Tableau as working environments for this specific dataset rather than in the abstract. Data connectivity, transformation and calculation capability, visual flexibility, publishing and sharing, licensing and governance are all weighed against what the client actually needs, with the practical friction encountered during the build reported rather than smoothed over. The third strand addresses accessibility and cognitive processing. It examines how each platform handles colour contrast and colour-vision deficiency, text alternatives, keyboard navigation and screen reader support, and then moves into the perceptual side — pre-attentive attributes, data-ink economy, chart junk, working memory limits and how visual encoding choices either reduce or inflate the effort a reader must spend to extract meaning. The argument connects this directly to decision quality in organisations with diverse analytical literacy. Findings are reported at length and translated into concrete business implications, with a conclusion that states what the client should do and on what evidence. The submission follows the prescribed structure throughout: title page, executive summary, contents, introduction, business problem, main evaluative section, findings, conclusion, Harvard reference list and appendices, presented as a single file for Turnitin.
Read Model Answer →
Data Management / Business Analytics
2,500 words
Data Design Management (BS514) — Data Strategy Consultancy: Relational Database Design, SQL Implementation and Pipeline Transformation
This Level 7 assessment places the writer in the role of a Data Strategy and Analytics Consultant appointed by an organisation operating in a realistic industry sector. The brief is entirely simulated, so the work sets out a defensible set of assumptions about the organisation's data environment before any design begins, and populates the resulting database with synthetic but realistic records. The deliverable is a slide deck carrying full explanatory notes, submitted as a single PDF, and weighted across three connected tasks. Task one establishes the business case. It describes how the chosen organisation currently collects, stores and uses data across customer interactions, sales transactions, operational processes and digital channels, and identifies where that fragmented picture costs the business in efficiency, resource use, retention and decision quality. A SWOT analysis benchmarks the organisation against a named real-world competitor in the same sector, drawing on publicly available market information rather than assertion. The section closes with a critical evaluation of modern relational database advancements — cloud-hosted SQL services, distributed architectures and data warehousing — assessed not in the abstract but against what each would actually change about this organisation's business model. Task two carries the heaviest weighting and is the technical core. Key business entities are identified from the scenario, a current-state data flow diagram traces how data moves from collection points through to storage and reporting with the existing ETL approach made explicit, and a future-state ER diagram is then built with full attributes, primary and foreign keys, relationships and cardinality. The design is normalised to third normal form with the decomposition reasoning shown. Implementation follows in SQL: tables created with appropriate integrity constraints, at least ten realistic sample records inserted per table, and five business questions answered through working queries — highest-performing product or campaign, average conversion by category, workload distribution across staff, accounts with overdue or pending items, and most effective service channel. Outputs accompany every script. A transformation demonstrating query optimisation is included with before-and-after samples so the improvement is evidenced rather than claimed. Task three steps back to the technology decision. Two widely used data processing platforms are compared in tabular form across integration, cleaning, transformation and automation capability, judged specifically against this organisation's constraints, with a reasoned justification for the tool finally selected. The transformed dataset is then used to answer two management-level questions — where investment should be prioritised and how retention might be improved from observed behavioural patterns — each interpreted briefly and tied back to a concrete recommendation. Slide structure follows the prescribed layout, SQL scripts sit in the notes section, and the complete script file is reproduced in the appendix.
Read Model Answer →
Machine Learning / Data Mining / Text Mining
Machine Learning Analysis of Classification Models and Text Mining on Furniture Review Data
This technical machine-learning report demonstrates the practical application of predictive modelling and text mining using WEKA. The work is divided into two major tasks. The first evaluates and compares Support Vector Machine and Decision Tree classification models, while the second applies text-mining techniques to furniture-review data and compares multiple classifiers after preprocessing, feature selection and class balancing. The first task uses the Screenshots.arff dataset to investigate the performance of libSVM and J48 Decision Tree classifiers. A 70% training and 30% testing split is applied, and the models are manually tuned to examine how different parameter settings affect predictive performance. For libSVM, an RBF kernel is used while different gamma and cost values are tested through grid-search-style experimentation. The report identifies gamma 0.03 and cost 2 as the strongest tested combination, producing approximately 91.67% accuracy on the test split. The J48 model is also optimised by adjusting the confidence factor used for pruning. Several confidence-factor values are examined, with 0.09 producing the strongest reported result of 80% accuracy. The optimised SVM and J48 models are then compared using five-fold cross-validation, where libSVM achieves 89.75% accuracy compared with 81.25% for J48. The second task focuses on text mining of Furniture Reviews. Text preprocessing includes TF-IDF term weighting, stopword removal, stemming, conversion to lowercase and word-count generation. The resulting textual dataset is transformed into a numerical feature representation suitable for machine-learning classification. Dimensionality reduction is performed using InfoGainAttributeEval with Ranker, selecting the 900 most informative attributes. The dataset is then balanced using WEKA techniques including Resample and SpreadSubsample to reduce class bias before classification. Finally, three classifiers—Naive Bayes, libSVM and J48—are evaluated on the balanced text dataset. The reported accuracies are 90.52% for Naive Bayes, 58.62% for libSVM and 78.45% for J48. The analysis concludes that Naive Bayes performs strongest for the processed furniture-review dataset, while the wider exercise demonstrates the importance of preprocessing, parameter tuning, feature selection, class balancing and appropriate model evaluation in producing reliable classification results. Important: this upload appears to be the completed student report, not the actual assessment guideline. Because the document does not state the university, module name, academic level, academic year, required word count or prescribed referencing style, I would leave those fields as Not specified rather than guessing.
Read Model Answer →
Computer Science / Database Systems
4,000 words
Advanced Databases (KL7011) — NORTHERNTOURS Coach Travel Database: EER Design, Oracle Implementation, Object-Relational and NoSQL Extensions
This piece of work addresses a four-part Masters-level assessment in Advanced Databases built around NORTHERNTOURS, a fictitious coach travel operator running services across cities, towns and tourist sites in the North East of England. The company sells tickets through a network of independent travel agents, each currently working from a paper-based sales book, while NORTHERNTOURS itself maintains separate paper records for routes, schedules, seat availability, vehicles and drivers. The brief asks for a single computer-based system capable of replacing both, tracking every agent transaction while giving the company control over ticket issue and seat allocation. Part one covers the conceptual and logical design. An enhanced entity-relationship model was produced covering agents, agent employees, customers, tickets, routes, stops, schedules, vehicles, drivers and the meal provision recorded at each stop, with key attributes, primary keys and full structural constraints shown. Because the scenario does not name identifiers for most entity types, appropriate surrogate and natural keys were devised and justified. The diagram was then mapped to a logical relational schema, normalised to third normal form, with a documented naming convention applied consistently across relations, attributes and keys, and every element recorded in a text-based data dictionary giving names, data types, descriptions and constraints. Part two moves to implementation in Oracle. A full DDL script creates the relations with primary and foreign keys and a substantial set of check constraints — key format patterns, positive seat counts and fare values, date ordering on schedules. Sample data populates the relevant tables, and two retrieval problems are answered twice over, once in relational algebra and once in SQL: schedules between Newcastle and Berwick-upon-Tweed with seven or more seats free in the coming fortnight, and the agent with the highest ticket sales across a defined month. Spooled session output evidences each script running. Part three revisits the conceptual design to argue where object-relational features earn their place — nested route-and-stop structures and composite address and contact types being the clearest candidates — implemented using Oracle object types, VARRAYs and nested tables, and demonstrated through two multi-join aggregate queries. A parallel discussion identifies the schedule and availability workload as a fit for document-oriented NoSQL storage, with representative code and a reasoned account of the denormalisation trade-offs involved. Part four is a report to the managing director covering sustainability, professional, legal, ethical and security obligations, alongside diversity, inclusion, cultural and environmental matters, commercial risk evaluation and mitigation, supported throughout by current literature and published standards.
Read Model Answer →
Database Design and Implementation for KAP Speciality Chocolates Ltd
Design and implement a relational database system for KAP Speciality Chocolates Ltd based on the given case study. The assignment requires creating an Extended ER Diagram, developing SQL database structures with appropriate constraints, writing SQL queries for business requirements, populating the database with sample data, and demonstrating normalisation from Unnormalised Form (UNF) to Third Normal Form (3NF). Expected Deliverables: One PDF report containing: Extended ER Diagram with entities, attributes, relationships, keys and constraints SQL DDL statements for database implementation SQL DML queries with testing evidence/screenshots Normalisation process from UNF to 3NF
Read Model Answer →