SE Assignment Part B : steps for Part A reports

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

B) Create two database table

• go to http://db.zoho.com/
• create an account
• sign In
• go to create database, there will be four options select any one of them for example - click on Import.XLS,.CSV...
• Then window will pop up write database name, description and select the database location i.e pasted data or local drive then copy the data from excel already present in the system and paste in the space available in the window
• then click on next and then create
• database will be created
• repeat the procedure to create other databases

C) Creating the three select queries

• Click on the drop down menu of New and select New Query
• Enter the query in the space provided and click on the option execute.
• Query table will be created
• Repeat the procedure for the different queries
  
• Then save the query tables
• Click on the view mode
• then click on publish, and select the option of embedding on the website.
• Then select the URL from the window that appears
• Paste the URL in the post in your blog
  
• publish the post.

D) The three queries run to generate the three reports are

• Report 1:

SELECT DISTINCT "SellerID", "OwnerLastName","OwnerFirstName"From "Antiques","Antique owners"
where "SellerID"="OwnerID" ORDER BY "OwnerLastName","OwnerFirstName";

• Report 2
  

Select "Antique owners"."OwnerLastName","Antiques".Item From "Antique owners", "Antiques" where "Antique owners"."OwnerID"="Antiques"."SellerID"

• Report 3

SELECT DISTINCT "SellerID", "OwnerLastName","OwnerFirstName","ItemDesired" From "Antiques","Antique owners"Where "SellerID" = "OwnerID" ORDER BY "OwnerLastName","OwnerFirstName";