Hands-On AssignmentsTo determine the exact name of Felds used in the tables for

Question

Hands-On AssignmentsTo determine the exact name of Felds used in the tables for these exercises, refer to the tablesin the JustLee Books database, or use the DESCRIBE tablename command to view the table’sstructure.1.Display a list of all data contained in the BOOKS table.Select *±rom books;2.List the title only of all books available in inventory, using the BOOKS table.Select title±rom books;3. List the title and publication date for each book in the BOOKS table. Use the columnheading “Publication Date” for the Pubdate Feld.Select title, pubdate as “Publication Date”±rom books;4. List the customer number for each customer in the CUSTOMERS table, along with the cityand state in which the customer lives.Select customer #, city, state±rom customers;5. Create a list containing the publisher’s name, the person usually contacted, and thepublisher’s telephone number. Rename the contact column “Contact Person” in thedisplayed results. (Hint: Use the PUBLISHER table.)

Explanation / Answer

Answeres for all queries in sequence

1. Select * from books.

2. SELECT TITLE FROM BOOKS;

3. SELECT TILTLE, PUBDATE AS "Publication Date" FROM BOOKS;

4. Select customer#, city, state from customers ;

5.  

publisher table desciption:

CREATE TABLE Publisher
(PubID NUMBER(2),
Name VARCHAR2(23),
Contact VARCHAR2(15),
Phone VARCHAR2(12),
CONSTRAINT publisher_pubid_pk PRIMARY KEY(pubid));

Query to be used : SELECT NAME , CONTACT AS "Contact Person" , PHONE FROM PUBLISHER;

Related Questions

Navigate

• Browse (All)
• Browse H
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.