Filter by keyword, subject, or both. Updates live as new model answers are added to our portal.
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 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 →
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 →