Synthesize user requirements/inputs and analyse the matching data processing needs, demonstrating…

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.


Needs help with similar assignment?

We are available 24x7 to deliver the best services and assignment ready within 3-4 hours? Order a custom-written, plagiarism-free paper

Order Over WhatsApp Place an Order Online