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

Discuss the purpose of analyzing the transactions that have to be supported and describe the type of information you would collect and analyze.

Discuss the purpose of analyzing the transactions that have to be supported and describe the type of information you would collect and analyze.

Answers

KELVIN
You can’t make meaningful physical design decisions until you understand in detail the transactions that have to be supported. In analyzing the transactions, you’re attempting to identify performance criteria, such as:
•the transactions that run frequently and will have a significant impact on performance;
•the transactions that are critical to the operation of the business;
•the times of the day/week when there will be a high demand made on the database (called the peak load).
You’ll use this information to identify the parts of the database that may cause performance problems. At the same time, you need to identify the high-level functionality of the transactions, such as the columns that are updated in an update transaction or the columns that are retrieved in a query. You’ll use this information to select appropriate file organizations and indexes.
kalvinspartan answered the question on July 4, 2018 at 17:13

Answer Attachments

Next: Discuss some of the main reasons for selecting a column as a potential candidate for indexing. Give examples to illustrate your answer.

Previous: Analyse why free markets often lead to large wage differentials

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

Exams With Marking Schemes

Related Questions