Previous Topic: Determining How Often Transactions Will Be ExecutedNext Topic: Determining the Database Entry Point and Access Key for Each Transaction


Identifying Access Requirements

You identify access requirements for each transaction by analyzing the business functions documented during the logical design process. Different business functions require different access to the database.

Business function

The following business function specifies that you need to access the SKILL, EXPERTISE, and EMPLOYEE entities:

Add a skill for an employee.

Sample transactions

The following table shows access requirements for three sample transactions.

Transaction

Processing Mode

Time

Priority

Frequency of Access

Access Requirements

Add or delete a claim

Online

3 seconds

High

100/day

EMPLOYEE CLAIM

List of employees for an office

Batch

15 minutes

Medium

5/week

OFFICE EMPLOYEE

Show salary grade for all jobs

Online

6 seconds

Low

5/week

JOB SALARY GRADE