This website uses cookies to ensure you have the best experience. Learn more

Dbms, Explains What It Is And How It Is Used In Corporations

659 words - 3 pages

DBMS is necessary to create so department managers such as purchasing, operations, marketing, and personnel may be convinced DBMS is ideal. Designing a database follows a general rule of stage analysis in:Data requirementsClassification of informationRelationship between informationTransactions among data entitiesRules of identityThere are two stages in creating a database design: data and functional model. The data model is the actual data and how it is managed. The functional model decides how data is supposed to be accessed, processed, and queried. In order to design the data model, the following steps have to be followed:•Identification of data objects and relationships: this is the analytical stage and data entities are given meaning through the flow of information in the system.•Drafting initial Entity-Relationship diagram with entities and relationships: the relationships between various data entities are established and documented using an ...view middle of the document...

•Adding business and integrity rules to the Model: database becomes more than a collection of data.The process of normalization in a database is important after the Entity-Relationship diagram has been designed. "The planning and analysis stage is one part that will determine how the end system will be" (Davidson 2007). The link between data entities are simplified through normalization that helps in better design for a functional model.To meet the political expectations of others it is safe to believe that users not aware of the design development are confused to how this will works and whether it would serve their needs. The proposed model is a database model interlinked using a primary key infrastructure. To convince the other managers from other departments would be to involve them in the whole data and system analysis process.End users can be shown a demonstration of a 'prototype' database where data entered by the purchasing manager pertaining to raw materials bought becomes available for the operations manager to use on the system. Once the operations manager is done and makes the appropriate entries, the marketing manager can then view how many units of a certain product are available for accepting orders from customers and meeting sales targets. The personnel managers work is interlinked since employment records will be kept and appropriate people will be assigned to different departments or projects within the organization. The operations manager will enter the amount worked by a certain employee along with the marketing manager entering how many sales targets were met by certain sales personnel. All this information will help the personnel manager in calculating salaries etc.References:Davidson, L. (2007). Ten Common Database Design Mistakes. Retrieved, May 30, 2007, from http://www.simple-talk.com/sql/database-administration/ten-common-database-design-mistakes/The University of Texas at Austin (2004). Introduction to Data Modeling. Retrieved, May 30, 2007, from http://www.utexas.edu/its/windows/database/datamodeling/dm/design.htmlUllman, L. (2003) MySQL Database Design. Retrieved, May 30, 2007, from http://www.peachpit.com/articles/article.asp?p=30885&rl=1

Other Essays On DBMS, Explains What It Is And How It Is Used In Corporations

What Is The Natural Law? What Are Its Principles? How Does It Relate To Positive Laws?

1992 words - 8 pages establishing a clear hierarchy of law in his political philosophy, it is unclear how Aquinas intends States to move up in such a hierarchy which is presumably what States should aspire to. Apart from serving as simply an administrative entity which tackles the practical intricacies of the Natural Law by which Positive Law is governed, it also serves as a stepping stone to a scenario in which a State is governed by Natural Law and in which

This essay tells what is true and what is false in the movie Braveheart. So it tells the historical accuracy of the film

545 words - 3 pages Celtic practice but it was during Roman times, over a thousand years before. In the film Irish troops switched sides, as they were suppose to charge against the Scottish however this too is false. (Sullivan)Braveheart does a wonderful job tell the story in a accurate matter and the only time false information is used it is obvious that it was added by Hollywood. Braveheart in general is a accurate film and can be used to discuss its time period.

How Is Animal Imagery Used In "Therese Raquin" And "If This Is A Man"?

2007 words - 9 pages watchingThe bears as they ambled heavily around. It amused him to see how these big creatures walked. He stared at them, with his jaw hanging, wide-eyed, like an idiot enjoying the sight of them as they moved. Animal imagery is used to show the differences in Therese and Camille.Throughout the novel Mme Raquin's cat helps us judge the temperament of the characters by the way they act toward it. In the preface Zola says the cat is meant to be Mme

This Paper Is About Racism And How It Is Portrayed In The Following Poems: "Jasper Texas 1998," "A Party Down At The Square," And "Night, Death, Mississippi."

1112 words - 5 pages . Although it has stricken hundreds of millions of people every hour, this affliction stands strong. Though this disease can be treated, there is no absolute cure. What could be this ghastly, castrating ailment that permeates into all that we see and do? This despicable ailment catches to the tune of racism. According to Encarta Online Encyclopedia, racism is "making the race of other people a factor in attitudes or actions concerning them. Racism

A Project On Night Blindness, How It Is Caused, Treatment Of Night Blindness, Symptoms, And Preventing Night Blindness

737 words - 3 pages documented. Taking supplements of Vitamin A in eye drops is also used to treat Night Blindness. Also just eating healthy and eating more Vitamin A products can improve your eyesight at night, but it is not a permanent cure for Night Blindness.Prevention:Preventions of Night blindness can be a larger intake of Vitamin A. Eating leafy green vegetables such as spinach that is rich in Vitamin A. It contains more vitamin A than most other green

In our media today it seems that every day is

293 words - 2 pages In our media today it seems that every day is a new story that tops yesterday's story. Our media is on a war path to get better ratings, no matter what the consequences. It seems that they do not care about whose life they destroy, as long as, it is more sensational than the last. I feel that they need to be held more accountable for their actions, and have more common sense about what they print. I feel that something needs to be done now, not

This essay is about best friends and how after 13 years they still can spend so long together and not regret it. MY BEST FRIEND is the title

345 words - 2 pages tall, have blonde hair, blue eyes, and wear the same size clothing. It always seems that my closet has more of her clothes in it than mine and vice-versa. Our mothers can never stop comparing notes as to how many clothes they have bought us that they've never seen on their actual child wear. When we are together people swears that we speak a different language and between finishing each others sentences, the jumps in topics, and the giggles it's

This Is A Book Called H*O*L*E*S. It Is Very Good And I Hope You Enjoy It!

250 words - 1 page choice, Camp Green Lake. He took the bus to Texas (Where it was.) So, he thought he would be in a place with a lake. Guess again, it was a desert and very hot there and also only two trees! It doesn't seem that great now. Mr. Pendanski was the first person he met there. He was the tent counsulor. HTey didn't sleep in a house, they slep in a tent. Now he's sleeping in a bed that used to belong to Barfbag. See how his adventure goes and read the book by Louis Sachar called HOLES! I hope you enjoy it as much as I did. Even though it is a very long book with 50 chapters, it is very addictive and you'll never want to put it down.

E-Commerce. The Advancements In E-Commerce. Is It Really Working? The Affects. Has It Been Working In The Past?

1397 words - 6 pages handful of companies that are showing growth, and even fewer that are producing profits. Less than 20% of Canadians who use the internet have purchased products using e-commerce (Globe and Mail : Report on E-business). What is even more unsettling is the inability to conserve customers who have used e-commerce. Current trends indicate that there is no need or room for the success of e-commerce within the already cramped world of cyberspace.The

The Nervous System: A Basic Summary Of The Nervous System And Some Little Peices On How It Is Affected By Disease And Drugs

1560 words - 7 pages NERVOUS SYSTEM The Nervous system receives sensory input from the internal and external environment. It then integrates the input in the sensory centers of the brain and responds to the various stimuli with a motor output, which can be converted by the organs to some form of energy ie. movement, release of hormones, changes in heart rate. The response is not always conscious, for instance if you were climbing a mountain and the air became

Modern Day Marriage. Is it possible?

489 words - 2 pages it takes to have a successful marriage. The couple has to show how they feel in other ways then just words; they talk to the other person and let them know what is expected out of the marriage. People have to make a marriage work by working for it; it is not just something that is going to be great all the time.

Similar Papers

El Dorado Explored: Explains How El Dorado Was A Utopia And What Effect It Had On Candide. It Also Explains How Eldorado Is A Counter For The Evils Of Europe

1754 words - 8 pages mentions clothing or furniture made of hummingbird down in a number of places in the text. The idea that there would be so much hummingbird down that you could stuff couches with it is used as a metaphor for the plenty that the people of this country enjoy. Even though the people there have some knowledge of the outside world and the fact that the Europeans would kill them all for the pebbles and dirt of the land, they are not corruptible. There

What Is Abortion, And Should Is It Moral?

1702 words - 7 pages pregnant women, many of them being either pro-choice or pro life, though some are completely neutral and are just there to help the mothers. It all comes soen to the desicion ohn whether to abort the baby or not, the choice is really the mothers, at least by law in the United States. Through much research, and though both arguments are very strong, the immorallity of abortion has shone through. thoug there are may different reasons that a

Organisational Culture, How It Develops And How It Is Effected By External And Internal Forces

4670 words - 19 pages IntroductionThe rise in non-western organisation's and their successes in the world economy (mainly Japanese) has been the main cause for the research into, and the development of the concepts which underline the key aspects of organisational culture i.e:*What is culture?*How can these cultures be catagorised?*How does culture develop?*How culture is effected by internal and external influences?*And how it can effect other aspects of the

Leprosy ; Includes What Bacteria It Is Caused By, The Orgin Of The Disease, How Many People Are Affected By It In The United States And In Alaska During 1999 And 2000, And More. 3 Pages Long

524 words - 3 pages leprosy in the past, they decide to build leper colonies, so leprosy wouldn't spread throughout the towns. There are cures today, so we don't need any leprosy colonies. The medication takes about six months to cure lepromatous form, and about two years to cure the tuberculoid form.Today leprosy is very rare in the United States, but in India there are about 500,000 new cases every year. This is why it is very important that education about this disease, and the medication for this disease is available for people around the world.