An ideal data dictionary should have everything a DBA wants to know about the database.

1 Conceptual, External, and internal database descriptions.

2.    Descriptions of attributes (fields), entities (record types) as well as origin, cross- references and meaning of data elements.

3. Authorisation ,Synonyms and security codes.

4. Which external schemas are used by which programs, what their authorisations are, and who the users are.

5.  Statistics about database and its usage containing number of records, etc.

A data dictionary is executed as a database so that users can query its contents. The cost efficiency of a data dictionary increases as the difficulty of an information system increases. A data dictionary can be an enormous asset not only to the DBA for database design, execution and maintenance, but also to managers or end users in their project planning.

Posted Date: 3/6/2013 5:02:41 AM | Location : United States

Ask an Expert

Related Discussions:- Ideal data dictionary, Assignment Help, Ask Question on Ideal data dictionary, Get Answer, Expert's Help, Ideal data dictionary Discussions

Write discussion on Ideal data dictionary
Your posts are moderated

Write your message here..

Related Questions

Differentiate between a subquery and a join, Differentiate between a subque... Differentiate between a subquery and a join If we need to acquire information from one or more tables after that either subquery or join can be used. If the columns which are t

Develop a simple database of student records, In this programming assignmen... In this programming assignment, you will develop a simple database of student records. Here are the requirements: 1) A student record contains a name and a number. We assume tha

Difference between sql and sql*plus, Difference between SQL and SQL*Plus ... Difference between SQL and SQL*Plus SQL SQL*Plus SQL is a language SQL *Plus is an environment It   is   bas

Define clause in sql to specify query result must be sorted, The clause in ... The clause in SQL which specifies that the query result should be sorted in ascending or descending order based upon the values of one or much more columns is Ans : Order by

Scope of traffic data management, A TDMS project plan is not a typical Info... A TDMS project plan is not a typical Information Technology project plan; therefore, a traffic data project has several unique characteristics: Traffic data management system

Introduction to database technology, 1. Create the tables for the play-sche... 1. Create the tables for the play-scheme database as specified in the TMA. 2. Enter the data as given in the spreadsheet. 3. Create queries to retrieve specified information

Database management issues, You are required to write a report which evalua... You are required to write a report which evaluates two of the following issues in relation to your case study database: a. Security issues b. Performance issues c. Backup

What is data defination language, What is DDL? Make a list of commands with... What is DDL? Make a list of commands with short description used in DDL Ans: Data Definition Language that is abbreviated as DDL is a computer language for defining data struct

Describe the nested-loop join and block-nested loop join, Describe the nest... Describe the nested-loop join and block-nested loop join.   Ans:   The block nested- loop join algorithm is as described below:     for every block B r of relation R do beg

Managing databases, Code an Oracle Database trigger to enforce the constrai... Code an Oracle Database trigger to enforce the constraint that an employee can never change his or her department.