Lab Exercises : Individual Logical Database Design (Part 1) 1. Based on your understanding, what is the main purpose of conceptual database design? Explain them. (3 marks) 2. What are the main features of logical database design? (3 marks) 3. Discuss how the technique of normalisation can be used to validate the logical data model and the relations derived from the model. (3 marks) 4. Derive relations for the local logical data model that represent the entities, relationships, and attributes identified in the given conceptual data model (cERD) below; (10 marks) * Provide only Primary Key and Foreign Key for the derived relations. You may provide your answer below