Assignment 3 part A& B

Steps to create Online Database:
1. The first step would be to create a Zoho Id. If you are an existing gmail id holder then you only have to login with the id.
2. The home page of zoho will give four options.
* Import excel file, create database, create database templets and enter data right away.
3. Data is imported from an Excel file in this case. You can take the table from the excel file and paste it in the window and name it.
4. You can paste the data into the Zoho page and click create.
5. If you have to get the required output from the tables you need to ask queries. For that click on the link ‘NEW’ and select ‘New Query Table’ option. Write the required query in the appeared window and ask to execute.
6. Now the query asked in the given case was to get employee id, full name, salary and rank whose first name starts with the letter ‘A’ or whose Department Is In ‘Kolkata’.
SELECT “Employee_id”, “Last name”,”First name”,”Salary”,”Rank” from “EMPLOYEES DATABASE” where “First name” like ‘A%’ or “Department”=’Kolkata’
7. For the next query would be to click on the link new and the query would be to get Employee id, full name, rank, and salary, of EMPLOYEES who are from ‘Kolkata’. In this query data of 2 tables is joined by asking for the percentages as well.
SELECT “EMPLOYEES_id”, “Last name”, “First name”,”Address”,”Percentage” FROM “EMPLOYEES DETAILS”,” EMPLOYEES RANK” where “Salary”=’Kolkata’ and “EMPLOYEES DETAILS”.”EMPLOYEES_id”=” EMPLOYEES RANK”.” Employees _id”
8.To get employee id, full name, rank, salary and department in which city, where employees have salary more than 2000
SELECT “Employees_id”, “First name”,”Last name”,”RANK” FROM “EMPLOYEES DATABASE”,”SALARY” where “Salary”> ‘2000′ and “EMPLOYEES DATABASE”.”Employees_id”=”Employees Salary”.”Employees_id”
9.If you would want to publish this into your won blog, then you have to go to the extreme left option ‘publish’ in that click on “embed in blog” click on that option and copy- paste the provided url onto your new blog post and publish your post. Your database has been published onto the net.In case you have to update you can update your database, it will be automatically updated online.

Sir, I am posting the link to the worksheet here.

http://sheet.zoho.com/home.do