We are designing a document database for the online booking system of our beauty salon. Our database must support queries for the following access patterns:

$$ Retrieve customer information by a customer identifier.

$$ Retrieve reservation history of a customer.

$$ Retrieve reservation details by reservation code.

$$ Retrieve all reservations by date. $($All bookings made in May $5$th $2024)$

$$ Retrieve all reservations by their status $($e$.$g$.,$confirmed$,$pending approval$)$

$$ Retrieve all reservations by their status and date $($e$.$g$.,$ All $$confirmed$$ bookings made in

September $2023,$ or in $2022,$ or on April $20$th $2021)$

Insert data into your model for three users who each has made three reservations.

You need to submit two files:

$1-$ A JSON file including your data model $($please see below how to export your data model$)$

$2-$ A document including your answers to the following questions.

A$)$ What attribute did you choose as your partition key? Explain your logic.

B$)$ Do you think a sorting key is required for your data model? Why? If yes, please explain which attribute are you choosing as your SK$?$

C$)$ Are you using any GSI? If yes explain for each GSI what PK or SK you are using.

D$)$ Explain for each access pattern, how do you run a query? Demonstrate your answer by giving an example from your data model. For instance:

to support access pattern number $1$ we can use a query with PK$=[...]$ and SK $$less than $[...].$ Insert the screenshot of the result of your queries in the report. In total, you need to run $5$ queries $(1$ per access pattern$).$

Can you please show me your answer of screenshots by working on NoSQL Workbench

for Amazon DynamoDB for all steps to see how you work on NoSQL Workbench