Question

The choice of a relational database management system versus a NoSQL solution depends on the problem that needs to be addressed. Often, the data structures used by NoSQL databases are more flexible than relational database tables and, in many cases, they can provide improved access speed and redundancy. Identify the type of database best suited to each scenario.

NoSQL DB
Relational DB
-Jody builds a database consisting of data from a wide variety of sources for big data analysis.
-Morgan builds tables to hold transaction records for analysis of customer purchase patterns.
-Bailey distributes the company database across several servers located in various data centers around the globe to increase availability and resiliency.
-As soon as Olivia completes the withdrawal from her bank account at the ATM, the reduced amount available in her bank account is immediately visible to a bank employee accessing Olivia's account information from the home office.
Between No SQL Databse and Relational Database identify which scenario goes to which.

Answer 1

NoSQL databases are best for handling diverse and unstructured data, relational databases are ideal for structured data and complex querying. Both NoSQL and relational databases offer features for distributing data and increasing redundancy. Relational databases are best for scenarios that require strong data consistency.

Step-by-step explanation:

1. Jody's scenario, where a wide variety of sources need to be analyzed for big data, would be best suited for a NoSQL database.

NoSQL databases are designed to handle unstructured and semi-structured data, making them ideal for handling large and diverse datasets.

2. Morgan's scenario, where tables are created to hold transaction records for analysis of customer purchase patterns, would be best suited for a relational database.

Relational databases are well-suited for structured data and offer strong data integrity and performance for transactions and complex querying.

3. Bailey's scenario, where the company database is distributed across several servers for increased availability and resiliency, could be implemented using either a NoSQL or a relational database.

Both types of databases offer features to distribute data and increase redundancy, but the specific implementation would vary depending on the database management system chosen.

4. Olivia's scenario, where the reduced amount available in her bank account is immediately visible after a withdrawal, would be best suited for a relational database.

Relational databases guarantee strong data consistency and can handle frequent read and write operations efficiently.