Data Dictionary and Database Normalization Term Paper

Open, View, and/or
Download this Document

Total Length: 1228 words ( 4 double-spaced pages)

Total Sources: 1+

Page 1 of 4

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 when a department forgot to run the report at the end of the day. 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.

Stuck Writing Your "Data Dictionary and Database Normalization" Term Paper?

View All Our Example Data Dictionary and Database Normalization Term Paper

Have A Custom Example Essay Written



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….....

Show More ⇣

     Open the full completed essay and source list


OR

     Order a one-of-a-kind custom essay on this topic


sample essay writing service

Cite This Resource:

Latest APA Format (6th edition)

Copy Reference
"Data Dictionary And Database Normalization" (2004, February 16) Retrieved May 4, 2024, from
https://www.aceyourpaper.com/essays/data-dictionary-database-normalization-163141

Latest MLA Format (8th edition)

Copy Reference
"Data Dictionary And Database Normalization" 16 February 2004. Web.4 May. 2024. <
https://www.aceyourpaper.com/essays/data-dictionary-database-normalization-163141>

Latest Chicago Format (16th edition)

Copy Reference
"Data Dictionary And Database Normalization", 16 February 2004, Accessed.4 May. 2024,
https://www.aceyourpaper.com/essays/data-dictionary-database-normalization-163141
   

Open, View, and/or
Download this Document
order custom essay example