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 →
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 →