Scribd Logo
Upload

Welcome to Scribd!

  • 24 views

    DMAN Coursework 2 For 2023-24

    Uploaded by

    airduct31
    This document provides instructions for the second assessment item of a Data Management course. Students must develop a MongoDB database to store product data for a grocery supermarket case study. The database must contain a minimum of 100 products with details like name, price, ingredients, and nutrition info stored as individual records. Students must write 3 queries to retrieve product information and submit their work in a group of 2. They are also required to write a 300-500 word reflective report discussing how they developed the database structure and chose queries. The assessment is worth 50% of the coursework and is due on January 19th, 2024.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd

    DMAN Coursework 2 For 2023-24

    Uploaded by

    airduct31
    24 views5 pages
    This document provides instructions for the second assessment item of a Data Management course. Students must develop a MongoDB database to store product data for a grocery supermarket case study. The database must contain a minimum of 100 products with details like name, price, ingredients, and nutrition info stored as individual records. Students must write 3 queries to retrieve product information and submit their work in a group of 2. They are also required to write a 300-500 word reflective report discussing how they developed the database structure and chose queries. The assessment is worth 50% of the coursework and is due on January 19th, 2024.

    Original Title

    DMAN Coursework 2 for 2023-24 (2)

    Copyright

    © © All Rights Reserved

    Available Formats

    PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    This document provides instructions for the second assessment item of a Data Management course. Students must develop a MongoDB database to store product data for a grocery supermarket case study. The database must contain a minimum of 100 products with details like name, price, ingredients, and nutrition info stored as individual records. Students must write 3 queries to retrieve product information and submit their work in a group of 2. They are also required to write a 300-500 word reflective report discussing how they developed the database structure and chose queries. The assessment is worth 50% of the coursework and is due on January 19th, 2024.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    24 views5 pages

    DMAN Coursework 2 For 2023-24

    Uploaded by

    airduct31
    This document provides instructions for the second assessment item of a Data Management course. Students must develop a MongoDB database to store product data for a grocery supermarket case study. The database must contain a minimum of 100 products with details like name, price, ingredients, and nutrition info stored as individual records. Students must write 3 queries to retrieve product information and submit their work in a group of 2. They are also required to write a 300-500 word reflective report discussing how they developed the database structure and chose queries. The assessment is worth 50% of the coursework and is due on January 19th, 2024.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    You are on page 1of 5

    School of Computing

    Data Management Coursework 2 (2023-24)


    Module Code M33149

    Module Title Data Management

    Module Dr Olumuyiwa Matthew


    Coordinator <olumuyiwa.matthew@port.ac.uk>

    Other lecturers Cenira Souza


    <cenira.souza@port.ac.uk>

    Assessment Item Item 2


    number

    Assessment Title Set Exercise

    Date Issued 2023-10-12

    Schedule and Deliverables

    Deliverable Value Format Deadline / Date Late deadline


    ECF deadline

    ITEM 2 PMM 50% Txt/sql/doc/PDF 2024-01-19 by 2024-02-02 by


    Grocery submitted on Moodle, 16:00 Friday 19th 16:00 Friday 2nd
    Supermarket Jan 2024 – 4pm Feb, 2024 – 4pm
    Case Study – Set Group of 2
    Exercise

    Notes and Advice


    ● The Extenuating Circumstances procedure is there to support you if you have had any
    circumstances (problems) that have been serious or significant enough to prevent you
    from attending, completing or submitting an assessment on time. If you complete an
    Extenuating Circumstances Form (ECF) for this assessment, it is important that you use
    the correct module code, item number and deadline (not the late deadline) given above.
    ● ASDAC are available to any students who disclose a disability or require additional
    support for their academic studies with a good set of resources on the ASDAC Moodle
    site
    ● The University takes any form of academic misconduct (such as plagiarism or cheating)
    seriously, so please make sure your work is your own. Please ensure you adhere to our
    Code of Student Behaviour and watch the video on Plagiarism.
    ● Any material included in your coursework should be TECFAC 08 Plagiarism fully cited
    and referenced in APA 7 format. Detailed advice on referencing is available from the
    library .
    ● Any material submitted that does not meet format or submission guidelines, or falls
    outside of the submission deadline could be subject to a cap on your overall result or
    disqualification entirely.
    ● If you need additional assistance, you can ask your personal tutor, student engagement
    officer ana.baker@port.ac.uk, academic tutor xia.han@port.ac.uk or your lecturers.
    ● If you are concerned about your mental well-being, please contact our Well-being
    service.

    The portfolio for item 1 is made up of one component:

    Type Percentage

    Assessment 1 (ITEM 2) – PMM Grocery Supermarket – set exercise 50%


    group of 2

    Please note: Same group of 2 from assessment 1

    Submit via Moodle

    Assessment 2
    Hand in: Set Exercise – Friday 19th January 2024 – 4pm
    Group of 2
    You are required to develop the database that you developed in your coursework 1 as a NoSQL
    system, using a Mongo DB database. Using a document store database is a perfect way of
    storing this type of data related to the case study of PMM Grocery Supermarket to store all
    details and every element within the organization. See the case study brief below.

    You will be using MongoDB to provide the backend database for this service. You can use
    either the system on your Google virtual machines or another system such as your own
    installation of MongoDB or on the cloud such as AWS.

    CASE BRIEF: PMM Grocery Supermarket


    PMM Grocery Supermarket has decided to move from manual ways of doing things into
    digitalize method of operation. They require a new database management system to replace the
    original system they had in place as this is no longer viable for the amount of data they are
    storing. They would like a design for a centralised database that allows web interface access
    for the employees and customers.

    PMM Grocery Supermarket is an Hampshire supermarket with branches in Waterlooville,


    Fareham, Gosport, Havant, Chichester with Portsmouth as the head office.
    Staff work in different locations based on the shift pattern and each location have a
    manager who oversees the affairs of the the location. And store manager will report
    to the headoffice.

    PMM Grocery Supermarket sells products under different categories like beverages,
    bread/bakery, Canned/Jarred goods, Dairy, Dry/baking goods, frozenfoods, meats,
    produce, cleaners, personal care, paper goods etc. And each product will have details
    like product price, product Id, product name, ingredients, allergy advice, lifestyle,
    size/volume, net weight, direction for use, nutrition info, country of origin, storage
    instruction and maunfacturer.

    Example of a details –

    Product Name – Sliced Malted Bloomer Bread

    Product Price - £1.35

    Product Id – 4088600412177

    Ingredients - 𝐖𝐡𝐞𝐚𝐭 𝐅𝐥𝐨𝐮𝐫 (𝐖𝐡𝐞𝐚𝐭 𝐅𝐥𝐨𝐮𝐫, Calcium Carbonate, Iron, Niacin, Thiamin),
    Water, Malted 𝐖𝐡𝐞𝐚𝐭 (6%), Yeast, 𝐑𝐲𝐞 Flour, Rapeseed Oil, Salt, 𝐖𝐡𝐞𝐚𝐭 Bran, 𝐖𝐡𝐞𝐚𝐭
    Semolina, Malted 𝐁𝐚𝐫𝐥𝐞𝐲 Flour, Preservative: Calcium Propionate; Flour Treatment Agent:
    Ascorbic Acid.

    Net Weight – 800g

    Lifestyle - Vegetarian

    Nutrition Info. - Per 100g: Energy 1064kJ, 251kcal Fat 1.7g of which saturates 0.2g
    Carbohydrate 48g of which sugars 4.9g Fibre 4.1g Protein 8.5g Salt 0.87g

    Storage Instructions - Store in a cool, dry place away from strong odours and direct sunlight.
    Once opened, store in an airtight container. Suitable for freezing. Freeze by date mark shown
    and use within one month. Defrost thoroughly before use. Do not refreeze once defrosted.

    So, as you can see from above brief, there are different numbers of products with
    different Ingredients description, different Nutrition information, different storage
    Instruction. Therefore, this type of project lends itself to the sue of NoSQL system,
    especially a document store system such as MongoDB.

    Task T1: Database / record Development (15 marks)

    Create a NoSQL, (MongoDB) database that will store products and their
    corresponding details. You can generate random products and their details using any
    free online data generating platform or you create your own. You will require to a
    minimum of 100 products in your database. Each product will need to be stored as a
    single record in a single collection in the database. You will need to provide the code
    that you used to create the database and store the records. This will allow you to
    create the 3 queries needed for your task 2.

    Task T2: Queries (30 marks)

    Write 3 queries that will retrieve product information from your database. Think of
    the sort or things that a user will want to be able to do. For example, a user might:

    • Look for products for specific season with specific ingredients and
    Nutritional content.
    • Product availability and locations.
    • History of delivery of orders.
    • Products purchasing record based on the locations.

    Task T3: Reflective Report (5 marks)


    Write a reflective report discussing how you developed the database, the record structure and how you
    chose the queries. [300 - 500 words].

    Further information
    • We do not need to consider the technology that may be used to provide the
    front end. There is another team working on this part of the project.
    • We do not need to consider the networking required to get data requests and
    responses to and from the database.
    • Databases created in any DBMS other than MongoDB will receive 0,
    (ZERO), marks.

    Everyone should submit a copy of their group work with


    indication of the students’ ID at the top of the document.

    Marking Scheme
    Assessment 2 (T1 – T3)
    T1: Database / record Development (15 marks)
    11 - 15 marks: sensible record structure that provides a good understanding of the JSON
    structures. Consistent use of a suitable structure for each record
    6 - 10 marks: some consideration of the JSON structure used but some inconsistencies across
    the records in the database.
    0 - 5 marks: little or no consideration of proper JSON structures.

    T2: Queries (30 marks)


    For each query (3 x 10 marks) depending on:
    ● The level of complexity of the query.
    ● The query use of the query to an end user.
    ● Good differentiation from other queries.

    T3: Reflective Report (5 marks)


    3–5 marks: a good reflection, relating the development of the coursework and the student’s
    learning.
    0–2 marks: trite, weak or no reflection.

    You might also like