In: Computer Science
Define and describe data dictionaries and process descriptions Identify and justify your comments to the following question: Was the subject of improving the forms a physical implementation issue?
DATA DICTIONARY: A data dictionary is referred to as a file or a set of file that includes database metadata which means it is a repository of data about data. It is use to organise names and their references and holds the record about other objects in the database. A data dictionary is a important component a s it contain information about the insight of a data base and who has the permission to access it & where it is stored physically and it also stores the information about the ownership and the data relationship to other objects. Data dictionary doesn't interact by the user of the database but only handled by the database administrator.
The data dictionary includes information of:-
there are two type of data dictionary are available which are:
ACTIVE DATA DICTIONARY: This is type of data dictionary which is automatically updated by the database management system which means if the structure of the database or its specifications change at any point of time, it should be reflected in the data dictionary. DBMS is responsible for it in which the data dictionary reside and keeps the information current.This is known as active data dictionary which is self updating
PASSIVE DATA DICTIONARY: A passive data dictionary is a type of data dictionary manually updated to match the database unlike active data dictionary its not easy to handle , it is maintained separately to the database whose contents are stored in the dictionary i.e it is not updated automatically if the database is modified.A passive data dictionary is need to be handled carefully or else it will be out of sync
PROCESS DESCRIPTION: A process description describes how the process is going to be execute and informs about the effective installation, commissioning, operation, control and maintenance.
A process is a program in execution which is executed in sequence.
A operating system constructs and maintains tables of information about each entity that it is managing memory tables, IO tables, file tables, process tables. and the collection of these item are used to control the processes in a OS which is known as process control block.