What is a data dictionary, what does it contain, and how is it used?
What is a data dictionary, what does it contain, and how is it used?
Homework Answers
What is data dictionary?
It is a file or set of files or a collection of descriptions of data objects often called as metadata repository. It is a repository of information about data such as meaning, relationship, usage ,format and so on.
What does it contains?
1) It contains metadata of database. It stores specific facts about system like, processes, entities ,data flow and data stored.
2) It contains records about other objects in the database.
3) It contains data ownership, data relationship with other objects .
4) In relational database , it includes names of the tables and their owners, names of the indexes and columns , primary and foreign key relationship to other tables.
5) The source of data for each database field
6) An explanation of what each database filled means
7) Existence of default value for all fields of the organization
8) Who can access to each field
9) What tables each filed exists in and the size of all fields
10) Type of data, ( image, integer, real etc)
How it is used?
Data dictionary can be easily used by SQL server to execute queries. It helps and provide automatic updates of objects which are added, removed or changed. Without data dictionary, we have to use object explorer and open each and every table which will lead wastage of time for searching and finding.
Add Answer to:
What is a data dictionary, what does it contain, and how
is it used?
in c++ sample output Description A dictionary is a collection of words that contain at least...
in
c++
sample output
Description A dictionary is a collection of words that contain at least one definition. One way to represent a dictionary is through the use of an array, actually two arrays. For a dictionary to print the term with matching definition, each array: Must contain the same number of elements as the other array Each element in array 1 (term) must contain a match in array 2 (definition). 1. 2. Take the following array examples: Array 1=...
You are to examine data elements in a data dictionary. Explain how you would create a...
You are to examine data elements in a data dictionary. Explain how you would create a data dictionary. You can select a specific data element and apply it to the data dictionary.
In general, how useful is the Dictionary/Hash Table data structure? Can you think of other uses...
In general, how useful is the Dictionary/Hash Table data structure? Can you think of other uses aside from those? If we didn’t have the Dictionary/Hash Table data structure can you think of another way to implement the dictionary concept? Can the Dictionary/Hash Table ADT accept/handle null key entries? What about null values? Why or why not? Given these behaviors, what conclusions can you draw about tuning a hash table for different data sets?
Create a DFD diagram 0, and Data dictionary for the information system at a typical library....
Create a DFD diagram 0, and Data dictionary for the information system at a typical library. Create a solution as realistic as possible. Data dictionary should contain information about all data elements. In your solution include at least: - 10 processes, - 3 data stores, - 3 external entity instructions: don't use any online diagram or copy paste from internet. Do your own
Real-World Case 3 Janice has been given the responsibility of creating and managing the data dictionary...
Real-World Case 3 Janice has been given the responsibility of creating and managing the data dictionary for the laboratory IS that is being implemented. There are a number of existing ISs that have their own data dictionaries. The data from the laboratory IS will be part of a clinical data repository. She decided that she needs to start from scratch to make the data dictionary the best it can be. She is reviewing the data dictionaries from the other ISs...
What do Basic Financial Statement (BFS) contain? Discuss. How does one decide what entities to include...
What do Basic Financial Statement (BFS) contain? Discuss. How does one decide what entities to include in the government’s BFS? What bases of accounting are used in the BFS? Will long-term assets appear on the governmental funds balance sheet? Why?
Question 5 a. How many lone electrons does iridium contain? b. How many lone electrons does Rut4 contain? c. How ma...
Question 5 a. How many lone electrons does iridium contain? b. How many lone electrons does Rut4 contain? c. How many lone electrons does Mo+3 contain?
13inary Search Tree Using a binary search tree, you are tasked with building a dictionary program...
13inary Search Tree Using a binary search tree, you are tasked with building a dictionary program which you can store a word with its definition. Each node of the tree will contain the word and definition. The word is what will be used as the key to sort our data. The dictionary should allow you to search for a word. If the word exist then the definition will display. You can also add words to the dictionary. For testing you...
6. Assume the length of salt is 8 bits and the dictionary for dictionary attack contain...
6. Assume the length of salt is 8 bits and the dictionary for dictionary attack contain 300 words. Calculate the search space for attacking salted passwords. Give an exact number. Ans: 7. Assume receiver B received a signed document from sender A under the digital signature on the document? A’s public key, B’s public key, A’s private key, B’s private key 8. ________ refer to technique involving the use of human insiders to circumvent computer. 9. Encrypt “SECURITY” using Caesar...
Health Information Exchange : What is it used for? How does it work and where does...
Health Information Exchange : What is it used for? How does it work and where does the data come from (sources)? What are its benefits? What are its drawbacks?
in
c++
sample output
Description A dictionary is a collection of words that contain at least one definition. One way to represent a dictionary is through the use of an array, actually two arrays. For a dictionary to print the term with matching definition, each array: Must contain the same number of elements as the other array Each element in array 1 (term) must contain a match in array 2 (definition). 1. 2. Take the following array examples: Array 1=...
Question 5 a. How many lone electrons does iridium contain? b. How many lone electrons does Rut4 contain? c. How many lone electrons does Mo+3 contain?
13inary Search Tree Using a binary search tree, you are tasked with building a dictionary program which you can store a word with its definition. Each node of the tree will contain the word and definition. The word is what will be used as the key to sort our data. The dictionary should allow you to search for a word. If the word exist then the definition will display. You can also add words to the dictionary. For testing you...
Most questions answered within 3 hours.
-
Where is the error in this code sequence?
String s1 = "Hello";
String s2 = "ello";...
asked 10 months ago -
Financial data for Joel de Paris, Inc., for last year
follow:
Joel de Paris, Inc.
Balance...
asked 10 months ago -
Consider this reaction:
Al2(SO4)3 (aq)+ BaCl3
(aq) Al2Cl6 (aq)- +
3BaSO4(s) . What is the...
asked 10 months ago -
Suppose that Savneet is considering increasing her
recent random sample from 20 car rentals to 40...
asked 10 months ago -
Trucks arrive at an unloading terminal at an average rate of 120
per hour.
Trucks arrive...
asked 10 months ago -
Why are methanol and ethanol completely soluble in water while
octanol is not very little soluble....
asked 10 months ago -
A facilities manager at a university reads in a research report
that the mean amount of...
asked 10 months ago -
When the CuSO4 is rehydrated by adding water to the anhydrous
compound, is this an endothermic...
asked 10 months ago -
A ray of sunlight is passing from diamond into crown glass; the
angle of incidence is...
asked 10 months ago -
A block of mass 0.249 kg is placed on top of a light, vertical
spring of...
asked 10 months ago -
how do the kidneys compensate in the presences of acidosis
a) trigger hyperventilate
b) reserve acid...
asked 10 months ago -
Question 501 pts
The rental rate of capital to the firm increases. Which of the
following...
asked 10 months ago