List the book code and book title of each book


Asked by wiki @ in Computers and Technology viewed by 118 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 wiki @


Answer:

..

Explanation:

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

Do you know the better answer?

Latest questions in Computers And Technology

Should the title of a book be in quotation marks

Asked by wiki @ in English viewed by 127 persons


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

Somebody hit me.

Asked by solange_darlhene @ in World Languages viewed by 36 persons

What is the main idea and supporting ideas of the text?

Asked by leidy214 @ in Biología viewed by 115 persons


Más de la mitad de la población mundial se concentra en las ciudades y esta concentración se convierte en una amenaza. El acelerado desarrollo urbano genera una serie de problemas, …

Main idea secondary ideas

Asked by leidy214 @ in Biología viewed by 54 persons


Más de la mitad de la población mundial se concentra en las ciudades y esta concentración se convierte en una amenaza. El acelerado desarrollo urbano genera una serie de problemas, …

Idea principal ideas secundarias

Asked by leidy214 @ in Biología viewed by 37 persons


Más de la mitad de la población mundial se concentra en las ciudades y esta concentración se convierte en una amenaza. El acelerado desarrollo urbano genera una serie de problemas, …

Coffee is grown on the island of java

Asked by loringd9 @ in Inglés viewed by 53 persons

Ideas principales

Asked by angela775 @ in Ciencias Sociales viewed by 55 persons


Pero arreciaba la violencia de la lucha política, cada vez más organizada desde arriba pero también con cada vez mayor variedad de participantes espontáneos desde abajo. Gamonales de pueblo, terratenientes, …

Any fans are there in this not foundation

Asked by gabriela298 @ in English viewed by 70 persons

Are the weekend? on busy you​

Asked by sam2502T @ in Inglés viewed by 168 persons

Some/ for / bedroom. / we / need / curtains / the

Asked by luis_enrique2 @ in English viewed by 174 persons

Convertir a voz pasiva

Asked by angeles_tatiana @ in English viewed by 409 persons


John cleans the car.

They can determine means of production.

Asked by michelle_noemi @ in Inglés viewed by 130 persons

Minda ate all of the icecream

Asked by montoya_paiva_arihan @ in English viewed by 117 persons


minda ate all of the icecream

Most viewed questions in Computers And Technology


Which of the following is a valid c++ array definition

Asked by wiki @ in Computers and Technology viewed by 433 persons

Which of the following is a valid C++ array definition? A. int array[0]; B. float $payments[10]; C. void numbers[5]; D. …

Which of the following is not a method for authentication

Asked by wiki @ in Computers and Technology viewed by 430 persons

Which of the following are NOT used for user authentication? A. what the user has B. what the user knows …

How do we measure the frequency of a sound wave

Asked by wiki @ in Computers and Technology viewed by 388 persons

What two units are used to measure the frequency and amplitude of a sound wave? A. Hertz is a measure …


C program to count number of words in a file

Asked by wiki @ in Computers and Technology viewed by 364 persons

Write a c program to count the total number of commented characters and words in a c file taking both …

Which of the following is not a data mining functionality

Asked by wiki @ in Computers and Technology viewed by 363 persons

Define each of the following data mining functionalities: characterization, discrimination, association and correlation analysis, classification, prediction, clustering, and evolution analysis. …

Square root of a number by newton's method in python

Asked by wiki @ in Computers and Technology viewed by 361 persons

Convert Newton’s method for approximating square roots in Project 1 to a recursive function named newton. (Hint: The estimate of …


How to get access to advanced server in mobile legends

Asked by wiki @ in Computers and Technology viewed by 336 persons

How do you get access To The advance server in Mobile legends

An advantage of electronic data interchange edi is that it

Asked by wiki @ in Computers and Technology viewed by 325 persons

The advantages of electronic data interchange are no longer limited to large companies, because even small firms can exchange and …

Which of the following statements is true about learning disability

Asked by wiki @ in Computers and Technology viewed by 321 persons

Which of the following statements are true regarding cognitive impairments? Select 3 options. To improve cognitive accessibility, the developer should …


Which of the following software programs provides for email communication

Asked by wiki @ in Computers and Technology viewed by 316 persons

Which of the following software programs provides for e-mail communication?. A. Access. B. Word Perfect. C. Outlook. D. Excel

How to know if someone read your message on android

Asked by wiki @ in Computers and Technology viewed by 260 persons

How to know if someone read your message android?

Which of the following is recommended to avoid malware infections

Asked by wiki @ in Computers and Technology viewed by 256 persons

Which of the following statements about malware protection are accurate? Select 3 options. Firewalls and anti-malware should be used together …


How do you make a division sign on a computer

Asked by wiki @ in Computers and Technology viewed by 253 persons

How do I make a division sign with my Chromebook keyboard?

Checking a credit report is a good way to brainly

Asked by wiki @ in Computers and Technology viewed by 246 persons

If your credit reports show different scores, what should you do for everfi

What are some the benefits of the agile development methodology

Asked by wiki @ in Computers and Technology viewed by 246 persons

What are some benefits of the Agile development methodology? a)It allows people to contribute to more than one part of …