Computer Systems, Data Structures and Data Management
4CM508
4CM508 Assessment Brief – Coursework 1
Dr Muhammad Rizwan
Computer systems, data structures and data management (4CM508)
Contents
1. Module Information
Key dates and details
Assessment Type: | Individual
|
Assessment weighting: | 50% |
Learning Outcomes: | 1 |
Submission Method: | Electronic Submission via Course Resources |
Submission Date: | 20th Sep 2024 |
Provisional Feedback Release Date: | 7th Oct 2024 |
Description of the assessment
Design and analysis of a data engineering solution such as a database (table, structure, formats) for a given scenario.
Learning Outcomes
1. Design and analyse data management solutions.
Assessment Regulations
The University’s regulations, policies and procedures for students define the framework within which teaching and assessment are conducted. Please make sure you are familiar with these regulations, policies and procedures
Guidance and Presentation
You are expected to write up your answers. Your write up should look professional and provide all the necessary information which will be marked via the Blackboard submission.
For more information you should see the rubrics provided.
Submission Requirements
Students are required to submit a word/pdf document that contains answers.
on Course Resources (Blackboard) before the deadline.
2. Assignment
Please make sure you have read the marking rubrics for assignment. You will be marked using these.
NOTE: Any suspicion that the work is not your own, either through plagiarism, excessive collaboration or use of generative AI will result in an Oral Examination. This will require you to explain your work, failure to do so will result in a Fail mark.
Currently, CraftMasters Art Supplies captures all their sales transactions, inventory levels, and customer details using a paper-based system. This manual system has become increasingly inefficient as the business has expanded. They are facing challenges in managing inventory, tracking customer preferences, and processing sales, which often leads to delays, errors, and lost sales opportunities.
Recognizing these issues, CraftMasters Art Supplies has decided to digitize their entire operation. They aim to implement a modern, integrated digital solution that will allow them to streamline inventory management, enhance customer relationship management (CRM), and optimize sales processes.
You have been hired as an external consultant to help CraftMasters Art Supplies transition from their paper-based system to a digital platform. Your responsibilities include analyzing their current operations, designing a tailored digital solution, and overseeing the implementation process to ensure a seamless transition that supports their growing business needs.
Task
Produce a relational database design that captures the current data stored and provide a report (write up) that includes:
· Rationale of design choices.
· Entity Relationship Diagram (ERD) that reflects your design. This should include attributes and relationships (cardinality).
· The relational database design (Tables, connections between tables, keys, cardinality)
· The extensibility of your design that includes 4 SQL query examples working on the database
[50 Marks]
3. Marking Rubrics
SQL queries marks are included in the Extensibility of Design.