Preview

Advantages and Disadvantages of Database Management

Good Essays
Open Document
Open Document
686 Words
Grammar
Grammar
Plagiarism
Plagiarism
Writing
Writing
Score
Score
Advantages and Disadvantages of Database Management
Advantages of Database Management Systems
Database Management System (DBMS) aids in storage, control, manipulation and retrieval of data. This article lists the advantages of database management systems.

Database is a software program, used to store, delete, update and retrieve data. A database can be limited to a single desktop computer or can be stored in large server machines, like the IBM Mainframe. There are various database management systems available in the market. Some of them are Sybase, Microsoft SQL Server, Oracle RDBMS, PostgreSQL, MySQL, etc.

The advantages of the database management systems can be enumerated as under:

Warehouse of Information
The database management systems are warehouses of information, where large amount of data can be stored. The common examples in commercial applications are inventory data, personnel data, etc. It often happens that a common man uses a database management system, without even realizing, that it is being used. The best examples for the same, would be the address book of a cell phone, digital diaries, etc. Both these equipments store data in their internal database.

Defining Attributes
The unique data field in a table is assigned a primary key. The primary key helps in the identification of data. It also checks for duplicates within the same table, thereby reducing data redundancy. There are tables, which have a secondary key in addition to the primary key. The secondary key is also called 'foreign key'. The secondary key refers to the primary key of another table, thus establishing a relationship between the two tables.

Systematic Storage
The data is stored in the form of tables. The tables consists of rows and columns. The primary and secondary key help to eliminate data redundancy, enabling systematic storage of data.

Changes to Schema
The table schema can be changed and it is not platform dependent. Therefore, the tables in the system can be edited to add new columns and rows without

You May Also Find These Documents Helpful

  • Satisfactory Essays

    cis3730_Exam1_Studyguide

    • 512 Words
    • 2 Pages

    Be able to give examples of tables, specify their primary keys, and explain how they are related through foreign keys.…

    • 512 Words
    • 2 Pages
    Satisfactory Essays
  • Powerful Essays

    Pt2520 Unit 6

    • 1447 Words
    • 6 Pages

    Data redundancy in a database occurs when same data is stored in different tables unnecessarily. A modification to a single piece of data requires change for all the copies. Use of flat file database designs and spreadsheets can lead to data redundancy.…

    • 1447 Words
    • 6 Pages
    Powerful Essays
  • Satisfactory Essays

    A database is essentially an electronic filing system. It allows you to quickly select desired pieces of information.…

    • 492 Words
    • 3 Pages
    Satisfactory Essays
  • Powerful Essays

    Unit 18 - Database P1, M1

    • 995 Words
    • 4 Pages

    Database, it is a place use to store lots of data. It can be seen as a filing cabinet. And database management system (DBMS) is software that specificity designs for managing the data in database such as create, update or delete them. General is including security, retrieval and backup features. User also allows using the data to create a report or share data with multi-user.…

    • 995 Words
    • 4 Pages
    Powerful Essays
  • Satisfactory Essays

    Dbm/380 Database Concepts

    • 461 Words
    • 2 Pages

    A database is a set of programs and applications used to store data, this allows the data to be used by different individuals in different areas and access information from it quickly. A database stores the information so it can be used at a later time so additional information can be added, taken away, or used as needed. Once in the database the data is compressed so it takes up less space in the computer’s memory. The database allows those authorized to use the data within it and control the creation, maintenance, and use of a database. A database stores various kinds of files, data records, and other objects. There are a variety of database models; there is the relational model or object model, which supports applications. That use query languages, which are high-level programming languages, and dedicated database languages that simplify writing database application programs. The main function of a database is basically retrieving and presenting information it controls, in doing this it allows the users data access, protects the data’s and makes it more manageable. It also provides safety features for the data so that it is not lost or misplaced and if there is a serious event or natural disaster, fire, etc. it can be recovered and restored from a backup. In my work we use Microsoft Access as a relational database for employment records and to store our client information such as names, addresses, phone numbers, and email addresses from this database we send out a monthly newsletter with special offers on services and products. By using a database, an organization saves time and money because it is only a few simple steps and we can email all of our clients and customers a monthly newsletter which informs them about what is happening within the organization, services and products we offer, and what is on sale which generates more business. By using a…

    • 461 Words
    • 2 Pages
    Satisfactory Essays
  • Satisfactory Essays

    A database is a computer mechanism for storing and retrieving data. It gives one true command of their data, enabling one to retrieve it, sort it, analyze it, summarize it, and report results in changes.…

    • 598 Words
    • 3 Pages
    Satisfactory Essays
  • Satisfactory Essays

    Week 1 BIS221

    • 536 Words
    • 3 Pages

    Databases allows companies to organize all their information on one place, making it easy for people to access and share information.…

    • 536 Words
    • 3 Pages
    Satisfactory Essays
  • Good Essays

    Dbm 381 Week 1paper

    • 885 Words
    • 4 Pages

    A database consists of one or more tables; each containing data stored as individual records. Different database architectures determine how the tables and records are organized or related…

    • 885 Words
    • 4 Pages
    Good Essays
  • Powerful Essays

    As you recall, data is a collection of facts (numbers, text, even audio and video files) that is processed into usable information. Much like a spreadsheet, a database is a collection of such facts that you can then slice and dice in various ways to extract information or make decisions. However, the advantage and primary use of a database over a spreadsheet is its ability to handle a large volume of data and yet allow for quick access to the information that is desired.…

    • 1190 Words
    • 5 Pages
    Powerful Essays
  • Good Essays

    As we know, database is structured collection of data; computer based databases are usually organized into one or more tables. A table stores data in a format similar to a published table and consists of a series of rows and columns.…

    • 688 Words
    • 3 Pages
    Good Essays
  • Satisfactory Essays

    Cis 276

    • 374 Words
    • 2 Pages

    9.What is a primary key? A primary key is a combination of one or more column values in a table that make a row of data unique within a database table.…

    • 374 Words
    • 2 Pages
    Satisfactory Essays
  • Satisfactory Essays

    A database is a digital storage area that helps people keep track of things. A database can also be considered a digital list because in the real world work environment keeping track of lists is very valuable to an organization but in other cases a simple list is not agile and versatile enough to avoid data inconsistencies and other problems that may arise. Databases are valuable because they are not only objects that remain in list form; but also a tool that can be split into table data that may then help to solve organizational problems that lead to more efficient business operation. The best way to organize valuable information within an organization is rational database tables because they are designed to solve all of the problems and limitations that comes with simple lists.…

    • 414 Words
    • 2 Pages
    Satisfactory Essays
  • Satisfactory Essays

    Database Design Paper

    • 429 Words
    • 2 Pages

    A database system is a computer term for a structured set of data that can be saved, retrieved, added to or deleted from relatively easy. There are a variety of different databases and the type of database will determine how the data is arranged when it is stored and how that data will be located when it is called upon.…

    • 429 Words
    • 2 Pages
    Satisfactory Essays
  • Better Essays

    A database management system is a system in which data is stored, processed, and retrieved. These systems are known for security accuracy and consistency. A well-planned and developed database is very efficient and meets the current and future needs of the organization to which it services. This type of system allows the organization to collectively store and manipulate data.…

    • 864 Words
    • 4 Pages
    Better Essays
  • Better Essays

    Homework 1

    • 1168 Words
    • 4 Pages

    Database Management Systems can be found everywhere inside and outside the workplace. For example, Database Management Systems at work would include inventory systems, flight reservation systems and computerized library systems. Outside the workplace one would find DBMS's such as an Automated Teller Machine or ATM. DBMS's have become a very important part of everyday business not just because of their effectiveness, but also their advantages that I will later discuss.I currently working in the Naval Construction field and there are many important…

    • 1168 Words
    • 4 Pages
    Better Essays