Relational vs Non-Relational Databases | Dataford Interview Questions

Describe the difference between relational and non-relational databases.

Use the supplied PostgreSQL tables to produce a concise comparison of the two database types. Include only core characteristics and present the results in the required order.

Output

One row per core characteristic.
Columns: feature_name, relational_value, and non_relational_value.
Order by the characteristic's defined display order.

Schema

database_features

Column	Type	Description
feature_idPK	INT	Unique identifier for a comparison characteristic
feature_name	VARCHAR(100)	Name of the database characteristic
display_order	INT	Required presentation order
is_core	BOOLEAN	Whether the characteristic belongs in the core comparison

database_model_values

Column	Type	Description
feature_idPK	INT	References the characteristic being compared
relational_value	VARCHAR(255)	Description of the characteristic for relational databases
non_relational_value	VARCHAR(255)	Description of the characteristic for non-relational databases

Your question is Relational vs Non-Relational Databases. Start with the requirements and the two tables in the Question tab.

Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.

Problem