A-Create a VIEW with the name BOOK_VC that includes only book titles (BK_TITLE)

Question

A-Create a VIEW with the name BOOK_VC that includes only book titles (BK_TITLE) for books whose list price is more than $233.

B- Create a VIEW with the name PUBLISHER_VC that includes name, zip code and phone number of publishers who has never published a book whose list price is less than $100.

C- Create a VIEW with the name AUTHOR_VC that includes name of each author born after August 11, 1934.

D- Grant UPDATE permission on the PB_NAME & PB_ZIPCODE columns of the PUBLISHER_VC view to the user FHIO such that PB_PHONE_NUMBER = 6544 .

Explanation / Answer

Hi,

Before answering the question, I need to go with below assumptions as it is not mentioned in the question-

Assumption- Lets assume that you table structure looks like below-

Books(Book_id,BK_TITLE,author_id,publisher_id,BK_LIST_PRICE)

publisher(publisher_id,,publisher_name,zip,phone)

Author(Author_id,author_name,DOB)

Books(Book_id,BK_TITLE,author_id,publisher_id,BK_LIST_PRICE)

publisher(publisher_id,,publisher_name,zip,PB_PHONE_NUMBER)

Author(Author_id,author_name,DOB)

Ans A)
create view BOOK_VC as select BK_TITLE from Books where BK_LIST_PRICE>233;

Ans B)
create view PUBLISHER_VC as select publisher_name,zip,PB_PHONE_NUMBER from publisher p join Books b
on p.publisher_id=b.publisher_id
and b.BK_LIST_PRICE>=100;

Ans C)
create view AUTHOR_VC as select author_name from Author where DOB>'1934-08-11';

Ans D)
grant REFERENCES (PB_PHONE_NUMBER='6544') , update ( PB_NAME & PB_ZIPCODE) on PUBLISHER_VC to FHIO

Related Questions

Navigate

• Browse (All)
• Browse A
• Subjects

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