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 →
Web Applications / Artificial Intelligence / Software Development
Smart Clinic Appointment and Patient Management System with AI-Based Demand Prediction
This Web Applications and AI coursework requires students to design, implement and evaluate a Smart Clinic Appointment & Patient Management System for a small healthcare clinic. The application combines conventional web-development functionality with an artificial-intelligence component for predicting appointment demand. The system is expected to use Java EE technologies, including Java Servlets, JSP, Web Services and JDBC, together with a relational database such as MySQL or PostgreSQL. f3855340dabd17407efd386c38cfdc3… The patient-facing side of the application should allow users to browse and search clinic services by department or specialty, price, availability and duration. Patients must be able to view detailed service information, select a clinician where appropriate, choose an available date and time, enter their details and confirm an appointment. The system should also provide a booking reference and basic appointment-history functionality. f3855340dabd17407efd386c38cfdc3… The administrative interface focuses on operational management. Staff should be able to add, update and remove services, configure consultation duration and pricing, manage clinician working hours and appointment-slot availability, and generate basic reports. f3855340dabd17407efd386c38cfdc3… A separate machine-learning component requires students to implement appointment-demand prediction using WEKA regression embedded in Java. The provided sample dataset contains Year, Month, Promotions Cost and Booking Requests. Students must expand this dataset to at least 60 realistic rows, including seasonal changes and plausible variation in marketing expenditure and demand. A regression model is then trained to predict booking requests for the following year based on promotional spending, including estimation of future demand if promotions expenditure increases by 10%. f3855340dabd17407efd386c38cfdc3… The assessment also requires evidence of professional software-development practice. Students must provide application-design artefacts such as design patterns, ER diagrams, wireframes and sketches, document the development process, demonstrate correct use of JSP, Servlets, Web Services and JDBC, and provide evidence of implementation through code, database content and screenshots. Regular GitHub commits are required to demonstrate ongoing development. f3855340dabd17407efd386c38cfdc3… f3855340dabd17407efd386c38cfdc3… The final submission includes a DOCX or PDF report containing system-design and implementation information, links to a private GitHub repository and a demonstration video of no more than five minutes. The assessment is classified as Green for AI use, meaning AI tools may support tasks such as generating example datasets, suggesting code snippets and brainstorming features or tests, provided their use is clearly declared in the report. f3855340dabd17407efd386c38cfdc3… Overall, the coursework integrates full-stack Java web development, relational database design, web services, software engineering and machine-learning regression within a healthcare appointment-management scenario. Important: the uploaded brief states that it is for Coventry University Group students' own use and must not be passed to third parties or posted publicly. f3855340dabd17407efd386c38cfdc3… So for a public Reference Library, use an original summary like the one above rather than publishing the original brief itself.
Read Model Answer →
Data Mining / Data Science
Customer Service Escalation Risk Analytics Using Data Mining and Machine Learning
This advanced Data Mining assessment applies the Knowledge Discovery in Databases (KDD) process to a realistic customer-service risk scenario. Acting as a Data Scientist, students analyse a historical Customer Service Escalation Risk dataset to help an organisation identify early indicators of dissatisfaction and operational bottlenecks that may lead to serious or legal customer escalations. The resulting analysis is intended to support strategic decisions relating to staffing, employee training, customer-journey improvement and escalation prevention. CMP-7023B_Assessement_2 (2) The dataset incorporates customer demographics, account characteristics, communication channels, issue categories, operational measures such as waiting times, transfers and SLA breaches, behavioural indicators including sentiment and response delays, and commercial variables such as monthly fees and contract value. The target variable, escalation_level, contains four categories: No escalation, Minor escalation, Serious escalation and Legal escalation. CMP-7023B_Assessement_2 (2) Students begin with data exploration and visualisation, producing appropriate descriptive statistics and identifying patterns, distributions and potential data-quality concerns. They then perform data cleansing, transformation, feature engineering and preprocessing. Variables that may introduce leakage or unreliable predictions because of their meaning, timing or quality must be critically assessed and justified. CMP-7023B_Assessement_2 (2) The supervised-learning stage requires students to develop, tune and compare predictive models using techniques such as k-nearest neighbours, Decision Trees, Support Vector Machines, ensemble methods or neural networks. Appropriate multiclass evaluation metrics must be used, alongside interpretation of influential variables and model behaviour. CMP-7023B_Assessement_2 (2) The assessment also includes unsupervised learning, requiring comparison of clustering methods such as K-Means and hierarchical clustering after removal of the target variable. Students may apply encoding, normalisation and dimensionality-reduction methods such as PCA or t-SNE and must interpret how the resulting clusters relate to escalation behaviour. CMP-7023B_Assessement_2 (2) Overall, the project assesses independent analytical judgement, modelling justification, comparative evaluation and clear communication of actionable findings for both technical and executive audiences. CMP-7023B_Assessement_2 (2) Overview word count: approximately 340 words. AI-use note: AI tools may only assist with small, specific code snippets. Any AI-generated code must be clearly acknowledged and cited, while the analysis, coding decisions, interpretation and final evaluation must remain the student's own work. CMP-7023B_Assessement_2 (2)
Read Model Answer →
Data Mining / Data Science
Customer Service Escalation Risk Analytics Using Data Mining and Machine Learning
This advanced Data Mining assessment applies the Knowledge Discovery in Databases (KDD) process to a real-world customer-service analytics scenario. Acting as a Data Scientist, students analyse a historical Customer Service Escalation Risk dataset to help an organisation reduce serious and legal customer escalations by identifying early signs of dissatisfaction, service bottlenecks and operational risk. The findings are intended to support business decisions relating to staffing, employee training, customer-journey improvement and escalation prevention. The dataset contains information covering customer demographics, account characteristics, communication channels, issue categories, operational measures such as wait times, transfers and SLA breaches, behavioural indicators including sentiment and response delays, and commercial variables such as monthly fees and contract value. The target variable contains four escalation outcomes: No escalation, Minor escalation, Serious escalation and Legal escalation. The first stage requires data exploration, visualisation and summary, including examination of variable distributions, dataset structure, descriptive characteristics and potential data-quality issues. Students then perform appropriate data cleaning, transformation, feature engineering and preprocessing. Particular attention must be given to variables that could introduce prediction leakage because of their meaning, timing or reliability. The supervised-learning component requires development and tuning of predictive models using suitable techniques such as k-nearest neighbours, Decision Trees, Support Vector Machines, ensembles or neural networks. Models must be evaluated using appropriate multiclass metrics and compared systematically, with interpretation of influential features and model behaviour. The assessment also requires unsupervised learning. After removing the escalation target, students apply and compare clustering approaches such as K-Means and hierarchical clustering. Appropriate preprocessing, encoding, normalisation or dimensionality reduction may be used, with visualisations such as PCA, t-SNE or scatterplots used to explore cluster structure and its relationship with escalation behaviour. Overall, the project assesses the student's ability to independently design a coherent KDD workflow, justify analytical decisions, compare alternative modelling approaches and communicate actionable findings to both technical and executive audiences. Overview word count: approximately 350 words. AI-use note: the brief permits AI tools only to assist with small, specific code snippets. Any AI-generated code must be clearly acknowledged and cited, while the submitted coding, analysis, interpretation and decision-making must remain the student's own work.
Read Model Answer →
Operations and Supply Chain Management
1,987 words
Supply Chain Analytics and Quantitative Data Analysis for Organisational Decision-Making
This postgraduate individual report focuses on the application of quantitative data analysis to Operations, Logistics and Supply Chain Management decision-making. Students are required to select an organisation from the private, public or third sector and investigate a relevant operational or supply-chain issue using quantitative data. The purpose is to demonstrate how data can be collected, prepared, analysed and interpreted to generate evidence-based insights that may support managerial decision-making. The selected dataset must relate to the organisation's operations or supply chain and may include variables such as revenues, product orders, sales, transportation costs, procurement expenditure, inventory levels or other appropriate quantitative measures. The dataset must contain at least 60 observations, and the analysis must involve at least two variables. Data may be obtained directly from organisations or from recognised secondary-data platforms and databases. The assessment consists of two equally weighted components. Part A – Motivation and Justification for the Analysis requires students to formulate relevant analytical questions and explain their practical importance by linking them to Operations and Supply Chain Management theory and business practice. Appropriate academic, industry and practitioner evidence should be used to justify the selected issue. Research questions may also be translated into testable hypotheses where appropriate. Part B – Execution of the Analysis requires students to answer the identified questions through appropriate statistical techniques. Potential methods include tables, charts, summary statistics, t-tests and regression analysis. Data may first need to be cleaned, transformed and structured before analysis. The results must then be interpreted clearly for a managerial audience such as the organisation's board, owner or CEO. The statistical analysis is expected to be conducted using Stata, with all data-cleaning, manipulation and analytical commands recorded in a reproducible do-file. The report must also demonstrate explicit links between theory and practice and contain a suitable mixture of academic and professional evidence, including at least five academic journal articles. Harvard referencing is required throughout. The resulting work demonstrates practical competence in business analytics, statistical interpretation, supply-chain decision support, reproducible analysis and evidence-based managerial communication. Overview word count: approximately 370 words.
Read Model Answer →
Cloud Computing / Big Data Technologies / Cyber Security
2,500 words
Cloud and Big Data Security Application: Design, Implementation and Evaluation
This assessment for the Cloud and Big Data Technologies module requires students to design, implement and evaluate an individual cloud-based or distributed data application. The project focuses on practical solutions involving the complex transformation, processing, storage and security of big data within cloud environments. Students are expected to demonstrate how distributed data can be organised in the cloud, how data pipelines can be used to access or process distributed databases, and how appropriate security controls can be incorporated into the resulting architecture. Students have considerable freedom when selecting their application. Suggested project directions include developing a data-science solution using SQL or MongoDB with cloud storage and an appropriate security policy; implementing privacy-preserving distributed processing using techniques such as Differential Privacy; creating multi-party authentication and group-based access-control mechanisms; or designing Multi-Level Security, Attribute-Based Encryption or Role-Based Access Control solutions. Projects may also examine distributed or cloud applications using security protocols such as SSH, SSL or IPsec. Creativity and originality are explicitly encouraged. The written component is a Design and Implementation Document of no more than approximately 2,500 words. It should present the project aims and objectives, application concept, cloud and security technologies, functional and security requirements, architecture and design decisions, protocols, access-control mechanisms, implementation process, achievements, problems encountered and overall evaluation. Relevant diagrams, such as interaction or sequence diagrams, may be used to explain system behaviour and architecture. The assessment also requires submission of the functioning Cloud and Big Data Security application and a 7-minute highlight demonstration video. The video should demonstrate the application's major features, implementation details, security functionality and, where appropriate, attack scenarios. Assessment places strong emphasis on the quality of the design and implementation documentation, originality, use of advanced features, and the overall effort and technical quality of the completed application. Students are therefore expected to demonstrate independent development rather than simply reproduce an existing tutorial.
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 →