Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

AT&T LTE 87% 6:31 PM Touch to return to call 09:37 Back Assignment 01.docx CGS2545 Abdelrazek 1 Assignment #1 1. Display a list of all

image text in transcribed
AT&T LTE 87% 6:31 PM Touch to return to call 09:37 Back Assignment 01.docx CGS2545 Abdelrazek 1 Assignment #1 1. Display a list of all data contained in the BOOKS table. Answer 2 List the title only of all books available in inventory, using the BOOKS table Answer List the title and publication date for each book in the BOOKS table. Use the column heading "Publication Date" for the Pubdate field Answer: 4 List the customer number for each customer in the CUSTOMERS table, along with the city and state in which the customer lives. Answer: s. Create a list containing the publisher's name, the person usually contacted, and the publisher's telephone number. Rename the contact column "Contact Person" in the displayed results. (Hint: Use the PUBLISHERS table.) Answer: 6Determine which categories are represented in the current book inventory. List cach category only once. Answer: 7. List the customer number from the ORDERS table for each customer who has placed an order with the bookstore. List each customer number only once. Answer: s Create a list of each book title stored in the BOOKS table and the category in which each book belongs. Reverse the sequence of the columns so that the category of each book is listed first. Answer: Dashboard Calendar To Do Notifications Inbox

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Programming The Perl DBI Database Programming With Perl

Authors: Tim Bunce, Alligator Descartes

1st Edition

1565926994, 978-1565926998

Students also viewed these Databases questions

Question

d. How were you expected to contribute to family life?

Answered: 1 week ago