[Solved] CSCI5709Tutorial 6- Creating Database Instances [Group Deliverable]

Learning Outcomes:

• Creating a SQL/NoSQL database instance based on the project stack
• Creating a SQL/NoSQL database instance on AWS RDS/ AWS DynamoDb/ MongoDB Atlas – Connecting a SQL/NoSQL database to workbench.

Instructions:

• Creating a Database Instance:
  • Configure AWS or MongoDB Atlas account.
  • Create a SQL or NoSQL instance on AWS or MongoDB Atlas.
• Connecting to a Database Instance:
  • Connect to the created instance.
  • Create a simple database schema and add it to the instance.
• Addition, Retrieval, and Modification/Update Queries:
  • Write an insertion query to 10-15 records.
  • Write a retrieval query to get all records.
  • Write a modification query to modify one record. Write a retrieval query to get modified record.