Systems Analysis - Logical relational data model and Data model navigation
Related learning outcomes from the unit outline:
- Demonstrate evidence of the knowledge set and skill set required by the systems analyst.
- Apply structured techniques to the analysis of current systems and modelling of future systems.
Background: The objective of this tutorial is to provide you with practice in designing a logical relational data model and then confirming its correctness using data model navigation. The task involves reviewing the conceptual data model for the PPA case study and then converting it using the rules described in the lecture into a logical relational data model. It is recommended you do this task in your team to pool your resources.
Tasks:
1. Draw the logical relational data model.
2. Confirm the logical relational data model by conducting data model navigation on:
a. the portbill
b. the invoice