Docsity
Docsity

Prepare for your exams
Prepare for your exams

Study with the several resources on Docsity


Earn points to download
Earn points to download

Earn points by helping other students or get them with a premium plan


Guidelines and tips
Guidelines and tips

Database Table Interaction Logic for IT_AD Table, Essays (university) of Computer Networks

The logic for interacting with a database table named it_ad. The interactions include fetching records, inserting new records, updating existing records, and setting up the form for adding or updating records. The form fields, mandatory fields, and validation rules are specified for each interaction. The logic also includes tables and fields for validation checks and non-editable fields for displaying information only.

Typology: Essays (university)

2015/2016

Uploaded on 02/04/2016

bennet_mathew
bennet_mathew 🇺🇸

1 document

1 / 15

Toggle sidebar

This page cannot be seen from the preview

Don't miss anything!

bg1
Item Alternative Description
Select Find Add
Item Name Alternative Description Type
Logic:
Table Name IT_AD
Table Action Fetch
Form Fields Table Fields
Item Name AD_IT_NM
Alternative Description AD_IT_AD
Type AD_AD_TY
click on 'Find' button
Relevant Fields should be fetched from table IT_AD
pf3
pf4
pf5
pf8
pf9
pfa
pfd
pfe
pff

Partial preview of the text

Download Database Table Interaction Logic for IT_AD Table and more Essays (university) Computer Networks in PDF only on Docsity!

Item Alternative Description

Select Find Add

Item Name Alternative Description Type

Logic:

Table Name IT_AD

Table Action Fetch

Form Fields Table Fields Item Name AD_IT_NM Alternative Description AD_IT_AD Type AD_AD_TY

click on 'Find' button Relevant Fields should be fetched from table IT_AD

Alternative Description Setup

Save Cancel

Item No

Type Alternative Description

M M

Logic:

Table Name IT_AD

Table Action Insert

Form Fields Table Fields (^) Mandatory (Y/N)

Item Name AD_IT_NM (^) Y

Alternative Description AD_IT_AD^ Y Type AD_AD_TY (^) Y

M M

Validation (system should give error if the value doesn't exist for each field)

table - IT_MT, field IM_IT_NM

table - CL_CD, field CL_CL_CD where CL_SO_CD = 'IN' and CL_TY_PE = 'AD'

e, the form should be closed and return to first screen

Review Alternative Description

Save Cancel Options

Item No M

Type Alternative Description

M M

Note

M Mandatory fields

Non editable fields, only display the information

Logic:

Table Name IT_AD

Table Action Update

Form Fields Table Fields (^) Mandatory (Y/N) Validation (system should give err

Item Name AD_IT_NM (^) Y table - IT_MT, field IM_IT_NM

M

alidation (system should give error if the value doesn't exist for each field)

able - IT_MT, field IM_IT_NM

able - CL_CD, field CL_CL_CD where CL_SO_CD = 'IN' and CL_TY_PE = 'AD'

to the table, the form should be closed and return to first screen

Alternative Description Setup

Save Cancel Options

Item No M

Type Alternative Description

M M

Logic:

Table Name IT_AD

Table Action Insert

Form Fields Table Fields (^) MandatoryValidation (system should give error if the value doesn't e

Item Name AD_IT_NM (^) Y table - IT_MT, field IM_IT_NM

Alternative Descr

AD_IT_AD

Y

Type AD_AD_TY Y table - CL_CD, field CL_CL_CD where CL_SO_CD = 'IN' and

Click on Save button Records should be inserted to table IT_AD. After saving records into the table, the form should be c