Filter by keyword, subject, or both. Updates live as new model answers are added to our portal.
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 Science / Data Management / Professional Practice
4,500 words
Tesla Data Science Professional Case Study: Data Management, Leadership, Entrepreneurship and Ethics
This composite case-study assessment for The Data Science Professional module requires students to critically analyse Tesla from several interconnected professional perspectives, including data management, artificial intelligence ethics, leadership, organisational development, entrepreneurship and business risk. The coursework is designed to combine technical data-science capability with strategic, ethical and managerial decision-making. a82a1aa6a2e7a3268ad021c4f5b3d44… Part A – Database Design and Distributed Frameworks focuses on data management. Students design an Entity-Relationship model and relational schema for a Tesla-related vehicle-hire business, identifying entities, relationships, cardinalities, identifiers, primary keys and foreign keys. The accompanying guidance specifies entities relating to vehicles, employees, outlets, clients, hire agreements, insurance, faults and employment records. a82a1aa6a2e7a3268ad021c4f5b3d44… 39cdc24cc46a13ddf444b8e7af838eb… The SQL component uses an Online Music database to examine Tesla customer preferences. Students create relational tables using Oracle standard SQL and write queries involving users, music, publishers, categories and download records. Evidence of implementation and query results must be provided using Oracle Live SQL. 39cdc24cc46a13ddf444b8e7af838eb… Part A also requires a critical assessment of the security, privacy and ethical implications of Tesla’s Full Self-Driving technology, connecting technical development with responsible data and AI practice. a82a1aa6a2e7a3268ad021c4f5b3d44… Part B – Leadership and Developing People requires critical evaluation of Tesla’s leadership model, organisational culture and their effects on employees and organisational performance. Students must propose a leadership and people-development strategy capable of supporting the organisation as it expands. a82a1aa6a2e7a3268ad021c4f5b3d44… Part C – Entrepreneurial Practice and Managing Risk examines a proposed Tesla spin-out venture developing innovative low-cost green hydrogen production systems. Students critically assess management support for the venture, propose an evidence-based approach to entrepreneurial risk, develop an entrepreneurial leadership role descriptor, and evaluate how GDPR and AI/data ethics may support or constrain entrepreneurial practice. a82a1aa6a2e7a3268ad021c4f5b3d44… Overall, the assessment integrates technical database design, SQL, data ethics, organisational leadership, entrepreneurship, sustainability and professional decision-making within a single Tesla-focused case study. Overview word count: approximately 360 words. Important: the assessment brief itself explicitly states that it must not be passed to third parties or posted on any website. So for a public Reference Library, use the metadata and your own finished work where permitted, but do not upload the assessment brief/guidance PDFs themselves publicly. a82a1aa6a2e7a3268ad021c4f5b3d44… The AI status is Amber: generative AI may be used for limited inspiring/planning purposes, but usage must be acknowledged with the tool, prompts and relevant evidence; the brief also specifically prohibits using LLMs to generate the Part A(3) essay. a82a1aa6a2e7a3268ad021c4f5b3d44… a82a1aa6a2e7a3268ad021c4f5b3d44…
Read Model Answer →
Data Science / Data Management / Leadership and Entrepreneurship
4,500 words
The Data Science Professional: Tesla Data Management, Leadership and Entrepreneurial Practice
This interdisciplinary Data Science Professional assessment uses Tesla as the central organisational case study to examine how data management, leadership, entrepreneurship, technology and ethics interact within a contemporary technology-driven business. Students produce an individual report of 4,500 words equivalent, combining technical data-science competencies with strategic and managerial analysis. The Data Science Professional A… The Data Science Professional A… Part A – Database Design and Distributed Frameworks focuses on data management. Students design an Entity-Relationship model for Tesla-related organisational data, translate the model into a relational schema and justify the database structure. They also work with a specified database to produce Oracle SQL queries for analytical requirements. A further component critically evaluates the security, privacy and ethical implications of Tesla's Full Self-Driving technology, supported by relevant academic evidence. The Data Science Professional A… Part B – Leadership and Developing People requires critical analysis of Tesla's leadership model and organisational culture. Students examine current leadership challenges and their implications for organisational and employee performance before proposing a leadership and people-development strategy designed to support future organisational growth, employee engagement and sustained performance. The Data Science Professional A… Part C – Entrepreneurial Practice and Managing Risk investigates the proposed creation of a Tesla spin-out venture focused on innovative, low-cost green hydrogen production systems. Students critically evaluate management support for the entrepreneurial initiative and recommend an evidence-based course of action. They must also propose a multidimensional approach to mitigating entrepreneurial risks and barriers, critically assess entrepreneurial leadership characteristics, and develop a role descriptor for the person who would lead the new venture. The Data Science Professional A… The final element examines whether GDPR and data or AI ethics constrain or support entrepreneurial practice among employees. Overall, the coursework integrates database modelling, SQL, data governance, leadership development, organisational culture, entrepreneurship, innovation, risk management and ethical decision-making within a single applied case study. The Data Science Professional A… Important for the public Reference Library: the brief explicitly states that it is for Coventry University Group students' own use and must not be passed to third parties or posted on any website. The Data Science Professional A… So publish an original high-level overview like the one above, but do not upload the original assessment brief itself to the public library.
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 →
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 →