3 problems to be solved – Converting ER model to logical design and normalizing it to 3NF.

Convert/Map the conceptual model into relations (a logical model) following the mapping rules. You should show the mapping of each entity type and each relationship type and provide a brief explanation of the mapping.

Perform normalization of each mapped relation. You should (a) identify all candidate keys, primary key and non-prime attributes, (b) show the functional dependencies between the attributes including full dependencies and transitive dependencies, (c) determine the normal form of the relation with a brief explanation, (d) normalize the relation into 3NF relations if it is not in 3NF.