A Guide to SQL
A Guide to SQL
9th Edition
ISBN: 9781111527273
Author: Philip J. Pratt
Publisher: Course Technology Ptr
bartleby

Concept explainers

Question
Chapter 3, Problem 1RQ
Program Plan Intro

SQL:

  • SQL stands for “Structured Query Language”.
  • The current version of SQL is “ANSI SQL – 92”.
  • SQL is not a programming language. It is text-based and it is also called as data sublanguage.
    • In order to get SQL as a complete programming language, it should be included in scripting languages like Java, C#, and so on.
  • It contains constructs which are used to define and process database. They are executed using DBMS-supplied command prompt.
  • Some of the DBMS products that provides GUI tools in order to perform tasks are as follows:
    • SQL Server
    • Oracle Database
    • MySQL

Data Definition Language (DDL):

It is used for creating tables and other structures. They perform operations like creating tables, modifying database, and removing database.

Expert Solution & Answer
Check Mark

Explanation of Solution

Table Creation:

Creating table comes under Data Definition Language (DDL).

  • The “CREATE TABLE” command is used to create a table by specifying the table name and then by listing the column in a single set of parentheses in the table.
  • The “CREATE” command is employed for establishing databases on our platform by constructing tables in an already existing database.

The Syntax for creating table is as follows:

CREATE TABLE TABLE_NAME (

  Column1 datatype,

  Column2 datatype,

);

Creating table “EMP”:

CREATE TABLE EMP (

EMP_NUM     CHAR(3)

EMP_LNAME      VARCHAR(15)

EMP_FNAME      VARCHAR(15)));

Explanation:

 The above query is used to create a table structure named “EMP” . The attribute “EMP_NUM” is declared as “CHAR” and the attributes “EMP_LNAME” and “EMP_FNAME” is declared as “VARCHAR”.

Want to see more full solutions like this?

Subscribe now to access step-by-step solutions to millions of textbook problems written by subject matter experts!
Knowledge Booster
Computer Science
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Recommended textbooks for you
  • A Guide to SQL
    Computer Science
    ISBN:9781111527273
    Author:Philip J. Pratt
    Publisher:Course Technology Ptr
    CMPTR
    Computer Science
    ISBN:9781337681872
    Author:PINARD
    Publisher:Cengage
    Oracle 12c: SQL
    Computer Science
    ISBN:9781305251038
    Author:Joan Casteel
    Publisher:Cengage Learning
  • Database Systems: Design, Implementation, & Manag...
    Computer Science
    ISBN:9781285196145
    Author:Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
    Publisher:Cengage Learning
    Database Systems: Design, Implementation, & Manag...
    Computer Science
    ISBN:9781305627482
    Author:Carlos Coronel, Steven Morris
    Publisher:Cengage Learning
  • A Guide to SQL
    Computer Science
    ISBN:9781111527273
    Author:Philip J. Pratt
    Publisher:Course Technology Ptr
    CMPTR
    Computer Science
    ISBN:9781337681872
    Author:PINARD
    Publisher:Cengage
    Oracle 12c: SQL
    Computer Science
    ISBN:9781305251038
    Author:Joan Casteel
    Publisher:Cengage Learning
    Database Systems: Design, Implementation, & Manag...
    Computer Science
    ISBN:9781285196145
    Author:Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
    Publisher:Cengage Learning
    Database Systems: Design, Implementation, & Manag...
    Computer Science
    ISBN:9781305627482
    Author:Carlos Coronel, Steven Morris
    Publisher:Cengage Learning