Answer to Question #254221 in Other for graham

Question

Solve the following 20 marks

i. Design a database with a minimum of 5 class diagrams with a denormalized data concept.

ii. Discuss and demonstrate with examples using tables for a specific class diagram where the de-normalized situation will be a problem during data entry.

iii. Produce a normalized version of your class diagram and discus briefly the significance of normalization.

iv. Using SQL query results as an example, demonstrate and explain why data redundancy can pose a challenge during information extraction.

Answer 1

Dear graham, your question requires a lot of work, which neither of our experts is ready to perform for free. We advise you to convert it to a fully qualified order and we will try to help you. Please click the link below to proceed: Submit order