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

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

techniques.

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

Attachments:

"Is this question part of your assignment? We can help"

ORDER NOW