Question

In: Computer Science

Define and describe data dictionaries and process descriptions Identify and justify your comments to the following...

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?

Solutions

Expert Solution

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:-

  • Name of the data item
  • Aliases
  • Description/purpose
  • Related data items
  • Range of values
  • Data structure definition/Forms

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.


Related Solutions

1. Dictionaries and Lists. a) Implement a list of student dictionaries containing the following data: name:...
1. Dictionaries and Lists. a) Implement a list of student dictionaries containing the following data: name: Andy, classes: ET580 MA471 ET574 name: Tim, classes: ET574 MA441 ET575 name: Diane, classes: MA441 MA471 ET574 name: Lucy, classes: ET574 ET575 MA471 name: Steven, classes: ET574 MA441 ET580 b) Implement a dictionary of courses and set each courses enrollment to 0: ET580: 0 ET574: 0 ET575: 0 MA441: 0 MA471: 0 c) Use a loop and if statements to read class data from...
Identify the central tendency you feel is the most representative of the data and justify your...
Identify the central tendency you feel is the most representative of the data and justify your answer. The total mean =54.97    The total median is 55 and the total Mode is 29 California 39 41 49 55 58 59 59 60 69 71 76 77 78 80 81 82 83 88 89 93 69.35 73.5 59 Conneticut 20 20 29 39 40 50 53 56 56 58 59 60 60 62 66 69 70 71 77 81 54.8 58.5 20...
Define and execute a process to evaluate your data warehouse data for incompleteness, nulls, and the...
Define and execute a process to evaluate your data warehouse data for incompleteness, nulls, and the ability to provide consistent query data. Create a summary for your project sponsors to inform them of the quality of data they can expect from the new data warehouse. Include the following information in your summary: Your data evaluation strategy Specific data evaluation queries Sample results per query Summary of findings Document your summary as either: A 10-slide Microsoft® PowerPoint® presentation with detailed speaker...
9. Describe the budgeting process for a sport organization. Identify and define all relevant terms
9. Describe the budgeting process for a sport organization. Identify and define all relevant terms
Describe the Migration Process. Define the 6 common migration strategies and identify one that would be...
Describe the Migration Process. Define the 6 common migration strategies and identify one that would be useful to your organization?
identify the Auditor’s opinion for each of the following independent cases. a-Explain and Justify your answer....
identify the Auditor’s opinion for each of the following independent cases. a-Explain and Justify your answer. b- bring all the alternative scenarios when answer. c- mention the appropriate auditor responses for each scenario. 1- Management refuses to permit the auditor to obtain confirmations about balances of certain vendors due judicial dispute between the client and vendors. - The auditor discovers serious deficiency of the client’s internal control. 3- The auditor discovers client’s tax evasion. 4- The auditor discovers a fraudulent...
Identify whether the following is a nominal variable or a real variable. Justify your answer. Price...
Identify whether the following is a nominal variable or a real variable. Justify your answer. Price of a compact disc   W/P: Price of a pizza: Nominal GDP: Interest paid by bank on deposits in bank accounts: Real GDP: Price of CD/Price of Pizza Real interest rate: Classical economists suggest that Money is    This is however true in the long run.
Identify the atom or ion corresponding to each of the following descriptions. (a) An atom with...
Identify the atom or ion corresponding to each of the following descriptions. (a) An atom with ground-state electron configuration [Xe]4f145d106s26p3 Atom symbol = (b) An ion with charge +2 and ground-state electron configuration [Kr]4d2 Ion symbol = (c) An ion with charge -2 and ground-state electron configuration [Ne]3s23p6 Ion symbol =
Identify one B2B company or organization that fits each of the following descriptions and describe why each belongs in the category:
MAKRKETING ProblemIdentify one B2B company or organization that fits each of the following descriptions and describe why each belongs in the category:ProducerResellerGovernmentNonprofit
Identify the competitive strategy of PIZZA HUT company, justify your answer?
Identify the competitive strategy of PIZZA HUT company, justify your answer?
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT