A Guide to SQL
A Guide to SQL
9th Edition
ISBN: 9781111527273
Author: Philip J. Pratt
Publisher: Course Technology Ptr
Question
100%
Chapter 2, Problem 1TD
Program Plan Intro

Shorthand representation of the relational database structure:

  • The shorthand representation is used to represent the database table in an easier and an understandable way by using primary keys.
  • The step wise process for representing a shorthand representation of a database structure is as follows:
    • First, the Table Name is written down.
    • Using paranthesis, list down all the columns or fields in the table within the paranthesis.
    • From the shorthand representation, data such as primary keys can be identified.
    • In this kind of representation, bold or underline data is used to represent a Primary key.

Blurred answer
Knowledge Booster
Recommended textbooks for you
  • A Guide to SQL
    Computer Science
    ISBN:9781111527273
    Author:Philip J. Pratt
    Publisher:Course Technology Ptr
    Principles of Information Systems (MindTap Course...
    Computer Science
    ISBN:9781305971776
    Author:Ralph Stair, George Reynolds
    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
    Oracle 12c: SQL
    Computer Science
    ISBN:9781305251038
    Author:Joan Casteel
    Publisher:Cengage Learning
    Principles of Information Systems (MindTap Course...
    Computer Science
    ISBN:9781285867168
    Author:Ralph Stair, George Reynolds
    Publisher:Cengage Learning
  • A Guide to SQL
    Computer Science
    ISBN:9781111527273
    Author:Philip J. Pratt
    Publisher:Course Technology Ptr
    Principles of Information Systems (MindTap Course...
    Computer Science
    ISBN:9781305971776
    Author:Ralph Stair, George Reynolds
    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
    Oracle 12c: SQL
    Computer Science
    ISBN:9781305251038
    Author:Joan Casteel
    Publisher:Cengage Learning
    Principles of Information Systems (MindTap Course...
    Computer Science
    ISBN:9781285867168
    Author:Ralph Stair, George Reynolds
    Publisher:Cengage Learning