ANSWERS: 1
  • Relational databases are servers that hold tables that link together using primary and foreign keys. These databases have several benefits, including speed, visual layouts, data integrity and better analysis tools.

    Significance

    Relational databases replaced old "flat file" databases. The change in technology now allows business to hold millions of records and quickly retrieve and edit data.

    Function

    The function of relational databases is mainly for large record sets of data. They allow users to connect separate entities like customers and customer orders.

    Features

    The main feature and benefit of a relational database is the use of primary and foreign keys. These items are placed on tables to allow tables to link together. Relational databases also offer security and network support.

    Types

    There are three main relational databases used in businesses. MySQL is a free database tool. Microsoft SQL Server and Oracle are large-capacity databases used for enterprise data processing.

    Potential

    Relational databases can be used by the individual on small websites. However, a major enterprise can make the greatest use of a relational database's ability to hold millions of records and process the data within seconds.

    Source:

    Sunadal Data Systems: Benefits of Relational Database

Copyright 2023, Wired Ivy, LLC

Answerbag | Terms of Service | Privacy Policy