Part 1 - Implementing a Relational Database with SQLAlchemy
Objective:
In this challenge you will implement an integration application with SQLite based on a relational schema provided. Therefore, use the schema within the context of client and account to create the classes for your API. These classes will represent the relational database tables within the application.
tasks:
- Application with the definition of the schema by means of classes using SQLAlchemy.
- Insertion of a minimum data set for manipulating information
- Execution of data retrieval methods via SQLAlchemy
Part 2 - Implementing a NoSQL Database with Pymongo
You will implement a NoSQL database with mongodb to provide an aggregated view of the relational model. As such, existing customer and account information is contained within documents according to customer.
Perform the operations:
- Connect to mongo atlas and create a database
- Define a bank collection to create customer documents
- Insert documents with the structure mentioned
- Write information retrieval instructions based on key and value pairs as you did in class.
link to the database schema: https://dbdesigner.page.link/pv6o5mXB7EMEcux36