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

A basic understanding of concrete and it is used in modern society - memorial university of newfoundland - essay

2858 words - 12 pages Introduction: Due to its strength, durability and comparatively low cost, concrete is one of the most commonly used building materials today. It is used to produce objects as simple as bricks or as complex as hydroelectric dams. In its simplicity concrete consists of three materials: aggregate, cement and water. When sand and stones (aggregate) along with cement are mixed with water, a chemical process takes place between the water and cement

Quasars - what is it and what does it do - Science yr 10 - Research paper

638 words - 3 pages call them quasars when we view it from any side on angle other then perpendicular. In that instance, it is called a radio galaxy. Blazars are viewed when we can see directly the barrel of the jet leaving the nucleus. The word quasar and the acronym QSR stand for ‘quasi-stellar radio source’ (meaning star like) due to their appearance. When quasar jets interact with gas surrounding the galaxy, radio waves are emitted, which can be seen as radio

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.

What is True Power and how does it relate to us as human beings? - English - Expository Essay

543 words - 3 pages “What is True Power” Aileen Gonzalez 3rd period 9/18/17 Have you ever wished you could be a superhero? Well, what if I told you already are but haven’t discovered your powers yet. Everyone has powers to make a change and has the true power to do it. I believe that true power is the capacity to make a difference, start an influence, and be a true hero. Everyone has the power to make a change but it’s up to us when and how we want to use it. We

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

Informative report on what herpes is and how it affects many people today - Fundamental of speech - Research paper

458 words - 2 pages Herpes Many adults in the U.S are infected with the illness of herpes and it’s considered common nowadays. Herpes is classified a common illness and can contaminate anyone who practices anal sex or comes in contact with cold sores. There are many different places one can get herpes on ranging from really anywhere on the body. Herpes can also have a variety of symptoms that can’t really be distinctive, that it is herpes. When it comes to this

What is Parkour? Who made Parkour? How did Parkour come to be what it is today? - English 001 - Essay

1833 words - 8 pages . An example of this can be someone that doesn’t do parkour and they see a picnic table as something to sit or eat on but a traceur would see it as an obstacle to jump over. A traceur in parkour does not do parkour to impress other people but because they love the challenges and benefits it provides. According to Dan Edwardes, the meaning of a traceur which is “bullet” was chosen because of how David Belle and his contemporaries put an emphasis on

Economics of Sweden : the history of how sweden became what it is today. - Econ - essay

1850 words - 8 pages revolution was a period in the 18th and 19th centuries which completely changed how products are manufactured, employment, and quality of life in Great Britain. The industrial revolution was such a change in society at the time it planted the seeds of how we are now in modern days. Innovations in the textile industry are what drove the industrial revolution. Textiles used to be made in people's homes with merchants supplying the raw materials needed to

What Is Plagiarism? How can it affect your life? - Essay - essay

460 words - 2 pages include the items listed in the descriptions of these two felonies, it may be a Class A misdemeanor. The act of plagiarism is very wrong and can result in a very large punishment, that is why no matter what I will never plagiarize a single document/ phrase or anything. The act of forgery is also very wrong and can also result in very serious punishments and that is why I will also never forge anything especially a signature. Plagiarism can get me

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.

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

Models Of Democracy Essay About The Models Of Democracy And How It Is Used In Our Us Government Valdosta State University/ American Government Essay

1557 words - 7 pages opinion to people who live on the opposite side of the country. Which really sucks for those who don’t have money because they should get a say and it is really hard for them. The majoritarian structure is a lot different than that. It says in the book that the way they control and get a say in what they want is they pick someone who has the same values in the first place. Which is not a very good system because their views could change or they

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

Identity, What Is The Identity How And Whats Creating It Sociology Essay

1007 words - 5 pages was born as a boy and in their 20’s starts to have different preferences etc, proofs that identity can change as well as our beliefs and values. As a conclusion I would like to bring a quote of Ted Hughes (Iron Man) ‘you are what you choose to be’. Identity is an individual thing and as we go through the life it might change or it might not. It depends on our own experience as well as our choices and the environment we are in. We might stay the