SE Assignment 3- Part B: Steps required to accomplish Part A

Steps required to accomplish Part A:

I) Go to http://db.zoho.com/

II) Creating two database tables-

a) Sign in to http://db.zoho.com/

b) On the create database page select one of the four options indicated. For example- select import .XLS, .CSV option.

c) In the create database (import) window that appears (step 1 of 2), enter the database name and description. Select the data location option i.e. pasted data or local drive. For example- select pasted data option and copy the prepared excelsheet database in the blank space provided. Select Next.

d) 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.

III) Creating three select queries:

a) Locate the New option in the top left corner of the page and in the drop down box click the New Query Table option.

b) A new query table creation option would appear next. Enter the select comand that you require, in the space provided and click execute. The query table would get created.

c) Repeat the procedure for the other two query tables.

d) 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.

e) Paste the URL in the post in your blog after making the necessary changes to the size of the table.

f) Publish the post.