Explore BrainMass
Share

Explore BrainMass

    SQL Characteristics, History, and Example

    This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

    SQL Information
    --------------------------------------------------------------------------------
    I need about page about basic SQL, I am looking for your opinion.

    a. Characteristics
    b. Why was it created?
    c. Is there anything unique about it?
    d. History
    e. small sample example of code
    f. What makes it different than other languages?

    © BrainMass Inc. brainmass.com October 9, 2019, 5:07 pm ad1c9bdddf
    https://brainmass.com/computer-science/java/sql-characteristics-history-example-48395

    Solution Preview

    SQL (Structured Query Language) is a database language. It is widely used with a DataBase Management System (DBMS) to query, create and modify databases. Originally it was meant to work with Relational Databases, however now it also supports other databases including Object-Relational Database Management Systems (ORDBMS).

    Why created?
    It was created to test a database system based on Edgar Codd's paper on Relational databases "A Relational Model of Data for Large Shared Data Banks" [1]. Its creators Donald D. Chamberlin and Raymond F. Boyce were working at IBM on a relational database system called "System R".

    Characterisitics and uniqueness:
    Every programming language is unique, however SQL is different from other "general" programming languages. The basic SQL does not have the concept of general purpose programming as done in C or Java. Extension to ANSI SQL like PL/SQL provides many improvements that allow general programming with SQL. Some aspects of SQL is closer to any declarative programming language like Prolog, Haskell, Miranda, etc. In any case it ...

    Solution Summary

    In this solution, you will learn all about SQL. Specifically, you will learn about the following with many references.
    a. Characteristics
    b. Why was it created?
    c. Is there anything unique about it?
    d. History
    e. small sample example of code
    f. What makes it different than other languages?

    $2.19