Wednesday, February 20, 2008

RETAILIA

This data base is based on a retail store. First, i created a table that contains data of products available, their price, the department its available in and the second table had data like the salesperson who is handling the category, the department and the location.
After i had created the tables in excel file i imported it to zoho database. after successfully storing the database, i created three querry based table.
my first query was about the products which are priced above Rs.1000.
My second query was about all stores located outside kolkata with their salemen.
and finally my third query was about category having only womens clothing line.
the link for the data base has been given below.
RETAILIA