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

Concept explainers

Question
Book Icon
Chapter 3, Problem 10RQ
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 provide GUI tools in order to perform tasks are as follows:
    • SQL Server
    • Oracle Database
    • MySQL

Data Manipulation Language (DML):

This is used for manipulation like querying, insertion, updating, and deletion of data.

Blurred answer
Students have asked these similar questions
Given the dependency diagram of attributes C1,C2,C3,C4,C5 in a table shown in the following figure, the primary key attributes are underlined   Make a database with multiple tables from attributes as shown above that are in 3NF, showing PK, non-key attributes, and FK for each table? Assume the tables are already in 1NF. Hint: 3 tables will result after deducing 1NF -> 2NF -> 3NF
Consider the ER diagram of online sales system above. Based on the diagram answer the questions below, 1.  Based on the ER Diagram, determine the Foreign Key in the Product Table. Just mention the name of the attribute that could be the Foreign Key 2.  Is there a direct relationship that exists between Store and Customer entities? AnswerYes/No?
Consider the ER diagram of online sales system above. Based on the diagram answer thequestions below,   1.  Mention the relationship between the Order and Customer Entities. You can use the following:  1:1, 1:M, M:1, 0:1, 1:0, M:0, 0:M 2.  Which one of the 4 Entities mention in the diagram can have a recursive relationship? 3.  If a new entity Order_Details is introduced, will it be a strong entity or weak entity? If it is a weak entity, then mention its type (ID or Non-ID, also Justify why)?   NO AI use pencil and paper
Knowledge Booster
Background pattern image
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.
Similar questions
SEE MORE QUESTIONS
Recommended textbooks for you
Text book image
A Guide to SQL
Computer Science
ISBN:9781111527273
Author:Philip J. Pratt
Publisher:Course Technology Ptr
Text book image
Oracle 12c: SQL
Computer Science
ISBN:9781305251038
Author:Joan Casteel
Publisher:Cengage Learning
Text book image
Programming with Microsoft Visual Basic 2017
Computer Science
ISBN:9781337102124
Author:Diane Zak
Publisher:Cengage Learning
Text book image
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
Text book image
CMPTR
Computer Science
ISBN:9781337681872
Author:PINARD
Publisher:Cengage
Text book image
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781305627482
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning