Database Normalization | Dataford Interview Questions

Describe the process of normalization in databases.

Use the supplied parameter records to represent the normalized form of the data. Explain the progression through the normal forms, the anomalies normalization prevents, and the trade-offs involved.

Output

Return deployment_id, parameter_name, and parameter_value.
Return one row per deployment parameter, ordered by deployment_id, then parameter_name, with NULL values last.

Schema

deployment_parameters

Column	Type	Description
parameter_idPK	INT	Unique identifier for the parameter record
deployment_id	INT	Identifier of the deployment
parameter_name	VARCHAR(100)	Name of one deployment parameter
parameter_value	VARCHAR(255)	Atomic value assigned to the parameter

Your question is Database Normalization. Start with the requirements and the one table 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