Tuesday, 20 December 2011

Definintions related to Data Base and Programming

Computer
Definitions
System Documentation:
System Documentation includes processing procedures, sample input and out layout.

Structured Program Designing:
The task of structure program design is aided by the use of programing aid. These includes
  1. Structure chart
  2. Flow or logic chart
  3. Pseudocodes decision table
                  Pseudocode is the step by step instruction in a plain english language.

Coding:Set of instructions using specified syntax.

Testing:Testing is an investigation process to provide admin/user with information about the quality of the product or service under test.


Debugging:Debugging is the process of finding and removing error.

Fields: Its a single item of data

Records: Its a collection of fields or data item.

Files: Its a organized collection of related records.

Key Field: It can serve as a primary key. It is also use to find the specific records from the files. It can also use to create a link b/w two or more than two tables in a given database.

Database:A database is a collection of program, date and tables in a structured way or a database is a collection of logically related files in a structured way, in a manner to satisfy the need of an organization.

Database Management Software(DBMS):On large computer systems database are linked with the application program by special software, known as Database Management Software(DBMS)

Master File: Its a main file which contain permanent data by which transactions are processed.

Transaction File:It includes input and output files for holding temporary incoming and outgoing data.

Serial access file:In Serial file the records do not follow each other in a particular order. If any record is needed to be added so it can be added in the end of the file.

Sequential access file: It is similar to serial file except the record is held in a particular order

Direct/Random access file: In this file, records are not held in any particular order and we can directly reach to any file, without processing any other file.

No comments:

Post a Comment