Database Application Systems Books Glore Eastshore from the BRANCH Table - IT Assignment Help

Assignment Task

PART A
1. Create a new table STORE that has the all the columns from the BRANCH table withthe same datatype as in the BRANCH table.
2. Create a new table PUBLISHER2 with the data as in PUBLISHER table and do notinclude column PUBLISHER_CITY in the new table.
3. Retrieve data from the table PUBLISHER2.
4. List the BOOK_TITLE, BOOK_PRICE, DATE from the BOOK Table who werepublished after 1st January 2013 in the descending order of their published date.
5. Retrieve all the data from the wrote table.
6. Retrieve all the data from the BOOK table sorted in the alphabetical order on
BOOK_TITLE.
7. Retrieve the BRANCH_LOCATION and NO_EMPLOYEES for BooksGlore Eastshorefrom the BRANCH table.
8. What are details of the first author when the AUTHOR table is sorted on LAST_NAMEin the Descending order.
9. List the book code and title of every book that are of type of FIC, MYS or ART.
10. Retrieve the price of the book ‘Smokescreen

This IT Assignment has been solved by our IT Experts at My Uni Paper. Our Assignment Writing Experts are efficient to provide a fresh solution to this question. We are serving more than 10000+Students in Australia, UK & US by helping them to score HD in their academics. Our Experts are well trained to follow all marking rubrics & referencing style.

Be it a used or new solution, the quality of the work submitted by our assignment Experts remains unhampered. You may continue to expect the same or even better quality with the used and new assignment solution files respectively. There’s one thing to be noticed that you could choose one between the two and acquire an HD either way. You could choose a new assignment solution file to get yourself an exclusive, plagiarism (with free Turnitin file), expert quality assignment or order an old solution file that was considered worthy of the highest distinction.