Answered You can hire a professional tutor to get the answer.
CIS 8040 Fundamentals of Management Systems Assignment 2 Due date: 2/1/2017 at 11: from a B- to a C-), and a charge of academic dishonesty.
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.
