Display customer number, customer name, and location for customers whose Customer_name starts with letter C. Sort the result based on customer number.

Database System Concepts
7th Edition
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Chapter1: Introduction
Section: Chapter Questions
Problem 1PE
icon
Related questions
icon
Concept explainers
Question

question 15

please use the picture below to answer the following question

Display customer number, customer name, and location for customers whose Customer_name starts with letter C. Sort the result based on customer number.

Employee
Customer
Invoice
PK EmployeelD
PK Customer_Number
Customer Name
PK Invoice_Number
Invoice_Date
FK Customer_Number
Emp_FName
Emp_LName
soc_Ins
FK Position_ID
FK Supervisor_ID
Location
FK Rep_ID
Invoice_Detail
Position
PK,
HireDate
Invoice_Number
FK1
PK Position_ID
PI,
Position
Prod_ID
FK2
Quantity
Title
Price
PK
Title_ID
Title
Author
Author_Product
Product
PK Author_ID
PK,
PK
Product_ID
Author_ID
FK1
Author_FName
FK
Title_ID
Edition
Author LName
PK,
Prod_ID
FK2
FK
Edition_ID
PK Edition_ID
Purchase_Cost
Edition
Retail_Price
Transcribed Image Text:Employee Customer Invoice PK EmployeelD PK Customer_Number Customer Name PK Invoice_Number Invoice_Date FK Customer_Number Emp_FName Emp_LName soc_Ins FK Position_ID FK Supervisor_ID Location FK Rep_ID Invoice_Detail Position PK, HireDate Invoice_Number FK1 PK Position_ID PI, Position Prod_ID FK2 Quantity Title Price PK Title_ID Title Author Author_Product Product PK Author_ID PK, PK Product_ID Author_ID FK1 Author_FName FK Title_ID Edition Author LName PK, Prod_ID FK2 FK Edition_ID PK Edition_ID Purchase_Cost Edition Retail_Price
Invoice table
Column
DEFAULT
PK
NOT NULL UNIQUE
FK
VALIDATION
Column Names
DataTypes
VALUE
InvoiceNum
|Integer
InvoiceDate
Date
CustomerNum
Integer
Invoice_Detail
Column
DEFAULT
table Column
PK
NOT NULL UNIQUE
FK
VALIDATION
DataTypes
VALUE
Names
Invoice_number |Integer
Prod_ID
Quantity
Integer
Integer
Value must
price
Decimal(3,0)
be >0
Transcribed Image Text:Invoice table Column DEFAULT PK NOT NULL UNIQUE FK VALIDATION Column Names DataTypes VALUE InvoiceNum |Integer InvoiceDate Date CustomerNum Integer Invoice_Detail Column DEFAULT table Column PK NOT NULL UNIQUE FK VALIDATION DataTypes VALUE Names Invoice_number |Integer Prod_ID Quantity Integer Integer Value must price Decimal(3,0) be >0
Expert Solution
steps

Step by step

Solved in 2 steps

Blurred answer
Knowledge Booster
Query Syntax
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
Database System Concepts
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education