Question: Create a view that lists the name and phone number of the contact person at each publisher. Dont include the publishers ID in the view.

Create a view that lists the name and phone number of the contact person at each publisher. Don’t include the publisher’s ID in the view. Name the view CONTACT.

Step by Step Solution

★★★★★

3.46 Rating (172 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

CREATE VIEW ... View full answer

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Document Format (2 attachments)

1803_60b8c1212b3ce_716747.pdf

180 KBs PDF File

1803_60b8c1212b3ce_716747.docx

120 KBs Word File

Students Have Also Explored These Related Oracle 12c SQL Questions!

Create a view that lists the ISBN and title for each book in inventory along with the name and phone number of the person to contact if the book needs to be reordered. Name the view REORDERINFO.

Create a list that displays the title of each book and the name and phone number of the contact at the publishers office for reordering each book.

The City Jail Technologies Department is constructing an application to allow users in the Crime Analysis Unit to query data more easily. This system requires creating a number of views, described in...

Database SQL To perform the following assignments, refer to the tables in the JustLee Books database. Create a view that lists the name and phone number of the contact person at each publisher. Don't...

JustLee Books Database DROP TABLE CUSTOMERS CASCADE CONSTRAINTS; DROP TABLE ORDERS CASCADE CONSTRAINTS; DROP TABLE PUBLISHER CASCADE CONSTRAINTS; DROP TABLE AUTHOR CASCADE CONSTRAINTS; DROP TABLE...

**My answers (listed below) need modification per the below instruction** INSTRUCTIONS: 1) For #1 add another statement to display all the columns for all the rows in the view (SELECT * ....). 2) Add...

1. Create a view that lists the name and phone number of the contact person at each publisher. Don't include the publisher's ID in the view. Name the view CONTACT 2. Change the CONTACT view so that...

1. What happens to the data displayed by a view if the view is deleted? The following tables form a Library database held in an RDBMS: Borrower (card_no , last_name, first_name , address, city ,...

Lab 1 3 To perform the following assignments, refer to the tables in the JustLee Books database. Create a view that lists the name and phone number of the contact person at each publisher. Don't...

Database SQL Hands-on Assignments To perform the following assignments, refer to the tables in the JustLee Books database. 1. Create a view that lists the name and phone number of the contact person...

3. Find the following: a. Mean b. Median c. Mode d. Standard Deviation

The famous essayist and poet Ralph Waldo Emerson once said, What you do speaks so loud that I cannot hear what you say. What does this mean, and how does it apply to communication in small firms?

What happens if US interest rates rise in a fixed - fixed currency swap? Group of answer choices The value of the swap increases for both parties The swap becomes more valuable to the party receiving...

4 What does "the looking-glass self" mean?

A multicast router is connected to four networks. The interest of each network is shown below. What is the group list that should be advertised by the router? a. N1: {G1, G2, G3} b. N2: {G1, G3} c....

A router using DVMRP receives a packet with source address 10.14.17.2 from interface 2. If the router forwards the packet, what are the contents of the entry related to this address in the unicast...

It is obvious that we need to have spanning trees for both unicasting and multicasting. How many leaves of the tree are involved in a transmission in each case? a. A unicast transmission b. A...

the internal Revenue Service reports that the federal government income tax paid in 2010 was 8040. assume standard deviation is 4800. the urs plans to draw 1000 samples. I NEED STEPS NOT SURE HOW TO...

QUESTION 5 Correct Answer. 2 Marks As part of the performance andlysis, the software development team wants to compare the time token to switch befween user mode ond kernel mode with the time taken...

One of the points of discussion between management and its consultants is the choice of the discount rate for this capital budgeting exercise. It was finally decided that the discount rate would be...