Part I

Query I – To find out the details of books issued to students

Query II -To find out the details of books published by Wiley

Query III – To find the details of students whose fine is more than 50

Link to the Queries

http://db.zoho.com/ZDBDataSheetView.cc?DBID=23845000000003001&OBJID=23845000000004178

Part – II

Steps required to accomplish Part A:
Go to http://db.zoho.com/
Creating two database tables-
1) Sign in to http://db.zoho.com/
2) On the create database page select one of the four options indicated. For example- select import .XLS, .CSV option.
3)Create the tables you want to create.

4) Select Next.
5) Enter the table name in the window that appears next(step 2 of 3), click create. In the Import Data Details window that appears next, click close. The database table would get created.Repeat the procedure for the second database table.

Queries:

1.) Locate the New option in the top left corner of the page and in the drop down box click the New Query Table option.
2.) A new query table creation option would appear next. Enter the select command that you require, in the space provided and click execute. The query table would get created.
3) Repeat the procedure for the other two query tables.
4) In each of the query table select the embedding option frpm the Publish option on the top of the page. Select the URL from the window that appears.
5) Paste the URL in the post in your blog after making the necessary changes to the size of the table.
6) Publish the post.