Answer to Question #318412 in Databases | SQL | Oracle | MS Access for prothik ghosh

Question

a) Write SQL commands

1. To create the above table structure with proper constraints.

2. Select all the PROG type published by BPB from Library.

3. Display a list of all books with Price more than 130 and sorted by Qty.

4. Display all the books sorted by Price in Ascending Order.

5. Display a report. Listing Book No. current value and misplacement charges for each book in the above

table. Calculate the misplacement charges for all books Price*1.25

6. Count the number of books published by PHI

7. Insert a new book in the library.

8. Count the no of books in each Type.

9. Add one more attribute “No_of_copies” in the above table.

10. Update the new attribute value with 2 for each book.

11. Count the total number of Publishers.

Answer 1

It's been a while since this question is posted here. Still, the answer hasn't been got. Consider converting this question to a fully qualified assignment, and we will try to assist. Please click the link below to proceed: Submit order