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
Wednesday, February 20, 2008
Subscribe to:
Post Comments (Atom)

1 comment:
looks good
Post a Comment