List the book code and book title of each book


Asked by admin @ in Computers and Technology viewed by 382 People


1. Create a view named PenguinBooks. It consists of the book code, book title, book type, and book price for every book published by Penguin USA. Display the data in the view.

2. Create a view named Paperback. It consists of the book code, book title, publisher name, branch number, copy number, and price for every book copy that is available in paperback. Display the data in the view.
3. Create a view named BookAuthor. It consists of the book code, book title, book type, author number, first name, last name, and sequence number for each book. Display the data in the view.
4. Create the following indexes. If it is necessary to name the index in your DBMS, use the indicated name.
a. Create an index named BookIndex1 on the PublisherName field in the Publisher table.
b. Create an index named BookIndex2 on the Type field in the Book table.
c. Create an index named BookIndex3 on the BookCode and Type fields in the Book table and list the book codes in descending order.
5. Drop the BookIndex3 index.
6. Specify the integrity constraint that the price of any book must be less than $90.
7. Ensure that the following are foreign keys (that is, specify referential integrity) within the Henry Books database.
a. PublisherCode is a foreign key in the Book table.
b. BranchNum is a foreign key in the Inventory table.
c. AuthorNum is a foreign key in the Wrote table.
8. Add to the Book table a new character field named Classic that is one character in length.
9. Change the Classic field in the Book table to Y for the book titled The Grapes of Wrath.
10. Change the length of the Title field in the Book table to 60.
11. What command would you use to delete the Books table from the Henry Books database? (Do not delete the Book table.)
12. Write a stored procedure that will change the price of a book with a given book code and quality. How would you use this stored procedure to change the price of any copy of book 1351 whose quality is excellent to $22.95?

Answered by admin @



Answer:

..

Explanation:

I don't really now. I am just answer for the sake of getting points lol


Similar Questions

List four reasons why paul wrote the book of romans

Asked by maham237 @ in History viewed by 272 persons

Should the title of a book be in quotation marks

Asked by admin @ in English viewed by 254 persons

Titles of books should be written in A. quotation marks. B. large font. C. bold. D. italics.

Give the title of the book written by rousseau

Asked by admin @ in History viewed by 340 persons

Give the titles of the books written by rousseau and charles montasquieu

List 3 characteristics of the ideal encryption scheme code org

Asked by maham237 @ in Computers And Technology viewed by 350 persons

Which one of the following book titles is capitalized correctly

Asked by admin @ in English viewed by 345 persons

Which one of the following book titles is capitalized correctly?A. Harry Potter and the Sorcerer's Stone b. the Hunger Games c. The Fault In our Stars d. Bridge To Terabithia

You would use italics to punctuate the title of a(n) book poem article speech

Asked by maham237 @ in English viewed by 332 persons

N 1776, an economics book titled was published to promote the concept of free enterprise.

Asked by maham237 @ in History viewed by 422 persons

In 1776, an economics book titled .............. was published to promote the concept of free enterprise.The Wealth of Nations The World of Economy The Success of Nations The Economics Systems

Overcoming fixed mindset: a step-by-step guide to cultivating a growth mindset

Asked by wiki @ in Health viewed by 1081 persons

Which of the following would best complete this list?

Asked by wiki @ in Social Studies viewed by 617 persons

What had the king decided to do before he saw the spider

Asked by vanshika149 @ in English viewed by 960 persons

Describe the karez in your own words

Asked by rajesh064 @ in English viewed by 1087 persons

What is 8 + (x + 5)?

Asked by jaylord7 @ in Mathematics viewed by 936 persons

What is the topic of the info grapher

Asked by jesus643 @ in History viewed by 1179 persons

Elephant kills 11 in nepal , woman rescued from a friendly dolphine

Asked by kavin044 @ in English viewed by 1093 persons

Most viewed questions in Computers And Technology


A customer wants to increase the storage capacity by 25gb

Asked by admin @ in Computers and Technology viewed by 4402 persons




Solid yellow line bordering your lane of traffic marks a

Asked by admin @ in Computers and Technology viewed by 583 persons



Which of the following is not a windows utility program

Asked by admin @ in Computers and Technology viewed by 570 persons


Which operation on a pwc requires more than idle speed

Asked by admin @ in Computers and Technology viewed by 553 persons


When is a wrecker considered to be an emergency vehicle

Asked by admin @ in Computers and Technology viewed by 549 persons



Which of the following statements is true of a database

Asked by admin @ in Computers and Technology viewed by 532 persons


Which of the following is not true about an entrepreneur

Asked by admin @ in Computers and Technology viewed by 516 persons


Kitchen gadgets draw a context diagram for the order system

Asked by admin @ in Computers and Technology viewed by 486 persons