Case Study (Group Assignment) – 30% (Due Week 12)Objectives(s)This assessment item relates to the unit learning outcomes as in the unit descriptor. Thisassessment is designed to improve students’ skills to analyze organizational databaserequirements, develop a data model to reflect the organization’s business rules and use datamanipulation language to manage database. This assessment covers the following LOs.LO1. Synthesize user requirements/inputs and analyse the matching data processing needs,demonstrating adaptability to changing circumstances.LO2. Develop an enterprise data model that reflects the organization’s fundamental businessrules; refine the conceptual data model, including all entities, relationships, attributes,and business rules.LO3. Derive a physical design from the logical design taking into account application, hardware,operating system, and data communications networks requirements. further use of datamanipulation language to query, update, and manage a databaseLO4. Identify functional dependencies, referential integrity, data integrity and securityrequirements; Further integrate and merge physical design by applying normalizationtechniques.LO5. Design and build a database system using the knowledge acquired in the unit as well asthrough further research on recent trends to demonstrate competence in variousadvanced tasks with regard to modelling, designing, and implementing a DBMS includingData warehousing, Data Management, DB Security.