Verified Document

Data Dictionary And Database Normalization Term Paper

¶ … Dictionaries Neo-looked confused. "Programs hacking programs?" To which the Oracle replied, "At some time, a program was written to govern everything. The only time you see a program is when it's malfunctioning, and needs to be replaced, or exiled." Jack, I know you are new in the IT department, but I can't emphasize enough the need for you to take the Oracle's advice. We want our software, CRM modules, and sales processing databases to function without being seen. We don't need any programs fowling up other programs. I don't want to have to fight any 'vampires' or 'ghost twins' because you have allowed the database data dictionary to get corrupted.

The data dictionary is a tool which keeps the other programs up-to-date, and feeds information to the other querying programs as to what to expect from the data they are receiving. The data dictionary is a separate, and important indexing database which we use in database management systems. It is composed of a file that defines the basic organization of a database, and contains a list of all files in the database, including the number of records in each file, and the names and types of each field, Etc. Most database management systems, including the system we use, keep the data dictionary hidden from users to prevent them from accidentally destroying its contents. Part of your job responsibility is to maintain this dictionary, and re-index it on a regular basis so as to keep the rest of the company software glitch-free.

While this sound like an important task and it is, the job is much simpler now that we have installed a self updating data dictionary. In the past, at the end of each sales day, the data dictionary had to be manually updated from summary reports which were received from every department. You can imagine the snafu that occurred...

Many of our sales, and customer service problems were created because at the start of the next day, the data dictionary indexing wasn't complete.
However, your predecessor convinced management to install a meta-learning data dictionary. This program automatically runs an indexing program at the end of each sales day, and updates the data dictionary as to the number of records, type of data stored in each file, etc. The nicest feature about our meta-learning data dictionary is that it also scans the individual fields in every new entry, to ensure all the entries are in the proper format. R& D. is forever forgetting to label currency with 2 decimal places, and I think one of the guys in marketing is a bit dyslexic. Someone regularly transposes letters in the customer's last names between when the item is initially entered in the new customer database, and the accounting department. The data dictionary review program will flag the entries which don't match up, and you will need to notify the departments in order to get the records corrected.

Our data dictionaries do not contain any actual data from the database. The Data dictionary is simply a bookkeeping and information management system for monitoring, and massaging the data which makes our company run. Without a data dictionary, our database management system cannot access data from the database.

Jack, since you are new to the company, I am including a review of the process we used to construct the parameters for the data dictionary. In the near future, and new program may be rolling out of the upstairs planning offices, (no, I can't say any more than that) and you will be called upon to construct a new database control system, via a data dictionary, and an entirely…

Sources used in this document:
Bibliography

Tribunella, T. (2002) Designing Relational Database Systems. The CPA Journal, Vol. 72.

Weber, A. (2000, Oct. 1) 14 No-Fail Steps to Building a Database. Target Marketing;
Cite this Document:
Copy Bibliography Citation

Related Documents

SQL Concepts and Database Design
Words: 1001 Length: 3 Document Type: Research Paper

SQL Concepts and Database Design Project Description Objective of this technical paper is to provide the database design and documentation for a finance industry to meet the Sarbanes-Oxley (SOX) compliance. The report aims to prepare the documentation of the sales database of the organization. However, data dictionary is very critical to enhance proper functioning of a database since it holds information about the database as well as the data it stores. This

Health Care Database Design and
Words: 1419 Length: 3 Document Type: Term Paper

A patchwork of laws provided narrow privacy protections for selected health data and certain keepers of that data." (Administrative Simplification in the Health Care Industry) Therefore, new technologies such as relational databases have simplified the data gathering and maintenance processes of all types of healthcare related data like the physician information process. It is not unheard of today for healthcare and insurance providers matching or 'sinking data' on a

Enterprise Architecture in an Organization
Words: 5107 Length: 14 Document Type: Annotated Bibliography

Enterprise Architecture Barratt, C.C., Acheson, P., & Luken, E. (2010). Reference models in the electronic library: The Miller Learning Center at the University of Georgia. Reference Services Review 8(1), 44 The authors of this article provide the most effective ways of providing support to the patrons of the large university to ease the undertaking of activities within its electronic library. The authors conducted research to evaluate the effectiveness of different models of

How to Perform Valuations for Municipalities in South Africa
Words: 64599 Length: 254 Document Type: Dissertation

……South African Municipalities Municipal Revenue Loss Reduction through Improved Municipal Valuation Methodologies:Balance Sheet Enhancement of South African Municipalities to Improve Rates and Taxes Revenue GenerationAbstractThis study examines the property valuation process of Municipalities in South Africa and develops a strategy for strengthening that process in order to more efficiently value properties and ultimately to enhance municipal balance sheets and increase revenue streams. This study proposes an innovative valuation method based

Interventionism From the Perspective of Realism Vs.
Words: 13409 Length: 44 Document Type: Case Study

interventionism from the perspective of realism vs. idealism. Realism is defined in relationship to states' national interests whereas idealism is defined in relation to the UN's Responsibility to Protect doctrine -- a doctrine heavily influenced by Western rhetoric over the past decade. By addressing the question of interventionism from this standpoint, by way of a case study of Libya and Syria, a picture of the realistic implications of "humanitarian

Costco Business Model
Words: 3207 Length: 10 Document Type: Essay

Business Model The company is Costco. Costco Wholesale Connections is the largest membership warehouse club chain in the United States. A warehouse club chain is a retail store that sells a wide variety of merchandise where clients are required to buy products in quantities, reducing its price markup on products up to 15%. The cheap prices, kept down by the no-frills atmosphere to the store makes the store attractive to people

Sign Up for Unlimited Study Help

Our semester plans gives you unlimited, unrestricted access to our entire library of resources —writing tools, guides, example essays, tutorials, class notes, and more.

Get Started Now