Database System Concepts
Database System Concepts
7th Edition
ISBN: 9780078022159
Author: Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher: McGraw-Hill Education
Bartleby Related Questions Icon

Related questions

Question
100%

Based on the stage 2, write queries for the following questions: Sample output are provided for some queries.

 

  1. Write a query to display all vendors sorted by vendor name.

 

  1. Write a query to display the product id, description, type, base, category, and price for all products that have a product base of water and a product category of sealer.

 

  1. Write a query to display the first name, last name, and email address of employees who were not hired from January 1, 2015, to December 31, 2019. Sort the output by last name and then by first name. 

 

  1. Write a query to display the first name, last name, phone number, title, and department number of employees who work in department 123 and have the title “Assistant.” 

 

  1. Write a query to display the employee number, last name, first name, salary “from” date, salary end date, and salary amount for employees 99675, 53845, and 44035. Sort the output by employee number and salary “from” date.

 

  1. Write a query to display the first name, last name, street no, street name, city, state, and zip code of any customer who purchased a Forest brand between July 15, 2015, and Jul 20, 2015. If a customer purchased more than one such product, display the customer’s information only once in the output. 

 

  1. Write a query to display the employee number, last name, email address, title, and department name of each employee whose job title does not end in the word ”Assistant".

 

CUSTOMER
PK CUS_CODE
CuS FNAME
cus LNAME
CUS STREET NO
CUS STREET NAME
CUs CITY
CUS STATE
CUs ZIP
CUS_BALANCE
PRODUCT
Placse
PK PRODUCT ID
PRODUCT DESCRIPTION
PROD TYPE
INVOICE
PK INV NUM
PROD_BASE
BRAND
SALES
PROD CATEGORY
PK BRAND ID
CUS CODE
PK INV NUM
PROD PRICE
BRAND NAME
INV DATE
generated
+ FK PROD_ID
Has
PROD QTY ONHAND
INV_TOTAL
BRAND TYPE
BRAND ID
Has-
EMPLOYEE ID
BRAND NAME
BRAND TYPE
Completes
Has
EMPLOYEE
PK EMP NUM
INVENTORY
EMP_FNAME
Рк PRODUCT D
EMP LNAME
FK VEND_ID
EMP EMAIL
EMP_PHONE
EMP HIREDATE
EMP_TITLE
EMP COMISSION
DEPT NUM
Contains
DEPT NAME
Belonga
VENDOR
PK VEND ID
DEPARTMENT
PK DEPT_NUM
VEND NAME
DEPT NAME
VEND STREET_NO
VEND STREET NAME
VEND_CITY
VEND STATE
expand button
Transcribed Image Text:CUSTOMER PK CUS_CODE CuS FNAME cus LNAME CUS STREET NO CUS STREET NAME CUs CITY CUS STATE CUs ZIP CUS_BALANCE PRODUCT Placse PK PRODUCT ID PRODUCT DESCRIPTION PROD TYPE INVOICE PK INV NUM PROD_BASE BRAND SALES PROD CATEGORY PK BRAND ID CUS CODE PK INV NUM PROD PRICE BRAND NAME INV DATE generated + FK PROD_ID Has PROD QTY ONHAND INV_TOTAL BRAND TYPE BRAND ID Has- EMPLOYEE ID BRAND NAME BRAND TYPE Completes Has EMPLOYEE PK EMP NUM INVENTORY EMP_FNAME Рк PRODUCT D EMP LNAME FK VEND_ID EMP EMAIL EMP_PHONE EMP HIREDATE EMP_TITLE EMP COMISSION DEPT NUM Contains DEPT NAME Belonga VENDOR PK VEND ID DEPARTMENT PK DEPT_NUM VEND NAME DEPT NAME VEND STREET_NO VEND STREET NAME VEND_CITY VEND STATE
Expert Solution
Check Mark
Still need help?
Follow-up Questions
Read through expert solutions to related follow-up questions below.
Follow-up Question
  1. Write a query to display the employee number, last name, email address, title, and department name of each employee whose job title does not end in the word ”Assistant".
Solution
Bartleby Expert
by Bartleby Expert
SEE SOLUTION
Follow-up Questions
Read through expert solutions to related follow-up questions below.
Follow-up Question
  1. Write a query to display the employee number, last name, email address, title, and department name of each employee whose job title does not end in the word ”Assistant".
Solution
Bartleby Expert
by Bartleby Expert
SEE SOLUTION
Knowledge Booster
Background pattern image
Similar questions
SEE MORE QUESTIONS
Recommended textbooks for you
Text book image
Database System Concepts
Computer Science
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:McGraw-Hill Education
Text book image
Starting Out with Python (4th Edition)
Computer Science
ISBN:9780134444321
Author:Tony Gaddis
Publisher:PEARSON
Text book image
Digital Fundamentals (11th Edition)
Computer Science
ISBN:9780132737968
Author:Thomas L. Floyd
Publisher:PEARSON
Text book image
C How to Program (8th Edition)
Computer Science
ISBN:9780133976892
Author:Paul J. Deitel, Harvey Deitel
Publisher:PEARSON
Text book image
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781337627900
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning
Text book image
Programmable Logic Controllers
Computer Science
ISBN:9780073373843
Author:Frank D. Petruzella
Publisher:McGraw-Hill Education