Database Management

[JairMDE]

Development of the database management

• Establish methods to collect and input ticket information, prices, and product data into the database.
• Select an appropriate database system (e.g., SQL, NoSQL) for storing ticket-related data.
• Develop SQL or other query languages to retrieve specific ticket, price, or product information based on user requirements.
• Implement authentication and authorization mechanisms to control who can access, modify, and delete data.

[VOC12]

MongoDB has emerged as a powerful solution for data storage and manipulation, with a focus on flexibility, scalability and performance, and because it is a popular choice for a wide range of applications, from small startups to large enterprises. For all above, We have decided to use MongoDB, our data collection process starts with Structuring the Database in MongoDB.

[VOC12]

In MongoDB, data is organized in collections and Documents, collections are equivalent to tables in a relational database system, and documents, which are the individual records in those collections; therefore based on our needs (Ticket-Wallet), we have decided to make 4 different collections to group related documents, these collections will be:

- Supermarket - Pharmacy - Restaurants - Stores

These collections will store purchase tickets from the different stores, this will be done in this way as a Walmart tikcet doesn't have the same format as a Hardware store ticket, as an example

[VOC12]

Documents: Each document in a collection represents an individual record. For example, the document in the "Restaurant" collection could represent a purchase ticket, with fields such as date, time, restaurant, and total.

[VOC12]

I have been thinking about this structure for teh documents:

• Supermarket Document : Date, Market, Products, Total
• Pharmacy Document: Date, Service or products, Total
• Restaurant Document: Date, time or kind of meal (as breakfast, snack, dinner, lunch etc), restaurant name, and total.
• Store: Date, store (as Ferreteria, make up store, novelties and accessories store), products, time, total

What do u think?

[JairMDE]

Hello @VOC12 start researching about how text can be stored in MongoDB as any type of file so the development team can start researching about the way it can be saved.

Also, we already have some outputs that you can you can start analyzing, and maybe before that, you could apply an algorithm that detects specific key words! 😆🥳

[VOC12]

Oki doki, On my way boss!