What are the differences between SQL and NoSQL databases, and when would you choose each for Binance?
Use the database_options table. Write a query that returns the preferred database options and their relevant characteristics.
technology, database_model, consistency_model, schema_flexibility, and binance_use_casedatabase_model, then technology, both ascending| Column | Type | Description |
|---|---|---|
| option_idPK | INT | Unique identifier for the database option |
| technology | VARCHAR(100) | Name of the database technology |
| database_model | VARCHAR(20) | Database classification, SQL or NoSQL |
| consistency_model | VARCHAR(100) | Typical consistency characteristics |
| schema_flexibility | VARCHAR(100) | Degree of schema enforcement or flexibility |
| binance_use_case | VARCHAR(150) | Illustrative Binance-oriented use case |
| is_preferred | BOOLEAN | Whether the option should appear in the comparison |