Database Managment System Essay

1433 words - 6 pages

What are the advantage of DBMS over Conventional file system. ExplainADVANTAGES OF DBMS The DBMS (Database Management System) is preferred ever the conventional file processing system due to the following advantages: 1. Controlling Data Redundancy - In the conventional file processing system, every user group maintains its own files for handling its data files. This may lead to following: • Duplication of same data in different files. • Wastage of storage space, since duplicated data is stored. • Errors may be generated due to updation of the same data in different files. • Time in entering data again and again is wasted. • Computer Resources are needlessly used. • It is very difficult to combine information. 2. Elimination of Inconsistency - In the file processing system information is duplicated throughout the system. So changes made in one file may be necessary be carried over to another file. This may lead to inconsistent data. So we need to remove this duplication of data in multiple file to eliminate inconsistency. For example: - Let us consider an example of student's result system. Suppose that in STU¬DENT file it is indicated that Roll no= 10 has opted for 'Computer' course but in RESULT file it is indicated that 'Roll No. =l 0' has opted for 'Accounts' course. Thus, in this case the two entries for z particular student don't agree with each other. Thus, database is said to be in an inconsistent state. Sc to eliminate this conflicting information we need to centralize the database. On centralizing the data base the duplication will be controlled and hence inconsistency will be removed. Data inconsistency are often encountered in every day life Consider an another example, w have all come across situations when a new address is communicated to an organization that we deal it (Eg - Telecom, Gas Company, Bank). We find that some of the communications from that organization are received at a new address while other continued to be mailed to the old address. So combining all the data in database would involve reduction in redundancy as well as inconsistency so it is likely to reduce the costs for collection storage and updating of Data. Let us again consider the example of Result system. Suppose that a student having Roll no -201 changes his course from 'Computer' to 'Arts'. The change is made in the SUBJECT file but not in RESULT'S file. This may lead to inconsistency of the data. So we need to centralize the database so that changes once made are reflected to all the tables where a particulars field is stored. Thus the update is brought automatically and is known as propagating updates. 3. Better service to the users - A DBMS is often used to provide better services to the users. In conventional system, availability of information is often poor, since it normally difficult to obtain information that the existing systems were not designed for. Once several conventional systems are combined to form one...

Find Another Essay On database managment system

Networking and Management Essay

4169 words - 17 pages differences between TCP Congestion Control and flow control. Other principles of congestion control include Global versus point-2-point, and orthogonal issues. Congestion manifests itself by causing loss of packets (buffer overflow at routers), and long delays (queuing in router buffers). Also, during congestion, there is no explicit feedback from network routers, and there is congestion inferred from end-system observed loss. In network-assisted

When the Bubble Burst Essay

1539 words - 6 pages wipe out the banks toxic assets from the largest investment banks books. Michael Lewis a former bond trader for Soloman Brothers and financial writer for Bloomberg financial news insists the environment around the banking system and a lack of restriction on risky investments is to blame for the large number of toxic assets. (Lewis 262) The government thought this cash infusion was needed at the time to curb the market hysteria. In the age

phase diagram

4456 words - 18 pages Introduction: Chemical equilibrium is a crucial topic in Chemistry. To represent and model equilibrium, the thermodynamic concept of Free energy is usually used. For a multi-component system the Gibbs free energy is a function of Pressure, Temperature and quantity (mass, moles) of each component. If one of these parameters is changed, a state change to a more energetically favorable state will occur. This state has the lowest free energy

Revolutionary Work of Art

1890 words - 8 pages Walter Benjamin emphasizes in his essay, “The Work of Art in the Age of its Technological Reproducibility” that technology used to make an artwork has changed the way it was received, and its “aura”. Aura represents the originality and authenticity of a work of art that has not been reproduced. The Sistine Chapel in the Vatican is an example of a work that has been and truly a beacon of art. It has brought a benefit and enlightenment to the art

Enlightenment Thought in New Zealand Schools

1594 words - 6 pages without the beliefs of others being forced upon them. As Scruton (1998) states “the aristocratic order had been destroyed” This also removed the exclusiveness of clerical privilege, this helped individuals to be equal and have equality with each other. (Kant, 1995). This ideal of equal opportunities continued into the nineteenth century with the development of the universal system of education. In the nineteenth century liberal ideals came

Psychological Egoism Theory

2240 words - 9 pages The theory of psychological egoism is indeed plausible. The meaning of plausible in the context of this paper refers to the validity or the conceivability of the theory in question, to explain the nature and motivation of human behavior (Hinman, 2007). Human actions are motivated by the satisfaction obtained after completing a task that they are involved in. For example, Mother Teresa was satisfied by her benevolent actions and

How Celtic Folkore has Influenced My Family

1587 words - 6 pages Every family has a unique background that influences the way they live and interact with other people. My parents, who emigrated from Ireland to the States with my three brothers in 1989, brought over their own Celtic folklore and traditions that have helped shaped the way our family operates and lives. One aspect of folklore that has helped shape my family dynamic is the Celtic cross—both its background and what role it has played in our lives

Julia Margaret Cameron

1406 words - 6 pages At a time when women were looked upon as being homemakers, wives, mothers and such the late 1850's presented a change in pace for one woman in specific. Photography was discovered in 1826 and soon after the phenomenon of photography was being experimented with and in turn brought new and different ways of photo taking not only as documenting real time, but also conceptualizing a scene in which an image would be taken. Julia Margaret Cameron will

Evaluation of School Improvement

1403 words - 6 pages on school website. The communication tool also includes email and discussion boards within the school district network system to exchange thoughts. This format allows users to archive articles, share comments and resources to the community, and teacher ability to use blog information in the classroom (Wang and Hsua, 2008). Blogger tools for educator, such as blogger.com, by Google and wordpress.com enable users to exchange knowledge (Wang

Case Study: The Benefits of Animal Testing

1757 words - 7 pages Nine year old Amy has already had a rough start in life. She was born with an abnormal heart that hinders her everyday activities. Amy is unable to keep up with kids her own age because she often tires out easily. As a consequence, she has very little friends and is often alone. Amy is forced to take different medications everyday just to survive. Amy’s life consists of medicine, doctors, and constant hospital visits. However, Amy is due for a

Myth and Magic: Realism in "One Hundred Years of Solitude"

1531 words - 6 pages “He enjoyed his grandmother's unique way of telling stories. No matter how fantastic or improbable her statements, she always delivered them as if they were the irrefutable truth” (Wikipedia, 2011). Experiences are particular instances of one personally encountering or undergoing something and in these moments of time life changes for the best or the worst and memories are formed. These recollections such as riding your first bicycle, going to

Similar Essays

Knowledge Engeering Essay

1060 words - 4 pages to the issues and business parctices concerning knowledge managment, the three facets of the knowledge management task(capture, storage, and deployment)are elucidated as follows:-1.Knowledge capture-Is performed by a systematic knowledge acquisition process in which a conceptual model of aspects of the company's business domain is used to guide the capture of cases and rules.2.Knowledge storage-Is performed by using a knowledge representation

Project Planning And Human Capital Essay

2036 words - 8 pages participants in the project with relevant information regarding the project. Using a database is not always a great way to go about retrieving this information because the database is not always correct. If there is a glitch in the system or issue with a report, it can invalidate the actuals causing the project to postpone. "The capability to communicate project position in real-time is not a common functionality that Project Managers expect out of the

Network Security Essay

2852 words - 11 pages of a file managment system. Interception Interception is when an unauthorised personnal gains access to an asset. This is when an attack is on confidentiality. E.g wiretapping or copying of files. Below Modification Modification is when when a personnal gains access to data this is an attack on the integrity . (eg altering the message being sent or program)see below: Fabrication Fabrication is when a person inserts counterfiet objects into

Value Chain Management Of Walmart Inc

2981 words - 12 pages ) explain Enterprise Resource Planning (ERP) is an enterprise-wide information system, coordinate information for planning and controlling all operations activities, help to manage business processes, using a common database and shared management reporting tools. Operations and thus adding value. Walmart ERP share common data, produce and access information in a real time environment, computerized inventory control and production planning, ability