ipl-logo

Advantages And Disadvantages Of Relational Database Management System

1110 Words5 Pages

Relational Database Management System:
This type of database management system that stores the data in the form of related tables. It is a social database administrator which deals with some typical kind of queries and uses SQL for the development of the database. This type of database is a very powerful database as it deals with the relations which makes the data manipulations easier other than any other database. It has the features of data entry, data deletion, and creating of new entry and records etc. the database provides the ease of accessing and maintaining data easily.
Advantages of RDBMS:
1. Prevents Data redundancy:
In relational database management systems the tables with the specific data have relation among them that’s why the required data is taken from the previous tables which prevents the data redundancy.
2. Data security:
In a relational database management system the data access is privileged which means that the database administrator has the authority of giving access of data to some particular users which makes the data secure.
3. Easy to use:
This type of database uses tables which is better and easy to create and use.
Disadvantages of RDBMS:
1. Slow:
As compared to other databases this database has a slow extraction of results thus making it a slower database.
2. Memory space:
The database uses tables having rows and columns which consumes a lot of physical memory which becomes a disadvantage of the database.
P a g e 2 | 5
3. Complexity:
The idea of

Show More
Related

  • Nt1330 Unit 1 Study Guide

    317 Words  | 2 Pages

    Each table space in an Oracle database consists of one or more files called a) Records b) name space c) data files d) PFILE Answer: c 36. The management information system (MIS) structure with one main computer system is called a a) Ordered MIS structure b) Scattered MIS structure c) Centralized MIS structure d) Decentralized MIS structure Answer: c 37.

    Read More

  • Chapter Summary: Mathematics Through The Eyes Of Faith

    1351 Words  | 6 Pages

    The third chapter through the fifth chapter addresses three specific mathematical areas. These areas are infinity, dimension, and chance. In my opinion, these three subjects are evident by the complexity of mathematics for students that might have otherwise been unaware. “What Does Infinite Mean?” This is the how the authors begin chapter three.

    Read More

  • Nt1310 Unit 2 Assignment

    774 Words  | 4 Pages

    1. Prior to this week’s assigned reading my understanding of nature was one that is ever expanding, with atoms at the core. Being science and mathematics nearly always come hand in hand, I related math to be an essential matter as well. Through our reading I found connections through Heraclitus, as he understood our world as one of fire “meaning there is always” change and flux. Condensing the entire world into one substance is quite brave as the world as we know and understand is composed of many elements and substances.

    Read More

  • Compare And Contrast Arthur O Grady And Selma

    597 Words  | 3 Pages

    Formalism

    Read More

  • The Geology Of The Mesa Verde National Park

    1051 Words  | 5 Pages

    Understanding the internal workings and cycles of the world around you can make or break and entire

    Read More

  • Gossip Girl Vs Fahrenheit 451

    764 Words  | 4 Pages

    With Lexile measures touted as a key indicator of text complexity as defined by Common Core State Standards, we must critically consider what Lexile bands offer teachers and students, and what they don

    Read More

  • How Computers Change The Way We Think By Sherry Turkle Summary

    555 Words  | 3 Pages

    By making something easier one can almost always expect to see some losses in the process. Carr explains how throughout time, with every new invention, there were people who were worried about the loss that the invention would incur. (59) He gives examples like how Plato’s Phaedrus Socrates was worried that the development of writing would make people forgetful and “filled with the conceit of wisdom instead of real wisdom.” (55) When people stop exercising the mind, its capacity will decrease.

    Read More

  • The Great Influenza Rhetorical Analysis Essay

    861 Words  | 4 Pages

    Barry uses this to show how researchers must make decisions on how to do something while not having a very structured knowledge foundation for that specific topic of interest. Together, the uses of these similar structures allows for a more cohesive train of thought about the characteristics of scientific

    Read More

  • Pt1420 Unit 2 Assignment 2

    102 Words  | 1 Pages

    ASSIGNMENT 02 Key: A key is an attribute or set of attribute in a relation that identifies a tuple in a relation. Followings are the keys used in Data Base Management System. 1) Super Key: A set of attributes of relations for which it holds in all relation there are no two rows that have same values for attributes.

    Read More

  • Nt1330 Unit 2.7 Observation Paper

    500 Words  | 2 Pages

    Therefore, the database can be any type such as SQL, Not Only SQL (NOSQL), or other. Observation_4: The CSP needs to apply a virtualization technology on storage resources to serve CSUs’ demands efficiently. Therefore, a

    Read More

  • Summary Of Eleven By Sandra Cisneros

    1388 Words  | 6 Pages

    Through the precise use of basic and simplistic

    Read More

  • Analysis Of Kathleen Moore's Wild Comfort: The Solace Of Nature

    921 Words  | 4 Pages

    Paulo Coelho once said: “We have to stop and be humble enough to understand that there is something called mystery”. Indeed, if mystery was a forest, human beings were just tiny wildflowers that grew under the shade of “knowledge”. The more we think we understand this world, the less we truly know it. In “Wild Comfort: The Solace of Nature,” Kathleen Moore believes that “mystery is infinite”(Moore, 153). We will never understand the mystery, even though how well-developed the science can be.

    Read More

  • Simple Components In King Lear

    1647 Words  | 7 Pages

    Advancement in an area of knowledge can take different approaches: reducing a complex whole to simple components, integrating simple components into a complex whole and studying the complex whole as itself to understand emergent properties. In this essay, complex wholes are defined to be intricate products of many interconnected simple components. Simple components are fundamental features that give rise to the complex whole, and emergent properties are unpredictable and irreducible attributes of the complex whole. I will be exploring the approaches adopted and their interconnectivity for gaining knowledge in the natural sciences and the arts In the natural sciences, complex wholes are defined to be the understanding of phenomena, while simple components are factors and variables of a phenomenon.

    Read More

  • Tracking System Advantages And Disadvantages

    1693 Words  | 7 Pages

    Reduce operational costs and increase productivity Track and control vehicles to provide better communication, deliver timely services, etc. Transmit information quickly via satellites and prepare vehicle reports All these features of the tracking system ultimately reduces operational costs and increase productivity. Guide drivers and increase fuel efficiency By careful analysing driver behavior such as speeding, acceleration, braking etc. , you will be able to avoid unnecessary wear and tear of the vehicle, operating, and fuel costs With the help of sensors, you can minimize maintenance costs, machine failures, and thereby prevent vehicle theft Improve cargo security and driver's safety You can identify theft instantly

    Read More

  • Microsoft Windows Advantages And Disadvantages

    1163 Words  | 5 Pages

    Starting with the definition of an operating system is:- “An Operating System is said to be the soul of any Pentium of computer or the type of computer.” Microsoft Windows is one of the known used operating systems now-a-days. Now a days windows covers 90% of operating system market stock. The basic reason behind the use of Microsoft Windows is; it is easy-to-use and comes equipped with all the services. Some of the types of operating systems are: • Open source (OS) • Real Time Embedded (OS)

    Read More

More about Advantages And Disadvantages Of Relational Database Management System

Open Document