Case Study (Group Assignment) – 30% (Due Week 12)
This assessment item relates to the unit learning outcomes as in the unit descriptor. This
assessment is designed to improve students’ skills to analyze organizational database
requirements, develop a data model to reflect the organization’s business rules and use data
manipulation 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 business
rules; 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 data
manipulation language to query, update, and manage a database
LO4. Identify functional dependencies, referential integrity, data integrity and security
requirements; Further integrate and merge physical design by applying normalization
LO5. Design and build a database system using the knowledge acquired in the unit as well as
through further research on recent trends to demonstrate competence in various
advanced tasks with regard to modelling, designing, and implementing a DBMS including
Data warehousing, Data Management, DB Security.