DBMS Keys and Normal Forms | Dataford Interview Questions

Explain DBMS basics including keys and normal forms.

Use the relation below and answer the question by identifying the correct key properties and normalization level for each row set. Rows with a NULL in candidate_key_value are ignored.

Output

One row per relation_name
Columns: relation_name, candidate_key_value, is_primary_key, is_candidate_key, normal_form
Ignore rows where candidate_key_value is NULL
Sort by relation_name, then candidate_key_value

Schema

dbms_basics

Column	Type	Description
relation_name	VARCHAR(100)	Name of the relation being evaluated
candidate_key_value	VARCHAR(100)	Example value used to discuss key uniqueness
is_primary_key	BOOLEAN	Whether the value is the chosen primary key
is_candidate_key	BOOLEAN	Whether the value is a minimal unique identifier
normal_form	VARCHAR(20)	Highest normal form satisfied by the relation

Your question is DBMS Keys and Normal Forms. 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