Trusted by millions of Kenyans
LoginRegister
Study resources on Kenyaplex

Get ready-made curriculum aligned revision materials

Exam papers, notes, holiday assignments and topical questions – all aligned to the Kenyan curriculum.

Browse exam papers
Or go directly to:
Class notes Holiday assignments Topical questions Other resources

Describe two approaches to checking that a logical data model supports the transactions required by the user.

Describe two approaches to checking that a logical data model supports the transactions required by the user.

Answers

KELVIN
(1) Describing the transaction
Using the first approach, you check that all the information (entities, relationships, and their attributes) required by each transaction is provided by the model, by documenting a description of each transaction’s requirements.
(2) Using transaction pathways
The second approach to validating the data model against the required transactions involves representing the pathway taken by each transaction directly on the ER diagram. Clearly, the more transactions that exist, the more complex this diagram would become, so for readability you may need several such diagrams to cover all the transactions.
kalvinspartan answered the question on July 9, 2018 at 19:19

Answer Attachments

Next: Discuss an approach to checking a data model for redundancy. Give an example to illustrate your answer.

Previous: Describe the main purpose and tasks of Step 2 of the logical database design methodology.

View more Computer Science Questions and Answers  |  Return to Questions Index

Exams With Marking Schemes

Related Questions