A Guide to SQL
A Guide to SQL
9th Edition
ISBN: 9781337668880
Author: Pratt
Publisher: Cengage
Question
Book Icon
Chapter 2, Problem 3CAT
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.

Entity Relationship Diagram (ERD):

Entity relationship diagram is basically a picture or snapshot about the business system. It means that the information stored and created is represented by this diagram.

  • Entities may represent the physical object, event, or concept.
  • An attribute is a property of an entity.
  • Relationship denotes the link between the entities.
    • If an independent child entity is present in a relationship then it is called a non-identifying relationship.
    • If a dependent child entity is present in a relationship then it is called a non-identifying relationship.

Blurred answer
Students have asked these similar questions
I need help to resolve the case, thank you
In 32-bit MSAM, You were given the following negative array. write a program that converts each array element to its positive representation. Then add all these array elements and assign them to the dl register. .data    myarr sbyte -5, -6, -7, -4.code     ; Write the rest of the program and paste the fully working code in the space below.   the dl register should have the value 22 after summing up all elements in the array.
Microprocessor 8085 Lab Experiment Experiment No. 3 Logical Instructions Write programs with effects 1. B=(2Dh XOR D/2) - (E AND 2Eh+1) when E=53, D=1Dh 2. HL= (BC+HL) XOR DE (use register pair when necessary), when BC=247, HL 516, DE 12Ach 3. Reset bits 1,4,6 of A and set bits 3,5 when A=03BH Write all as table (address line.hexacode,opcede,operant.comment with flags)
Knowledge Booster
Background pattern image
Similar questions
SEE MORE QUESTIONS
Recommended textbooks for you
Text book image
Oracle 12c: SQL
Computer Science
ISBN:9781305251038
Author:Joan Casteel
Publisher:Cengage Learning
Text book image
A Guide to SQL
Computer Science
ISBN:9781111527273
Author:Philip J. Pratt
Publisher:Course Technology Ptr
Text book image
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781305627482
Author:Carlos Coronel, Steven Morris
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
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:9781337508841
Author:Carey
Publisher:Cengage