Basics of the RDBMS and SQL

Define and Understand the Basics of the RDBMS

  • A relational database consists of collections of data known as tables. A table
    could be a list of ship names and some statistics about each ship. Another table
    might be a list of employees who work on different ships. The “relational”
    aspect to a “relational database” has to do with the common information that
    “relates” two tables together—for example, the list of employees might include
    an entry for each employee’s ship assignment, which would relate back to the
    list of ships and each ship’s statistics.
  • A relational database management system, or RDBMS, is a system in which
    these relational tables and related objects can be created easily, using common
    functions to add, change, and remove data and database objects from
    the RDBMS.

Understand the Unique Role of SQL in Modern Software Systems

  • SQL is most widely used fourth-generation language (4GL) in commercial
    use today.
  • SQL is the only language for interacting with the RDBMS. Any other
    programming language must use embedded SQL calls to interact with the
    RDBMS.
  • The constantly changing nature of databases makes them a tricky place
    to test software. If a SQL script is written and tested successfully today, it’s
    entirely possible that it may break down and produce erroneous information
    later on. The solution is that the script must not only be tested, but must
    originally be designed and written by a capable SQL developer who understands
    proper database design and is thoroughly versed in the RDBMS and
    SQL syntax.

Leave a Reply

Your email address will not be published. Required fields are marked *