Scribd Logo
Upload

Welcome to Scribd!

  • 405 views

    09 Cloud Computing Final 09 Task Performance 1 ARG PDF

    Uploaded by

    John michael Demelletes
    The document describes creating a point-of-sale (POS) system in MongoDB with billing, sales reports, and inventory management features. It instructs to create a data schema to demonstrate the system using embedded or referenced data models. It provides a transaction example of a customer purchasing two iPhone X phones worth 45,000 PHP each, lowering the inventory quantity from 49 phones.

    Copyright:

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

    09 Cloud Computing Final 09 Task Performance 1 ARG PDF

    Uploaded by

    John michael Demelletes
    405 views2 pages
    The document describes creating a point-of-sale (POS) system in MongoDB with billing, sales reports, and inventory management features. It instructs to create a data schema to demonstrate the system using embedded or referenced data models. It provides a transaction example of a customer purchasing two iPhone X phones worth 45,000 PHP each, lowering the inventory quantity from 49 phones.

    Original Title

    09_Cloud_Computing__Final__09_Task_Performance_1___ARG.pdf (1)

    Copyright

    © © All Rights Reserved

    Available Formats

    PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    The document describes creating a point-of-sale (POS) system in MongoDB with billing, sales reports, and inventory management features. It instructs to create a data schema to demonstrate the system using embedded or referenced data models. It provides a transaction example of a customer purchasing two iPhone X phones worth 45,000 PHP each, lowering the inventory quantity from 49 phones.

    Copyright:

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

    09 Cloud Computing Final 09 Task Performance 1 ARG PDF

    Uploaded by

    John michael Demelletes
    The document describes creating a point-of-sale (POS) system in MongoDB with billing, sales reports, and inventory management features. It instructs to create a data schema to demonstrate the system using embedded or referenced data models. It provides a transaction example of a customer purchasing two iPhone X phones worth 45,000 PHP each, lowering the inventory quantity from 49 phones.

    Copyright:

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

    Rizza C.

    Venezuela January 23, 2022


    BSCpE-501A Advanced Database Systems

    09 Cloud Computing (Final)


    09 Task Performance 1 - ARG
    Instructions
    Assume that you are planning to make a point-of-sale system (POS) that will have the following
    features
     Billing and order processing/records: This will generate order invoice.
     Sales report/records: This will track the information of all the items that are sold.
     Inventory management: This will manage the quantity of the item stocks.

    1. Using Mongo shell, create a data schema that will demonstrate the described system.
    You can use either embedded or reference data model based on your data design.
    2. After creating the schema, insert appropriate data based on the given transaction below:

    o On July 21, 2021, Rosalie purchased two (2) iPhone-X phones worth ₱45,000
    each. Before Rosalie made the purchase, the quantity of iPhone-X is 49.

    Answer:
    Mongo DB code
    Insert data:

     Billing and Order Processing/Records:

    >db.billing.insert({"_id":"02000179626A","customer_name":"Rosalie","item":"iPhone-
    X","price":45000,"date":"July 21, 2021"});
    >db.billing.insert({"_id":"02000179626B","customer_name":"Rosalie","item":"iPhone-
    X","price":45000,"date":" July 21, 2021"});
    >db.billing.insert({"_id":"02000179626C","customer_name":"Rosalie","item":"iPhone-
    X","price":45000,"date":" July 21, 2021"});
    >db.billing.find()

    This study source was downloaded by 100000858703985 from CourseHero.com on 01-18-2023 22:07:42 GMT -06:00

    https://www.coursehero.com/file/127896543/09-Cloud-Computing-Final-09-Task-Performance-1-ARGpdf/
     Sales Report/Record:

    >db.sale.insert({ "_id": "042821", "item": "iPhone-X", "price": 45000, "quantity": 3 })


    >db.sale.find()

     Inventory Management:

    >db.inventory.insert({"_id": "010390","item": "iPhone-X","price": 45000,"quantity": 49,


    "creator":{ "$ref":"sale"," $id":"042821"," $db":"test"}});
    >db.inventory.find()

    This study source was downloaded by 100000858703985 from CourseHero.com on 01-18-2023 22:07:42 GMT -06:00

    https://www.coursehero.com/file/127896543/09-Cloud-Computing-Final-09-Task-Performance-1-ARGpdf/
    Powered by TCPDF (www.tcpdf.org)

    You might also like